The Dope may not be the best place for a question like this, but I have posted it in 3 technical forums without results. Not a good sign.
So here goes. You guys are my last hope.
This is my first shot ASP but I do have a fair amount of VBA experience.
Anyway, My ADODB.Connection fails in the ASP page
CODE -
set conShark = Server.CreateObject(“adoDB.CONNECTION”)
conShark.Open “DSN=SYSinformix33;UID=test;PWD=test”
ERROR in IE 5.5 -
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Driver’s SQLSetConnectAttr failed
/asp/test1.asp, line 64
The DSN is good. It works when you perform a test connect in the ODBC manager, as well as a different VB application.
I get the same error when I use a connect string instead of a DSN.
I don’t get an error when I create the ADODB object. It happens when trying to open it.
Any ideas what may be causing the error. I’m running in circles.
As the reference that zedan provides indicates, it may be one of those annoying non-error error codes (there’s another one that crops up occasionally, where the DBMS wants to tell you that there’s some default behaviour happening that isn’t always what programmers intend).
Make sure that the DSN you created on the web server is defined as “system” and not “user.” As well, you might want to go from using a DSN to an explict connection string:
Dim ConnectString
ConnectString="driver={SQL Server};server=TestServer;database=TestDB;uid=test;pwd=test"
Set conShark=Server.CreateObject("ADODB.Connection")
conShark.Open ConnectString
(Sorry, it appears that you’re using an Informix database, but I was too lazy to go and look up the driver name for Informix.)