File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: dynamic creation of Data Source Name(DSN) programatically , help needed urgent