Import Database via JDBC issue

[sarvesh723]

I am trying to import a SQL Server database, located on a remote server, as a JDBC source in TEIID designer by creating a new connection profile.The connection profile works fine as the ping is successful. However, when I click next and move on to the 'Select Database Metadata' screen the Table Types section (tables and views) shows blank and I am unable to proceed further. Same database and teiid version on different machine works fine. But I am not sure if there is any settings or something on the server that is not alowing me to view the table types. Please advise.

[rareddy]

Are you using the same user? if Yes, try with JDBC client tools like SquirrL and see if you connect and see the tables from the same machine. If you do not see there then there is issue with user/driver etc., if you see the tables but not in Designer then there is some issue needs to be further investigated.

[sarvesh723]

Thanks Ramesh for the help. There was an issue with the driver. Fixed now