on 01-24-2007 9:47 AM
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
Hi
I have selected ACTIVE only.......
Best Regards
Ravi Shankar B
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
82 | |
10 | |
10 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.