Question:
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?
Answer:
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.
Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.
