Skip to Content

Connecting Problum of SQL

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````

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Jun 12, 2007 at 12:06 PM

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

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

    Best Regards,

    Marcel

    Add comment
    10|10000 characters needed characters exceeded

    • 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````

  • avatar image
    Former Member
    Jun 12, 2007 at 10:11 AM

    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]

    Add comment
    10|10000 characters needed characters exceeded