Connecting to a Progress database

[emozley]

I have set up a system DSN and am trying to call it from an ASP page. Am getting an error though

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[DataDirect-Technologies][ODBC PROGRESS driver]Insufficient information to connect to the data source.
/sos/index.asp, line 7

The credentials work when I test them in ODBC so am not sure where I'm going wrong - any ideas?

Also because the database is named in the DSN do I have to name it again in the connection string?

Thanks very much

Ed


<%

Set DB = Server.CreateObject("ADODB.Connection")
Set TBL = Server.CreateObject("ADODB.RecordSet")

DB.Mode = adModeReadWrite
DB.Open ("DRIVER=MERANT 3.60 32-BIT PROGRESS SQL92 v9.1D; DSN=SOS; UID='username'; PWD='password'; database='sosdb';")

Response.Write("Connection established!")

Set TBL=Nothing
Set DB=Nothing

%>
SOS Reporting

 

[guitardave78]

db.Open "DSN=SOS;UID=username;PWD=password"


What OS are you using?


}...the bane of my life!

http://www.fuzzyd.co.uk