I am trying to populate a drop down with available tables in a database.
in management studio I can use this query:
SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
When I bind that to the data property of the drop down box I get this error:
I am trying to populate a drop down with available tables in a database.
in management studio I can use this query:
SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
When I bind that to the data property of the drop down box I get this error:
Huh, thats weird. SQL Type code -9 isn’t defined. What JDBC driver and version of SQL Server are you using? (These “type codes” are defined in java.sun.com/j2se/1.5.0/docs/api … Types.html )
I was on a development laptop using SQL express 2008 with the new driver sqljdbc4.jar. I ended up switching back to the old driver that came with FactoryPMI. The query now works.
Oh, yeah, you can't use that jar file. Note the instructions I posted upgrading to the SQL server driver:
i.e. not sqljdbc4.jar.
You should be able to go back to the official SQL Server driver, just use the other jar file.
I had tried that initially, but I receive this error on the datasource page.
Ack, ok, I wasn’t expecting that. Do you get that if you start the Gateway using Java 5? (You can switch the path to jvm.dll in the registry for the Gateway under HKLM\SYSTEM\CurrentControlSet\Services\FactoryPMI\Parameters\JVM Library)
I’ll have to do some experimentation…
Yes jre 5 update 19 works.
Ok, thats good to know. Thanks for the feedback.