Table not found error : Importing External SQL SERVER 2008 Table definition

[Former Member]

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 ?

[rajasekhar_reddy14 · Accepted solution]

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

[Former Member]

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

[rajasekhar_reddy14]

Yes Krishna,

even i think it is authorization issue

Regards,

Raj

[Former Member]

I dont think it is auth issue. When executed with same user on client it is working and user has db_owner auth.

[Former Member]

Was there a resolution to this? I get a similar issue.

I have created my communication channel and created an external definition. When I try to Display I only get some table, not all. If I log in view SQL Management Studio with the same user I get all table.

Can someone help?