on 07-17-2010 12:22 AM
Hello Friends,
I have a problem with external JDBC table definition import.
Database I am trying to connect is SQL SERVER 2008. I have created a communication channel receiver JDBC. Driver being used is SQLServer 2000 Driver for JDBC
Here is the connection string:
jdbc:microsoft:sqlserver://XXXXXXXXXXXXXX\XXXXX:40006;databaseName=XXXX_XXXX;SelectMethod=Cursor
User has db_owner auth on the database.
Which trying to hit DISPLAY the only response i see is "Table not found"
am i missing any steps here ?
Hi,
Please monitor your communication channel first,if no errors found then create external definition with option db tab then select your cc and try to import.
if you getting error table not found then check your table not exists in data base really table created or not.then try to import other table...let me know if still same error persist.
Regards,
Raj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you, I already checked on communication channel no errors there it says successful message.
I also created a trace on the SQL DB and found that PI is doing sp_tables to check if table exists. When executed using local client like SQL management studio with same userid , its returning right value but still shows in ESR of PI as table not found.
Also the table is existing and user has role of db_owner so I doubt if authorizations problem exist.
Edited by: Krishna_PI on Jul 17, 2010 7:34 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.