RE: Problem connecting via ADO - revised

Posted in 2003

Sathyanesh Krishnan — Tue, 5 Aug 2003 11:15:28 -0500 — source: Usenet: comp.databases.informix

Hi Phil, It looks like the server name you are passing in the connection string is not matching with the actual server name. Just check whether is there any INFORMIXSERVER environment variable exist and that points to some different name or note. It is not necessary to have the INFORMIXSERVER environment variable (client side), you can remove it if you want. Regards, Satyan. |---------+----------------------------> | | "Phil Homburger" | | | <phil@lawbase.com| | | > | | | | | | 08/05/2003 11:02 | | | AM | | | Please respond to| | | phil | |---------+----------------------------> >------------------------------------------------------------------------------------------------------------------------------| | | | To: Sathyanesh Krishnan/Lenexa/IBM@IBMUS | | cc: | | Subject: RE: Problem connecting via ADO - revised | >------------------------------------------------------------------------------------------------------------------------------| Satyan - I figured out that the INFORMIXDIR envirnment variable was pointing to the wrong place. I fixed that & now get the error: [Informix][Informix ODBC Driver][Informix]INFORMIXSERVER does not match either DBSERVERNAME or DBSERVERALIASES. Thanks again. I think I'm almost there. - Phil -----Original Message----- From: Sathyanesh Krishnan [mailto:satyan@us.ibm.com] Sent: Friday, August 01, 2003 4:43 PM To: Phil Homburger Cc: informix-list@iiug.org; owner-informix-list@iiug.org Subject: Re: Problem connecting via ADO Hi Phil, The driver name has changed >From "INFORMIX 3.82 32 BIT" To "IBM INFORMIX 3.82 32 BIT" Just replace the DRIVER part from the connection string as follow, it should work DRIVER={IBM INFORMIX 3.82 32 BIT}; Regards, Satyan. |---------+----------------------------> | | phil@lawbase.com | | | (Phil Homburger) | | | Sent by: | | | owner-informix-li| | | st@iiug.org | | | | | | | | | 08/01/2003 10:01 | | | AM | | | Please respond to| | | phil | |---------+----------------------------> >--------------------------------------------------------------------------- ---------------------------------------------------| | | | To: informix-list@iiug.org | | cc: | | Subject: Re: Problem connecting via ADO | >--------------------------------------------------------------------------- ---------------------------------------------------| I think I have the setnet32 utility configured correctly. The service name is 'sqlexec'. When using the following in the VB code I get the error: [Microsoft][ODBC Driver Manager]Datasource name not found and no default driver specified. .ConnectionString = "Provider=MSDASQL; DRIVER={INFORMIX 3.82 32 BIT}; " _ & "DB=databasename; HOST=sql_dev; " _ & "SRVR=ONLINE; SERV=sqlexec; PRO=onsoctcp; " _ & "UID=username; " _ & "PWD=password; " This would be my preferred method of connection if I can get it to work. I am using the latest Informix Connect. Thanks for the help. - Phil sending to informix-list