This week's book giveaway is in the Mac OS forum.
We're giving away four copies of a choice of "Take Control of Upgrading to Yosemite" or "Take Control of Automating Your Mac" and have Joe Kissell on-line!
See this thread for details.
The moose likes JDBC and the fly likes dynamic creation of Data Source Name(DSN) programatically , help needed urgent Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Bookmark "dynamic creation of Data Source Name(DSN) programatically , help needed urgent" Watch "dynamic creation of Data Source Name(DSN) programatically , help needed urgent" New topic
Author

dynamic creation of Data Source Name(DSN) programatically , help needed urgent

thottempudi chowdhary
Greenhorn

Joined: Oct 05, 2001
Posts: 1
i am geting the following error, when i run the program
[Microsoft][ODBC Driver Manager] Data source name too long

the code that i have written is
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc dbc river={MicroSoft Access Driver (*.mdb)};DBQ=C:/ROSA97.mdb","","");
i wanted dynamic creation of DSN programatically only, as my client does not know how to create DSN manually(through control panel). so someone please tell me what is wrong in the above code.

thanks in advance.
kiran


kiran
 
GeeCON Prague 2014
 
subject: dynamic creation of Data Source Name(DSN) programatically , help needed urgent