Connecting Problum of SQL

[former_member185086]

Hello Expert

I want to do integration of MSSQl 2000 to VC for that i follow "How to Create a Web Service using an Enterprise JavaBean Which Accesses the MS SQL Server" ,at last ,When we check that all seeting are correct or not,for that we fire one sql query.It gives the following error.

java.rmi.RemoteException: com.sap.engine.services.dbpool

.exceptions.BaseRemoteException: SQL statement(s)

cannot be executed over DataSource "MSSQLSERVER".

If you are using an Open SQL DataSource, you must register your tables using JDDI

before you request them. Reason: com.sap.engine.services.dbpool.exceptions.BaseSQLException:

ResourceException in method ConnectionFactoryImpl.

Please Help me

Regards

````Satish````

[Former Member · Accepted solution]

Did you try a jdbc connection as it is mentioned in the WIKI:

<a href="https://wiki.sdn.sap.com/wiki/display/VC/JDBCConnectionSetup">https://wiki.sdn.sap.com/wiki/display/VC/JDBCConnectionSetup</a>

Best Regards,

Marcel

[former_member185086 · Accepted solution]

Hi Marcel

I did according to that .Still Problum is unsovled

Best Regards

````Satish````

[Former Member · Accepted solution]

Hi

Just check Step 2 of this doc and see if it helps you.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/webservices/how%20...

Thanks & Regards

Harsimran

[former_member185086 · Accepted solution]

Hi

I again follow the same step 2 .But finally when i come to execute the query it give the error i.e "can not init the....".

Thanks for your interest but Problum is still there

regard

````Satish````

[praveenkumar_gudapati]

Hi,

This is a typical error which you get when your Datasources SQLEngine is configured to Open SQL and have not initialize the tables in your database in the Java Dictionary.

Check this for more:

http://help.sap.com/saphelp_nw70/helpdata/en/45/ef362dc57b1e46aa6f445ec6247103/frameset.htm

From the weblog, you missed to activate the Vendor SQL setting for your Datasource.

Greetings,

Praveen Gudapati

[Points are welcome for helpful answers]

[former_member185086]

Hy! Preveen

I Have already chose that "Vender SQL" among three option ,But still Problum

is unsolved

Please help me

````Satish````