Can you make an ODBC connection through the JDBC-ODBC...
1 posts in topic
Flat View  Flat View
Older Post First |   Reply to Topic
TOPIC ACTIONS:
 

Posted By:   David_Roman
Posted On:   Friday, March 16, 2001 06:37 AM

Can you make an ODBC connection through the JDBC-ODBC bridge head without having to use the host computers DSN's (data source names)? For example: if the database server is called TESTSQL and the database is called dbTest and the host computer has a DSN for it called myTestDB then I would use "jdbc:odbc:myTetstDB" as the URL. What if the host computer does not have any DSN's? Can I make the connection? The database server in this case is Microsoft SQL 7.0.

Report | Quote This | Send private message | Reply | Print

Re: Can you make an ODBC connection through the JDBC-ODBC...

Posted By:   Paul_Lee  
Posted On:   Tuesday, May 22, 2001 04:43 PM

I don't think so. Since the jdbc-odbc bridge works relies on the DSN being setup propertly on the mechines. There are some workarrounds like using a different 3rd party driver which allows you to specifly the path to get to the data source.
Report | Quote This | Send private message | Reply | Print
About | Sitemap | Contact