Problem connecting via ADO - revised

[Sathyanesh Krishnan]

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: [email]informix-list@iiug.org[/email]; [email]owner-informix-list@iiug.org[/email]
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.




|---------+---------------------------->
| | [email]phil@lawbase.com[/email] |
| | (Phil Homburger) |
| | Sent by: |
| | owner-informix-li|
| | [email]st@iiug.org[/email] |
| | |
| | |
| | 08/01/2003 10:01 |
| | AM |
| | Please respond to|
| | phil |
|---------+---------------------------->

>---------------------------------------------------------------------------

---------------------------------------------------|
|
|
| To: [email]informix-list@iiug.org[/email]
|
| 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

[Sathyanesh Krishnan]

Hi Phil,

The connection string look find to me except a small change
Since you already specified the server name through “Data Source� option
"Data Source=son_db@WENMM_ELITE;"
You don’t need to specify "Server� option.
& "Server=WENMM_ELITE;" _

By using the connection string the ADO application will uses
IBM Informix OLE DB driver to communicate with the database server.

To function the OLE DB driver smoothly you should
run an SQL ($INFORMIXDIR\etc\coledbp.sql) against
the “sysmaster� database of the server as user “Informix�.
(Only user Informix has the privilege to modify the sysmaster)

In case if you want to remove all the changes made by coledbp.sql
You can run another SQL ($INFORMIXDIR\etc\doledbp.sql) against the
Sysmaster database as user Informix.

Regards,
Satyan.




|---------+---------------------------->
| | "Phil Homburger" |
| | <phil@lawbase.com|
| | > |
| | |
| | 08/05/2003 12:51 |
| | PM |
| | Please respond to|
| | phil |
|---------+---------------------------->

>------------------------------------------------------------------------------------------------------------------------------|

| |
| To: Sathyanesh Krishnan/Lenexa/IBM@IBMUS |
| cc: |
| Subject: RE: Problem connecting via ADO - revised |

>------------------------------------------------------------------------------------------------------------------------------|

Satyan -

I switched to ADO since that's how I ultimately want to connect. Here's my
connection string:
.ConnectionString = "Provider=Ifxoledbc;" _
& "Server=WENMM_ELITE;" _
& "Data Source=son_db@WENMM_ELITE;" _
& "User ID=informix;" _
& "Password=password;"

It seems to connect but I get an error:
Method '~' of object '~' failed.

Any ideas? THanks.

- Phil

sending to informix-list