dynamic creation of Data Source Name(DSN) programatically , help needed urgent
thottempudi chowdhary
Greenhorn
Joined: Oct 05, 2001
Posts: 1
posted
0
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.