Error in configuring JDBC Adapter

10-11  Source: Network gathering  Views:1 

Advertisement
Hi All,
I have configured a sender JDBC Adapter with the following parameters.
JDBC Drivers: com.microsoft.jdbc.sqlserver.SQLServerDriver
Connection: jdbc:microsoft:sqlserver://MIS-SERVER\MIS_DEV_SVR;DatabaseName=SEPG_NEWDB
But in Runtime, I am getting error as follows...
Error during database connection to the database URL 'jdbc:microsoft:sqlserver://MIS-SERVER\MIS_DEV_SVR;DatabaseName=SEPG_NEWDB' using the JDBC driver 'com.microsoft.jdbc.sqlserver.SQLServerDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection to URL 'jdbc:microsoft:sqlserver://MIS-SERVER\MIS_DEV_SVR;DatabaseName=SEPG_NEWDB': SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]The requested instance is either invalid or not running.'
It has been confirmed that JDBC Drivers are properly deployed.
Any suggestions to resolve this issue?
Regards
Pavan
Hi Pavan,
I think Port is missing and also it should be look like this. (microsoft not required for SQL SERVER 2000).
Make sure msbase.jar, msutil.jar, mssqlserver.jar are the driver files and deployment.
Connection: jdbc:sqlserver://MIS-SERVER\MIS_DEV_SVR<b>:PORT</b>;DatabaseName=SEPG_NEWDB
Regards,
Sarvesh
Related articles
  • Error in configuring JDBC Adapter 10-11

    Hi All, I have configured a sender JDBC Adapter with the following parameters. JDBC Drivers: com.microsoft.jdbc.sqlserver.SQLServerDriver Connection: jdbc:microsoft:sqlserver://MIS-SERVER\MIS_DEV_SVR;DatabaseName=SEPG_NEWDB But in Runtime, I am getti

  • Error while configuring B2B adapter in Jdev 11.1.1.6 10-11

    Hi All, While configuring B2B adapter in jdev 11.1.1.6, i'm getting the following error at the Document definition step, Unable to connect to URL: https://ip address:port no/integration/services/b2b/B2BMetadataWSPort due to javax.xml.soap.SOAPExcepti

  • RWB error in Sender JDBC adapter 10-11

    Hi All, I am using SP at sender communication channel. When I am activating the Sendr CC I am getting the The statement did not return a result set. error. But when I lgged to database server and checked the SP it was working fine and giving the valu

  • Error in configuring Mail Adapter 10-11

    Hello Friends, I am working in XI 2.0 I am trying to configure the Outbound file adapter for sending the Mail. and i configure my adapter as File adapter java class classname=com.sap.aii.messaging.adapter.ModuleXMB2File mode=XMB2FILE ##Adress for XMB

  • Error in reciever JDBC adapter 10-11

    My interface is Proxy to JDBC, in my JDBC adapter while checking with adapter monitoring ---> communication monitoring it is showing green light and saying fuctioning for log but inthe case of message monitoring it is showing system error, but i am n

  • Error when calling JDBC Adapter parallel 11-30

    Hello, we have several interfaces which consume data from an AS400 machine via JDBC Adapter. Interfaces were running for several months without any problem. Now we get the following error message when few interfaces try to deliver data at the same ti

  • Error in receiver JDBC Adapter 10-11

    Hi,    I get the following error in the Adapter monitor Receiver Adapter v1027 for Party '', Service 'HEMAS_SQLREC': Configured at 11:18:57 2005-10-12 Last message processing started 11:38:46 2005-10-14, Error: Transform error in xml processor class,

  • Error in configuring soap adapter 10-11

    Hai! Iam working with rfc to webservice scenario. In that while configuring the soap adapter, the following errors have occured. SOAP: failed to sign the message due to java.security.PrivilegedActionException: com.sap.aii.af.security.impl.exception.M

  • Error While Configuring DB adapter in Admin Server 10-11

    Hello All, i am unable to configure the DB adapter 's settings in the Console. DBAdapter->Configuration->outbound Connection Pools -> There was an error reading the descriptor files. Errors occured while initializing a new deployment plan. [J2EE

  • Error while configuring BC Adapter 10-11

    Hi, I am trying to send a message from xi to bc using bc receiver adapter,but while configuring i am not sure about the parameters like url etc.   To invoke a service of bc through xi what url has to be provided?   Could you please brief me more abou

  • JDBC adapter error 10-11

    I am working on proxy to jdbc scenario where iam seeing error log  in jdbc adapter of communication channel monitering  like below: Kindly do the needful? Could not execute statement for table/stored proc. "ACU_LVL_ADDR_SRC" (structure "Sta

  • Message error ORA-00936 when using JDBC adapter 10-11

    Hi all, I'm using the folow scenario: RFC --> XI --> JDBC RFC <-- XI <-- JDBC (response) It's a SYNCHRONOUS interface. RFC call without COMMIT WORK: CALL FUNCTION 'Y_TESTE_NEI'     DESTINATION 'RFC_XI' EXPORTING    DATE_FROM       =  v_data_fr

  • Invalid column name error in JDBC adapter 10-11

    Hi all, My scenario is Proxy->XI->JDBC. I get the following error in receiver JDBC  adapter. Unable to execute statement for table or stored procedure. 'Account_Master' (Structure 'STATEMENT') due to com.microsoft.sqlserver.jdbc.SQLServerException:

  • JDBC Adapter Communication Channel error 10-11

    I am getting this error for a JDBC Adapter, I waondering if anybody could point me in the right direction. I have installed the driver: JDBC Driver: oracle.jdbc.driver.OracleDriver Connection: jdbc:oracle:thin:@146.146.78.74:1521:ts1 Error: Error whe

  • Sapdb (maxdb) and jdbc adapter problem 10-11

    Hi, i have installed this jdbc file: http://sapdb.org/7.4/sap_db_jdbc.htm like in this how-to: https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/xi/xi-how-to-guides/how to install and configure external drivers for jdb

  • JDBC  Adapter Stored Procedure Query 10-11

    Hi All, I hav a scenario where i hav to call a Stored procedure. The stored procedure returns 3 result set objects (in other words, has 3 select statements). I had configured a JDBC Sender adapter which contains the Execute statement of the Stored Pr

  • JDBC Adapter: unique constraint 11-30

    Hi, my scenario: IDoc -> XI -> JDBC. I would like to know whether the data processing on my Oracle database was successful or not. If an unique constraint fails on oracle (i have test it) the idoc has status successful although (XI: SXMB_MONI) . how

  • Reg:JDBC adapter 11-30

    Is it possible to fetch the data from 5 different database tables using a sngle CC where JDBC is configured on sender side.if yes how? points will be rewarded for correct answers immediately.... regards chandrakanthHello , You either use a select que

  • JDBC Adapter configuration not initialized Error 10-11

    Hi, I am doing a RFC to JDBC scenario in PI 7.1. I am getting the following error: com.sap.engine.interfaces.messaging.api.exception.MessagingException: JDBC Adapter configuration not initialized: null In communication channel monitoring, it shows th

  • Error in JDBC Adapter Configuration.... 10-11

    Hi,   My scenario is like this FTP->XI->Oracle Database. The problem is that the files are not getting posted to the database though it is running well. In XI receiver comm channel in JDBC adapter, I have provided the Connection path as   jdbc:oracl