Skip to Content
Former Member
Nov 08, 2011 at 09:03 AM

jdbc driver issue


hi everyone,

I wanted to install JDBC V 1.2 driver for sqlserver in my Potal System 7.00 SP18 for connecting to third party system which has SQLserver 2008 R2 as database

i downloaded a hotfix version of 1.2 from -> SQL Server

when i untarred it, i got SQLJDBC.JAR file which i have installed throu' Visual admin. But when i executed a test sql statement it gave the below given error message:

java.rmi.RemoteException: SQL statement(s) cannot be executed over DataSource "XXXDATASOURCE". If you are using an Open SQL DataSource, you must register your tables using JDDI before you request them. Reason: Invalid object name 'dual'. [id = Unknown]

My question is how many .jar files will be coming for v 1.2 jdbc driver.this is just to make sure my installation procedure is correct and what exactly the erro message says?

can some one help me in resolving this issue as this is very very critical