I too am not able to view data. I am running Unidata 6.0 and have several
working ODBC applications. I have had success with creating and connecting
with the .udl file mentioned in 1. I have had success with the ODBC tool
downloaded from the website but cannot see any of the table views in the OLEDB
tool. Any suggestions would be appreciated.
> The OleDB drivers are a little different. I do two things to test them:
>
> 1. Create a file on my desktop called myconnection.udl. When you open this
> file it is a data link properties item. Change the driver to UniData on the
> providers tab. Enter the settings in the connection tab. The Data Source is
> looking for the data source name you created with the uci config (like
> localud). Careful, it's case-sensitive. The location is either a database
> you have defined in ud_database or the full path the account (eg.
> c:\unidata\demo). I check Use a specific user name and password and allow
> saving password and make sure blank password is unchecked. Then I enter a
> valid user name and password and then click the test connection button. It
> should say OK. You may want to delete this file when you are done as it is
> actually a plain text file with the user and password in clear text.
>
> Once 1 is successful I use:
>
> 2. From http://gpoulose.home.att.net/ I downloaded the Query Tool (using
> ADO). You then connect with it (much like the .udl file). It will let you
> browse the tables/views setup with VSG as well as directly enter SQL
> statements. There is also a query tool for ODBC that you can use to test
> your ODBC setup.
>
> The biggest "gottcha" is that many things are case-sensitive that you may
> not expect. Treating everything as case-sensitive seems to really help
> prevent problems.
>
> Good luck
>
> --
> Colin Alfke
> Calgary, Alberta Canada
>
> "Just because something isn't broken doesn't mean that you can't fix it"
>
> Stu Pickles
>
>
> >-----Original Message-----
> >From: Lynn Fernando [mailto:[EMAIL PROTECTED]
> >Sent: Wednesday, July 07, 2004 11:27 AM
> >To: [EMAIL PROTECTED]
> >Subject: [U2] Cannot see UniOleDB drivers
> >
> >
> >We installed Unidata 6.0 on the Unix server and the Middleware
> >client on
> >WindowsXP. On the list of drivers in Windows under Adminstrative
> >Tools/Data Source, I only see the IBM Unidata ODBC driver but not the
> >UniOledb Driver. I made sure UniOleDB was clicked when I installed
> >UniDK, however it does not want to show up. I did setup the uci.config
> >file correctly. Please could you tell me how I could check whether
> >UniOledb is setup and working and what is the quickest way to do it.
> >Any help is greatly appreciated.
> >Thanks.
> >Lynn
> >-------
> >u2-users mailing list
> >[EMAIL PROTECTED]
> >To unsubscribe please visit http://listserver.u2ug.org/
> -------
> u2-users mailing list
> [EMAIL PROTECTED]
> To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
