MS Access connection using ODBC from NAV 2009 R2 RTC

Gabry · 2013-09-18

I got successully the connection to an Access DB using ODBC provider "DSN user" using "Microsoft Access Driver (*.mdb)" driver (version 4.006305.00, ODBCJT32.DLL) on a Windows XP Professional 32-bit Platform as shown in the code below:

  SQLConnectionString := 'C:\AF\DecryptDatabase.mdb';
  ODBCConnection := ODBCConnection.OdbcConnection(SQLConnectionString);
  ODBCConnection.Open();
  ODBCCommand := ODBCConnection.CreateCommand();
  ODBCCommand.CommandText := 'select * from tablename';
  ODBCReader := ODBCCommand.ExecuteReader();

I moved exactly the same code on a Windows Server 2012 64-bit Platform using the same ODBC provider "DSN user" using "Microsoft Access Driver (*.mdb)", but with a more recent driver version (6.00).

Running the same code, it occurs the following error (see the attached picture to look at whole error message):

"The call to member Open failed: error [hy000] [Microsoft] [odbc microsoft access driver] Disk or network error"

I have already checked permissions on the database folder (now is locally to the client).

Please do you have any ideas how to solve this problem?

ppavuk · 2013-09-18

The database is on client, but your code is run on middle tier. That why it fails i think.

Gabry · 2013-09-18

ppavuk wrote:

The database is on client, but your code is run on middle tier. That why it fails i think.

Sorry maybe that is not why it fails because I tried to allocate the same database in different machine using the LAN (changing the connection string, e.g. \\client1\databasefolder\database.mdf) and it work perfectly in the right environment. I suppose that it is different problem.

Please do you have any other insights?

Thank you

ppavuk · 2013-09-18

Maybe there is some problems with x64 ODBC provider. RTC client still 32 bit...
No better ideas...

Savatage · 2013-09-18

I don't know if this is helpful but I had a 64 bit machine and finally got my odbc to work but I had to access the 32bit administrator tool instread of the 64 bit to get it work work properly.

http://support.microsoft.com/kb/942976

Odbcad32.exe

MS Access connection using ODBC from NAV 2009 R2 RTC

Comments

Categories