RE: [U2] Cannot see UniOleDB drivers
Hmmm I thought I was able to browse the tables with the ADO tool like I could with the ODBC tool but when I just tried it I couldn't. However, I was able to run select statements without problem (you can cut and paste them from the ODBC tool if you don't know how to create them). I had one project with OleDB access that I was testing the required SQL statements in it but that project was put on hold as our company was just assimilated by another one which is replacing our product with an MSSQL/Informix/Oracle based one hth -- 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, July 09, 2004 9:19 AM To: [EMAIL PROTECTED] Subject: RE: [U2] Cannot see UniOleDB drivers 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. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Cannot see UniOleDB drivers
Thanks. Sorry to hear about your conversion from U2. :( Hmmm I thought I was able to browse the tables with the ADO tool like I could with the ODBC tool but when I just tried it I couldn't. However, I was able to run select statements without problem (you can cut and paste them from the ODBC tool if you don't know how to create them). I had one project with OleDB access that I was testing the required SQL statements in it but that project was put on hold as our company was just assimilated by another one which is replacing our product with an MSSQL/Informix/Oracle based one hth -- 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, July 09, 2004 9:19 AM To: [EMAIL PROTECTED] Subject: RE: [U2] Cannot see UniOleDB drivers 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. --- 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/
RE: [U2] Cannot see UniOleDB drivers
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/