RE: Problem connecting via ADO - revised

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