When I try to connect to an Informix database (via ASP) located on another machine on our LAN, I get the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
How do I avoid this?
I don't do much VB programming, so this suggestion may be way out in left field. Try verifying that the PASSW, ID, and MYDB variables are set properly in your program to indicate the data set name. Your error message indicates that it may be a problem with the original connection, and the DSN is a prime suspect.