https://pickwiki.org/index.php?action=history&feed=atom&title=VBOleDbConnectionVBOleDbConnection - Revision history2026-04-28T23:40:32ZRevision history for this page on the wikiMediaWiki 1.43.0https://pickwiki.org/index.php?title=VBOleDbConnection&diff=2421&oldid=prevConversion script: link fix2015-02-26T23:48:56Z<p>link fix</p>
<p><b>New page</b></p><div>Here is a simple VB procedure that shows the OLE connection string needed for [[UniData]] connection (you will need to have the Unidata OLE DB client software loaded on your PC)<br />
<br />
<pre><br />
Sub [[Test_OLE_Connection]]()<br />
Dim cnnConnection<br />
Dim rstTable<br />
Dim strCommand<br />
Dim strConnect<br />
<br />
Set cnnConnection = [[CreateObject]]("ADODB.Connection")<br />
Set rstTable = [[CreateObject]]("ADODB.Recordset")<br />
<br />
strConnect = "Provider=Informix.[[UniOLEDB]].1;Password=<password>;User ID=<logon ID>;Data Source=<database name in uci.config>"<br />
<br />
cnnConnection.Open strConnect<br />
<br />
'Sample SQL command<br />
strCommand = "select * from <file name> where ID = '<ID>'"<br />
<br />
rstTable.Open strCommand, cnnConnection, , , 0<br />
<br />
'rest of your code here<br />
<br />
End Sub<br />
</pre></div>Conversion script