ODBC Connection in ASP
Posted in 1999
Topics: Connectivity: ODBC / JDBC / .NET
Hi All, I am using visual interdev to develop some database applications in NT4.0. I created an ODBC data source for informix universal server( the database server, web server and NT server are on the same machine). The data source can be added to my project and i can see all the tables and data in the tables, but when i run my program, it says "ODBC driver can't be loaded", but it does exist. I also login as administrator and run "regcopy". What are the problems ? Currently the way i can do is to import the Informix data source to a MS Access database and use the access database as a front end. Anyone who succeed in connecting informix database server using ODBC in Active server page project ? Thanks ! I will be appreciated at any suggestions !!! ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com
Hi, I am assuming you are using the Intersolve ODBC driver which comes with Informix. The problem is the rights of the web. See attached doc from Intersolve's DataDirect Knowledgebase. Hope this helps. Allen wenting hou wrote: > Hi All, > > I am using visual interdev to develop some database applications > in NT4.0. I created an ODBC data source for informix universal > server( the database server, web server and NT server are on the same > machine). The data source can be added to my project and i can see all > the tables and data in the tables, but when i run my program, it says > "ODBC driver can't be loaded", but it does exist. I also login as > administrator and run "regcopy". What are the problems ? > Currently the way i can do is to import the Informix data source to > a MS Access database and use the access database as a front end. > Anyone who succeed in connecting informix database server using ODBC > in Active server page project ? Thanks ! > > I will be appreciated at any suggestions !!! > > ______________________________________________________ > Get Your Private, Free Email at http://www.hotmail.com
Hi, what does it meaning: Microsoft VBScript runtime error '800a01ad' ActiveX-Komponenten kann kein Objekt erstellen (can't create an object) test.asp, line 28 Line 28 is Set oCon = Server.CreateObject("ADODB.Connection") any ideas may be to configure my iis30, nt40,sp3, option-pack? A test-connecting is ok. ODBC-connecting is olso ok. -- [Email] mailto:Celal.Memili@telekom.de wenting hou <houwt@hotmail.com> schrieb im Beitrag <7a9q09$2ka$1@news.xmission.com>... > > Hi All, > > I am using visual interdev to develop some database applications > in NT4.0. I created an ODBC data source for informix universal > server( the database server, web server and NT server are on the same > machine). The data source can be added to my project and i can see all > the tables and data in the tables, but when i run my program, it says > "ODBC driver can't be loaded", but it does exist. I also login as > administrator and run "regcopy". What are the problems ? > Currently the way i can do is to import the Informix data source to > a MS Access database and use the access database as a front end. > Anyone who succeed in connecting informix database server using ODBC > in Active server page project ? Thanks ! > > I will be appreciated at any suggestions !!! > > > > ______________________________________________________ > Get Your Private, Free Email at http://www.hotmail.com >