We try to access the Max. DB using Microsoft Active Server Pages using the code below. (Maximizer ODBC driver is installed):

Set objConn = Server.CreateObject("ADODB.Connection")
strConnection = "ODBC;DATABASE=myDB;UID=sa;PWD='';DSN=myDSN"
objConn.Open strConnection


However we keep getting this error message. Can anybody help out?

Microsoft OLE DB Provider for ODBC Drivers- Fehler '80004005'

[Maximizer][ODBC Driver][Btrieve Database]Bad/missing ODBC.INI or entry in it

/IISSamples/Default/test6.asp, line 15

Hi,

The logon as sa looks a bit iffy as unless your trying to bypass the Maximizer ODBC driverand have a Maximizer.SQL product you should have a vaid maximizer user account and password.

You say the driver is installed, I assume you've created the database source?

ODBC.INI is a part of the registry that helps locate the actual data so if you've definitly created the source you may need to check its available to the user context running the asp page. Don't use USER odbc sources only System ones.

Regards,

Ian Wallace
CABC, Newbury