Help with ASP 3.0 and Informix 9.0 on Unix
Ricardo's ASP 3.0 web page couldn't reach an Informix 9 database on Unix, failing with "Microsoft OLE DB Provider for ODBC Drivers error '80004005' ... Data source name not found and no default driver specified", even though the same ODBC DSN tested fine and worked from Windows desktop apps. Replies suggested the DSN must be a System DSN (not a User DSN) since IIS runs under a different account, and that DSN-less connections need registry write permission; another poster's suggestion to run coledbp.sql was noted as applying only to the Informix OLE DB provider, not the ODBC driver. Ricardo confirmed he was already using a System DSN and said he'd try the other advice, so no resolution is recorded in the thread.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi guys, i have a website built on asp 3.0 and i need to link it to an informix database hosted by a unix server, but i have problems when connect to, my odbc on windows works fine, i ran the test connection button at the odbc window and it works ok, my windows apps that work with informix using that odbc also works well but with the site i can't connect to informix, i get next error: Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified I've searched a lot but i can't find a solution =( what can i do? Regards. Ricardo.
sure it's a system DSN ? -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Sent: 31 July 2006 16:45 To: ids@iiug.org Subject: Help with ASP 3.0 and Informix 9.0 on Unix [7174] Hi guys, i have a website built on asp 3.0 and i need to link it to an informix database hosted by a unix server, but i have problems when connect to, my odbc on windows works fine, i ran the test connection button at the odbc window and it works ok, my windows apps that work with informix using that odbc also works well but with the site i can't connect to informix, i get next error: Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified I've searched a lot but i can't find a solution =( what can i do? Regards. Ricardo. **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum. *****DISCLAIMER***** Dit bericht en alle bijhorende zijn uitsluitend bestemd voor de geadresseerde en vertrouwelijk. Indien dit bericht niet voor U bestemd is, gelieve dit dan te vernietigen en de verzender te verwittigen. Openbaring, vermenigvuldiging, verspreiding en verstrekking aan derden is niet toegestaan, tenzij anders vermeld. Aangezien internet de integriteit van dit bericht niet kan verzekeren, kan de Dienst Vreemdelingenzaken niet verantwoordelijk gesteld worden indien dit bericht gewijzigd is. Bezoek onze website: http://www.dofi.fgov.be ---------------------------------------- *****DISCLAIMER***** Ce message et toutes les pieces jointes sont etablis a l'intention exclusive de ses destinataires et sont confidentiels. Si vous recevez ce message par erreur, merci de le detruire et d'en avertir l'expediteur. Toute utilisation de ce message non conforme a sa destination, toute diffusion ou toute publication, totale ou partielle, est interdite, sauf autorisation expresse. L'internet ne permettant pas d'assurer l'integrite de ce message, l'Office des Etrangers decline toute responsabilite au titre de ce message, dans l'hypothese ou il aurait ete modifie. Visiter notre site web: http://www.dofi.fgov.be
Ricardo, have you run the sql coledbp.sql agaist the sysmaster of unix database? if not, you must run it against sysmaster database, and you find it in windows sdk environment that you've set up your windows app server. if you have any doubts about it, the site below can help you http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.ol edb.doc/oledbmst29.htm Celso Coimbra ClearTech Ltda "Unlock your revenue" NOVO Tel: (019) 2104-4509 E-mail: ccoimbra@cleartech.com.br -----Mensagem original----- De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org]Em nome de RICARDO BLANCO Enviada em: segunda-feira, 31 de julho de 2006 11:45 Para: ids@iiug.org Assunto: Help with ASP 3.0 and Informix 9.0 on Unix [7174] Hi guys, i have a website built on asp 3.0 and i need to link it to an informix database hosted by a unix server, but i have problems when connect to, my odbc on windows works fine, i ran the test connection button at the odbc window and it works ok, my windows apps that work with informix using that odbc also works well but with the site i can't connect to informix, i get next error: Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified I've searched a lot but i can't find a solution =( what can i do? Regards. Ricardo. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
Hello, The coledbp.sql script is required if connecting with the Informix OLEDB provider. It is not required in order to connect via the Informix ODBC driver, even if the ODBC driver is used in conjunction with the Microsoft OLEDB/ODBC bridge. From the information provided, I'd guess a previous post was more in line... Running the application as an ASP page means that the connection is being made through the web service, and as such, the DSN must be a "System DSN" (as opposed to a "User DSN"). If you are using DSNless connections, you must have write access to the registry as a DSN is getting created and will be used during the connection attempt. ----- Original Message ----- From: "Celso Cabra...." <ccoimbra@cleartech.com.br> To: <ids@iiug.org> Sent: Monday, July 31, 2006 12:18 PM Subject: RES: Help with ASP 3.0 and Informix 9.0 on Unix [7176] > > Ricardo, > > have you run the sql coledbp.sql agaist the sysmaster of unix database? > if not, you must run it against sysmaster database, and you find it in > windows > sdk environment that you've set up your windows app server. > if you have any doubts about it, the site below can help you > > http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.ol edb.doc/oledbmst29.htm > > Celso Coimbra > ClearTech Ltda > "Unlock your revenue" > NOVO Tel: (019) 2104-4509 > E-mail: ccoimbra@cleartech.com.br > > -----Mensagem original----- > De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org]Em nome de RICARDO > BLANCO > Enviada em: segunda-feira, 31 de julho de 2006 11:45 > Para: ids@iiug.org > Assunto: Help with ASP 3.0 and Informix 9.0 on Unix [7174] > > Hi guys, i have a website built on asp 3.0 and i need to link it to an > informix database hosted by a unix server, but i have problems when > connect > to, my odbc on windows works fine, i ran the test connection button at the > odbc window and it works ok, my windows apps that work with informix using > that odbc also works well but with the site i can't connect to informix, i > get > next error: > > Microsoft OLE DB Provider for ODBC Drivers error '80004005' > > [Microsoft][ODBC Driver Manager] Data source name not found and no default > driver specified > > I've searched a lot but i can't find a solution =( > what can i do? > > Regards. > Ricardo. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > >
Yeap!!! it's system DSN
Oky Reece!! Let me try it also Thanks!