Accessing Max. DB by Active Server Pages

peterNew Member

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

2/15/013:02 PM

❤️ 0

Original Post

ianwallaceNew Member

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

2/16/016:09 AM

❤️ 0

Skip to main content

Add Reply

Membership Required

Remove From Your Block List

Manage Follow Preferences

Block

Please wait...