Jdbc connetion

[Former Member]

how to connect if u r database in us

thanks

[Former Member]

Hi,

Using JDBC we can connect to any database server.

Creating System Object for JDBC

• System Administration

• System Configuration

• PCD Expand and select our working folder. Then right click, New and select System.

• Select JDBC System Template.

• Give the name and id for the system click save and then open the object in the Edit Mode.

• Here select – Connection Properties and give the following details

1. Connection URL.

2. Driver class Name

3. Connection Timeout(optional)

1) Connecting to SQL Server

• While connecting to SQL Server give the following details

• Connection URL “jdbc:sap:SqlServer://<IP of the SqlServer>:1433;Databasename:SQLServer;

• In the above connection url SQLServer is System Object name which we created from jdbc.

Driver Class Name “com.supportals.jdbc.SqlServer.SQLServerDriver.

2) Testing the Connection

Go to System Administration->System Landscape->Jdbc System->open->object->

Connection Test-> Test the Connection

Please follow this tutorial step by step

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/b00917dc-ead4-2910-3ebb-b0a63e49...

and also look at below Blog.

<

Regards,

Surya

[Former Member]

HI,

The connection to the database is not related to the location . The db is where ever it may be , it can be connected to XI server by using the Jdbc driver connection details .

[Former Member]

kindly explain your requirement in detail, so tat we can help u

[former_member182455]

Hi veni

MS SQL Server 2000

Driver files msbase.jar, msutil.jar, mssqlserver.jar

Connection URL jdbc:sqlserver://<host_name>:<port>;DatabaseName=<db_name>

Driver name com.microsoft.jdbc.sqlserver.SQLServerDriver

MS SQL Server 2005

Driver file sqljdbc.jar

Connection URL jdbc:sqlserver://<host_name>:<port>;database=<db_name>

Driver name com.microsoft.sqlserver.jdbc.SQLServerDriver

Please follow this tutorial step by step

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/b00917dc-ead4-2910-3ebb-b0a63e49...

More threads

/message/3405116#3405116 [original link is broken]

/thread/412665 [original link is broken]

regards

srinivas