Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Connecting to a remote host

 
cardwell cupp
Ranch Hand
Posts: 66
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am working with a project that is able to transfer databases to various work stations. Right now, I can connect easily to a database that is on the same workstation. Now I would like to connect to a host that is not on the network. I have researched the documentation on the formation of the url..and here is what I found.
url should be something like:
jdbc dbc://hostname ort/subsubname
(assuming that the driver name is odbc)
so that is how I format the url string...but the only problem is that I get an exception:
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified has occurred during connection
I am not sure what else to try. I have also looked into creating a System DSN to the host. But when looking in the ODBC Data Sources tool, I can't see any way to make a DSN to a host that is not on the server...
Am I forming the url wrong...if so what should it be. If not, what else could be the problem
Thanks
Cardwell
 
asnmurthy
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi, if you are bale to connect to the other databases from your machine using sqlplus, then you should be able to connect to those databases by crating a DSN in using ODBC datasources in control panel. If you can send me your code, I can solve your problem. I think the URL which you gave, is not in the proper format.
if you are going to use jdbc dbc bridge, then the syntax would be like this.
Connection con = DriverManager.getconnection("jdbc dbc:yourdatasourcename","userid","password");
I hope this would help you otherwise send me an email to
A.Murthy@gecapital.com
Regards,
Murthy
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic