Re: DSN-less and oledb connection scrint for Informix using OpenLink

Posted in 2003

Sheshnarayan Agrawal — Thu, 18 Dec 2003 12:54:39 -0600 — source: Usenet: comp.databases.informix

--0__=08BBE493DFF4E1448f9e8a93df938690918c08BBE493DFF4E144 Content-type: multipart/alternative; Boundary="1__=08BBE493DFF4E1448f9e8a93df938690918c08BBE493DFF4E144" --1__=08BBE493DFF4E1448f9e8a93df938690918c08BBE493DFF4E144 Content-type: text/plain; charset=US-ASCII The following is the example of DSN-less connection string using IBM Informix Provider(s) : In order to get the DSN-less connection pl. make sure SQLHOST info is not there in the registry. Using ODBC Driver : ---------------------------- "Provider=MSDASQL; DRIVER={IBM INFORMIX 3.82 32 BIT}; DB=stores7; " & _ "HOST=<host name>; SRVR=<server name>; SERV=<service number>; PRO=onsoctcp; UID=<user name>; " & _ "PWD=<password>;OLE DB Services=-4;" Using OLEDB Prodvider : ------------------------------------- "Provider=Ifxoledbc;Data Source=<db name@server name>;User ID=<user name>;Password=<passwprd>;" HTH -Shesh kstahl <ktsahl@yahoo.com To: informix-list@iiug.org > cc: Sent by: Subject: DSN-less and oledb connection scrint for Informix using OpenLink owner-informix-li st@iiug.org 12/18/2003 08:56 AM Please respond to kstahl I've recently started to work with performing queries against an Informix 2000 database using the OpenLink drivers and ADO. I've figured out to use a DSN connection string in my VBScript, but I would prefer to use a DSN-less connection. I would also like to try an oledb connection string. Does anyone have a DSN-less connection string that they can share? If I know what values I need to provide I can take it from there. Same thing with the oledb connection string. Any help will be appreciated. --1__=08BBE493DFF4E1448f9e8a93df938690918c08BBE493DFF4E144 Content-type: text/html; charset=US-ASCII Content-Disposition: inline <html><body> The following is the example of DSN-less connection string using IBM Informix Provider(s) : In order to get the DSN-less connection pl. make sure SQLHOST info is not there in the registry. Using ODBC Driver : ---------------------------- "Provider=MSDASQL; DRIVER={IBM INFORMIX 3.82 32 BIT}; DB=stores7; " & _ "HOST=<host name>; SRVR=<server name>; SERV=<service number>; PRO=onsoctcp; UID=<user name>; " & _ "PWD=<password>;OLE DB Services=-4;" Using OLEDB Prodvider : ------------------------------------- "Provider=Ifxoledbc;Data Source=<db name@server name>;User ID=<user name>;Password=<passwprd>;" HTH -Shesh <img src="cid:10__=08BBE493DFF4E1448f9e8a93df938@us.ibm.com" width="16" height="16" alt="Inactive hide details for kstahl <ktsahl@yahoo.com>">kstahl <ktsahl@yahoo.com> <table V5DOTBL=true width="100%" border="0" cellspacing="0" cellpadding="0"> <tr valign="top"><td width="1%"><img src="cid:20__=08BBE493DFF4E1448f9e8a93df938@us.ibm.com" border="0" height="1" width="72" alt=""> </td><td style="background-image:url(cid:30__=08BBE493DFF4E1448f9e8a93df938@us.ibm.com); background-repeat: no-repeat; " width="1%"><img src="cid:20__=08BBE493DFF4E1448f9e8a93df938@us.ibm.com" border="0" height="1" width="225" alt=""> <ul> <ul> <ul> <ul>kstahl <ktsahl@yahoo.com> Sent by: owner-informix-list@iiug.org 12/18/2003 08:56 AM Please respond to kstahl</ul> </ul> </ul> </ul> </td><td width="100%"><img src="cid:20__=08BBE493DFF4E1448f9e8a93df938@us.ibm.com" border="0" height="1" width="1" alt=""> To: informix-list@iiug.org cc: Subject: DSN-less and oledb connection scrint for Informix using OpenLink</td></tr> </table> I've recently started to work with performing queries against an Informix 2000 database using the OpenLink drivers and ADO. I've figured out to use a DSN connection string in my VBScript, but I would prefer to use a DSN-less connection. I would also like to try an oledb connection string. Does anyone have a DSN-less connection string that they can share? If I know what values I need to provide I can take it from there. Same thing with the oledb connection string. Any help will be appreciated. </body></html> --1__=08BBE493DFF4E1448f9e8a93df938690918c08BBE493DFF4E144-- --0__=08BBE493DFF4E1448f9e8a93df938690918c08BBE493DFF4E144 Content-type: image/gif; name="graycol.gif" Content-Disposition: inline; filename="graycol.gif" Content-ID: <10__=08BBE493DFF4E1448f9e8a93df938@us.ibm.com> Content-transfer-encoding: base64 R0lGODlhEAAQAKECAMzMzAAAAP///wAAACH5BAEAAAIALAAAAAAQABAAAAIXlI+py+0PopwxUbpu ZRfKZ2zgSJbmSRYAIf4fT3B0aW1pemVkIGJ5IFVsZWFkIFNtYXJ0U2F2ZXIhAAA7 --0__=08BBE493DFF4E1448f9e8a93df938690918c08BBE493DFF4E144 Content-type: image/gif; name="ecblank.gif" Content-Disposition: inline; filename="ecblank.gif" Content-ID: <20__=08BBE493DFF4E1448f9e8a93df938@us.ibm.com> Content-transfer-encoding: base64 R0lGODlhEAABAIAAAAAAAP///yH5BAEAAAEALAAAAAAQAAEAAAIEjI8ZBQA7 --0__=08BBE493DFF4E1448f9e8a93df938690918c08BBE493DFF4E144 Content-type: image/gif; name="pic29597.gif" Content-Disposition: inline; filename="pic29597.gif" Content-ID: <30__=08BBE493DFF4E1448f9e8a93df938@us.ibm.com> Content-transfer-encoding: base64 R0lGODlhWABDALP/AAAAAK04Qf79/o+Gm7WuwlNObwoJFCsoSMDAwGFsmIuezf///wAAAAAAAAAA AAAAACH5BAEAAAgALAAAAABYAEMAQAT/EMlJq704682770RiFMRinqggEUNSHIchG0BCfHhOjAuh EDeUqTASLCbBhQrhG7xis2j0lssNDopE4jfIJhDaggI8YB1sZeZgLVA9YVCpnGagVjV171aRVrYR RghXcAGFhoUETwYxcXNyADJ3GlcSKGAwLwllVC1vjIUHBWsFilKQdI8GA5IcpApeJQt8L09lmgkH LZikoU5wjqcyAMMFrJIDPAKvCFletKSev1HBw8KrxtjZ2tvc3d5VyKtCKW3jfz4uMKmq3xu4N0nK BVoJQmx2LGVOmrqNjjJf2hHAQo/eDwJGTKhQMcgQEEAnEjFS98+RnW3smGkZU6ncCWav/4wYOnAI TihRL/4FEwbp28BXMMcoscQCVxlepL4IGDSCyJyVQOu0o7CjmLN50OZlqWmyFy5/6yBBuji0AxFR M00oQAqNIstqI6qKHUsWRAEAvagsmfUEAImyxgbmUpJk3IklNUtJOUAVLoUr1+wqDGTE4zk+T6FG uQb3SizBCwatiiUgCBN8vrz+zFjVyQ8FWkOlg4NQiZMB5QS8QO3mpOaKnL0Z2EKvNMSILEThKhCg zMKPVxYJh23qm9KNW7pArPynMqZDiErsTMqI+LRi3QAgkFUbXpuFKhSYZALd0O5RKa