on 06-12-2007 10:56 AM
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````
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Just check Step 2 of this doc and see if it helps you.
Thanks & Regards
Harsimran
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]
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.