Hello All,
Some time ago I created an agent which connects to an SQL data source and populates the database in which it runs. It is scheduled to run nightly and has done so without any problems, connecting to the RDBMS as follows;
public static String _drv = “sun.jdbc.odbc.JdbcOdbcDriver”;
//Create the JDBC Driver Object
Driver drv = (Driver) Class.forName(_drv).newInstance();
//Create a New Properties Object
Properties p = new Properties();
p.put(“user”, dbuser);
p.put(“password”, dbpwd);
//Create a sql Connection
con = drv.connect(_url, p);
stmtEMDET = con.createStatement();
Last week we migrated the server it runs on to 6.0.2 (from 5), and the agent now throws SQLException “Invalid property values ” at the line;
con = drv.connect(_url, p);
I have checked that p is set as before and that the username/password are still valid. I have set up the odbc driver with the same name so I don’t think there’s a problem with _url. The agent compiles ok and I can still run it locally (5.0.11).
Anyone have any ideas why this might be?
Thanks in advance
Dan