https://pickwiki.org/index.php?action=history&feed=atom&title=GetUniOleDbWorkingGetUniOleDbWorking - Revision history2026-04-28T21:38:34ZRevision history for this page on the wikiMediaWiki 1.43.0https://pickwiki.org/index.php?title=GetUniOleDbWorking&diff=1830&oldid=prevConversion script: link fix2015-02-26T23:48:54Z<p>link fix</p>
<p><b>New page</b></p><div>Reposted from the original message on getting <nowiki>UniOleDB</nowiki> working:<br />
<br />
http://www.mail-archive.com/u2-users%40listserver.u2ug.org/msg01838.html<br />
<br />
<b>Question:</b><br />
<br />
We installed Unidata 6.0 on the Unix server and the Middleware <br />
client on<br />
<nowiki>WindowsXP</nowiki>. On the list of drivers in Windows under Adminstrative<br />
<nowiki>Tools/Data</nowiki> Source, I only see the IBM Unidata ODBC driver but not the<br />
<nowiki>UniOledb</nowiki> Driver. I made sure <nowiki>UniOleDB</nowiki> was clicked when I installed<br />
<nowiki>UniDK</nowiki>, however it does not want to show up. I did setup the uci.config<br />
file correctly. Please could you tell me how I could check whether<br />
<nowiki>UniOledb</nowiki> is setup and working and what is the quickest way to do it. <br />
<br />
<b>Answer:</b><br />
<br />
The <nowiki>OleDB</nowiki> drivers are a little different. Do two things to test them:<br />
<br />
1. Create a file on my desktop called myconnection.udl. When you open this<br />
file it is a data link properties item. Change the driver to [[UniData]] on the<br />
providers tab. Enter the settings in the connection tab. The Data Source is<br />
looking for the data source name you created with the uci config (like<br />
localud). Careful, it's case-sensitive. The location is either a database<br />
you have defined in ud_database or the full path the account (eg.<br />
c:\unidata\demo). I check Use a specific user name and password and allow<br />
saving password and make sure blank password is unchecked. Then I enter a<br />
valid user name and password and then click the test connection button. It<br />
should say OK. You may want to delete this file when you are done as it is<br />
actually a plain text file with the user and password in clear text.<br />
<br />
Once 1 is successful use:<br />
<br />
2. From http://gpoulose.home.att.net/ (deadlink) download the Query Tool (using<br />
ADO). You then connect with it (much like the .udl file). It will let you<br />
browse the tables/views setup with VSG as well as directly enter SQL<br />
statements. There is also a query tool for ODBC that you can use to test<br />
your ODBC setup.<br />
<br />
The biggest "gottcha" is that many things are case-sensitive that you may<br />
not expect. Treating everything as case-sensitive seems to really help<br />
prevent problems.</div>Conversion script