Re: ASP / ADO connection to Informix
Posted in 2003
Topics: Installation, Setup & Upgrades, Connectivity: ODBC / JDBC / .NET
Thanks for the answer! Actually, the first thing I tried was to create Systen DSN & use "DSN=informix" as the connection string; it felt like the easiest method. Also, I had heard that the driver has has problems with long paths, so I installed it to c:\\informix\\. BTW, i don't believe anymore that the problem is with user rights. I changed the IIS anonymous login fron IUSR_machine to my own username&passwd, and connection attempt gave the same errmsg. (As I said before, I _can_ connect to db using other applications such as WinSQL or MS Access with the same user id) The 3.81 driver could be the solution. I just don't know if I am able to acquire this, because this driver was provided to us by a third party company for connecting to their informix-db. I'll keep on trying to eliminate possible problem causes. I still would appreciate any ideas about solving this problem. If I am able to solve this, I'll post the problem & solution. -Eero Howard Salter <HowardSalter@penningtonseed.com> wrote in message news:<bf92pb$214$1@terabinaries.xmission.com>... > Have you created a System DSN for the connection and just used the > connection string "DSN=informix"? Also, you may want to consider downloading > the 3.81 driver. I had problems with the 3.32 driver. One more thing that > may sound crazy, I found that if I installed the SDK (and subsequently the > drivers) to the default dir (i.e. C:\\program files\\informix), it choked on > the long filename, but when I changed the install dir to C:\\Informix it > worked just fine. > > HTH, > Howard