JDBC receiver Adapter Details

[Former Member]

Hi Experts

I am using a SQL server .The XI server is conecting to teh SQL server through Receiver JDBC adapter.

I am getting stuck with teh following information .

JDBC Driver: com.microsoft.jdbc.sqlserver.SQLServerDriver

Connection: jdbc:Microsoft:sqlserver://XXXXXX:1433;DatabaseName=XI.

This is what I get to see from the several blogs in SDN.

But in reality I think this is going to differ.

Can any body suggest me what to put in the XXXXX regiaon

Currently I have the following information with me about the SQL server.

db_name = abcd

server_name = 1234

uid

pwd

ipaddress. 111.111.111.111

I wish to know what else information do I need to collect so as to complete the CONNECTION .

Regards,

Arnab

[Former Member · Accepted solution]

Hi...

please find the below details.

Genarally the connections for the receiver JDBC adapter will be like below.

JDBC Driver -

---

com.microsoft.sqlserver.jdbc.SQLServerDriver

Connection --- jdbc:sqlserver://host name:port;databaseName=your db name

From your details you can give like this.

jdbc:sqlserver://111.111.111.111:1433;databaseName=abcd

Regards,

Leela

[Former Member]

Hi Arnab,

SQL Server is a Winsock application that communicates over TCP/IP using the sockets network library. The SQL Server listens for incoming connections on a particular port; the default port for SQL Server is 1433. The port doesn't need to be 1433, but 1433 is the official Internet Assigned Number Authority (IANA) socket number for SQL Server.

so try the connection string with 1433 port if it works....than sab bhalo hobe...

..else ask the DBA..:-)...

Regards,

[Former Member]

Hi,

Genarally, the port for accessing JDBC is 1433.

If that differs, you need to speak with your basis person or the database person who installed the SQL server.

Hope this helps

Regards

Kiran.

[dharamveer_gaur2]

Hi

Connection: jdbc:Microsoft:sqlserver://XXXXXX:1433;DatabaseName=XI.

Here XXXXXX is Hostname or IP Address of SQL server . So put IP Address of SQL Server.

you only require these connection parameter

JDBC Driver = com.microsoft.jdbc.sqlserver.SQLServerDriver

Connection = jdbc:microsoft:sqlserver://hostname:<port(SQL Server Port No.)>;DatabaseName=<DBName>

User of SQL Server

Password of SQL Server User.

[Former Member]

Gr8, I can proceed further, but hw do I get 2 know the PORT name of SQL server, I mean is there any way??

Arnab

[varun_k]

Hi Arnab Mondal,

Please have a look at the connection details.

Connection = jdbc:microsoft:sqlserver://hostname:<port>;DatabaseName=<DBName>UserID and Password.

"jdbc:sqlserver://localhost:port;""databaseName=<DBName>;user=<username>;password=<passwd>;"

Regards,

Varun