-
1. Re: ODBC on Windows?
rareddy Oct 13, 2010 8:05 PM (in response to dvenus)David,
Please note that ODBC port number (default 35432) is different than that of JDBC (default 31000) when you are making ODBC connection. I also noticed the above described behavior when I was trying to connect ODBC client to a Teiid on JDBC port.
Hope this helps.
Ramesh..
-
2. Re: ODBC on Windows?
dvenus Oct 14, 2010 11:46 AM (in response to rareddy)Hi!
This is happening when using port 35432. I have it set up as a SYSTEM DSN - does that make a difference? I have attached screen shots of the DSN set up to help diagnose the problem.
Thanks again!
Dave Venus
-
teiid3.JPG 35.2 KB
-
teiid2.JPG 50.1 KB
-
teiid1.JPG 24.3 KB
-
-
3. Re: ODBC on Windows?
rareddy Oct 14, 2010 10:22 PM (in response to dvenus)David,
SYSTEM DSN should not be a issue. Check and make sure that on the JBoss AS console, Teiid started the ODBC. There should be a log message. Also have you used "localhost" while connecting through JDBC? If the hostname is not resolving correctly use the IP directly like 127.0.0.1
Ramesh..
-
4. Re: ODBC on Windows?
dvenus Oct 22, 2010 12:51 PM (in response to rareddy)Hi!
Sorry for the long delay. I am working on this problem again.
Where do I look in the JBOSS AS console to see if ODBC is started? I have looked thru all of the items in the tree but I don't see anything about ODBC. A screen shot of a correctly working console would be helpful.
Also where would I find the JBOSS AS or TEIID log that would tell me if the ODBC service had been started?
Any help that anyone can give is greatly appreciated!
Dave Venus
-
5. Re: ODBC on Windows?
rareddy Oct 23, 2010 11:15 AM (in response to dvenus)Dave,
Admin console does not have information about ODBC port is started or not. But if you see in the log, and in the console window (terminal window) where JBoss AS is started you will see a log message. By default ODBC port is enabled, unless you disabled or port is already taken by another process, Teiid should be able to accept ODBC connections if you got a valid VDB deployed in the Teiid runtime.
Ramesh..
-
6. Re: ODBC on Windows?
vikas252 Mar 26, 2012 3:10 AM (in response to rareddy)Hi Ramesh
I am facing a similar issue where in I have a similar setup. My teeid instance is on linux host and the client is on windows xp sp2. I have set up postgresql odbc driver locally and when I try to import tables from the teiid cdb, I can see the objects (tables, views) but can not see the column names via odbc connection. However all seems to be working when accessed via Squirrel.
Other details:
Jboss AS - 5.1
Teiid Designer - 7.4
Postgre odbc - 9.01
Thanks. Vikas
-
7. Re: ODBC on Windows?
rareddy Mar 26, 2012 1:07 PM (in response to vikas252)Vikas,
What is the client you are using? Can you try version 8.4.200 ODBC driver version. This is the version we have lot of testing with. We will move to 9.x version on Teiiid 8.0 version.
Ramesh..