on 11-09-2014 11:29 AM
I have to check if drivers of sql are properly inserted in the PI system.
I created a receiver cc and tried to connect to the databse by creating a external definition.
I tried to import metadata and I got exception cannot establish connection with this driver. I am using mssql
connection parameters are
com.microsoft.jdbc.sqlserver.SQLServerDriver
jdbc:Microsoft:sqlserver://IPaddress:port;databaseName=<tablename>
are they correct?
how do I check telnet in SM69 ? Can tell me how?
Regards
Hi Midhun,
The Database name in the connection URL will be the schema name of the database that you are connecting to; and these are case sensitive. Also, the IP address can be replace by the fully qualified host name of the database server. Make sure that the host name is defined on the DNS of your organization.
Regards,
Alka.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
How do you connect to the database from your local system?
You may use the same server name you use to connect to MS SQL server management studio or so. The host name may define in your PI server inside /etc/host file. You may follow the link https://library.netapp.com/ecmdocs/ECMP1368834/html/GUID-CD7BDEA3-6754-4128-A260-CF05624F1772.html
Hi Midhun,
Verify your connection URL with the database team.
As mentioned previously, in the connection URL, database name will be the DBSchema name and not the table name.
Other points that you can check with your DB team is concurrent logins permission and also Select and modify permissions to be given to the user with which you are trying to connect.
Regards,
Alka Panday.
The problem with the database name. Once they corrected it, al worked
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
The connection parameters to connect to MS SQL should be:
com.microsoft.sqlserver.jdbc.SQLServerDriver
jdbc:sqlserver:://IPaddress:port;databaseName=<tablename>
Suman
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.