In RWB i am getting JDBC adapter in Red Color......................

[Former Member]

Hi

I have configured on JDBC reciever Adapater...... and i have given the paramenter like following

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

Connection : jdbc:microsoft:sqlserver://sapep:1433;DatabaseName=DataBaseName;

Persistence : Database

Database Table Name : CheckUser

I have configured the JDBC adapter like this.... is there any wrong in this Configuration please tell me....

JDBC adapter is showing the following error in RWB

<b>Value missing for mandatory configuration attribute tableEOColumnNameId</b>

Best Regards

Ravi Shankar B

[SudheerJ]

Hi,

The same problem which you had is being faced by me now. Can you please let us know how did you solve this. Here is the forum link where i raised my issue -

Looking forward for your help.

Thanking you in Advance!!

[Former Member]

Hi,

What I'll recomend you guys to write a standalone java jdbc program giving the same connection string and driver name and table details and see if it is getting executed from there. If you need java code on this let me know.

thanks

amit

[Former Member]

Hi

I have installed JDBC drivers in System where i have installed SQL Server... but i am still getting the following error....

<b>Error: Accessing database connection 'jdbc:microsoft:sqlserver://10.7.1.43:1433;DatabaseName=Ravi;' failed: DriverManagerException: Cannot establish connection to URL 'jdbc:microsoft:sqlserver://10.7.1.43:1433;DatabaseName=Ravi;': SAPClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver</b>

Please tell me

Best Regards

Ravi Shankar B

[Former Member]

Hi

Yes i have selected "XML SQL Format" only

Am i done any mistake in configuring

JDBC Driver and Connection parameters?

Can u please check it once

Best Regards

Ravi Shankar B

Message was edited by:

RaviShankar B

[Former Member]

Try adding this parameter to your receiver cc

Click on Advanced mode and add this parameter.

logSQLStatement true

Now you can see the query formed at the receiver cc. Check this.

Post us the comlete error msg you get.

Regards,

Jai Shankar

[Former Member]

Hi

Still Its in Red

Can u please check whether i have given <b>JDBC Driver and Connection</b> Parameters Correctly

I have given SQL port to Default port... can any one tell me how to check the SQL port number.....Actually i dont know the port number thats why i have given the defalut port number

Best Regards

Ravi Shankar B

Message was edited by:

RaviShankar B

[Former Member]

Hi,

Can you please kindly check your database name in the connection parameter name?

Please let me know for any further quries.

Thanks and Regards,

Sekhar

[Former Member]

The Driver and connection details you specified are correct for connecting to a MS-SQL Server db with msbase.jar, msutil.jar, mssqlserver.jar

Regards,

Jai Shankar

[Former Member]

Hi

I have checked the database name its correct... My problem is still not resolved

Best Regards

Ravi Shankar B

[former_member187339]

Hi,

For checking Port

1)Install the MS SQL client.

2)Start the Client Network Utility (Start - Programs - Microsoft SQL Server - Client Network Utility)

3)Click on TCP/IP under "Enabled protocols by order" and then click on the properties button

4) You will get teh port... If needed In the new window, try changing the default port from 1433 to 14330. Click OK

Regards

Suraj

[Former Member]

Hi

I have selected ACTIVE only.......

Best Regards

Ravi Shankar B

[bhavesh_kantilal]

Hi,

UIn your Recievr JDBC adapter, did you select the Messag Protocol as <b>"Native SQL String"</b>

Can you make it "XML SQL Format " and test your scenario?

Regards

Bhavesh

[Former Member]

Hi,

What did you selected Adapter Status,make sure that you have to select active.

Please let me know for any queries.

Thanks and Regards,

Sekhar