Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ilanbaruch
Specialist
Specialist

Native Client connection - dosent show list of tables

hi all,

I established my connection successfully (connection test 'ok'),

but when finish and proceed to SELECT tables default database comes MASTER.

when I change  to relevant db it comes empty

any ideas?

8 Replies
luciancotea
Specialist
Specialist

Try

SELECT field1, field2

FROM dbname.dbo.table1;

ilanbaruch
Specialist
Specialist
Author

I got this error:

ErrorSource: (null), ErrorMsg: (null)
SELECT [Country], [RegistrationPlatform]

FROM [AristoSlotsDW.Staging].[dbo].[Players]

ilanbaruch
Specialist
Specialist
Author

"change to relevant"

after I finish the connect dialog box (connection 'ok')

I press on the SELECT button. in the select dialog box default db is MASTER I change it to the relevant db for my application but dont see any table.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

What version (build) of QV?

-Rob

ilanbaruch
Specialist
Specialist
Author

QV 11 64bit

MSSQL 2012 - native client 11

if I use OLE DB provider for SQL (to establish the connection) I can see the tables but cant choose fields..

thank you

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

To get the specific build# choose Help. About Qikview. You should see a number like:

11.20.123456 SRx

-Rob

ilanbaruch
Specialist
Specialist
Author

11.20.12742.0 SR10 64bit

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

In testing this, I found that I must specify the database name as part of the CONNECT statement in order to be able to view tables in the Select dialog.

Initial Catalog=AdventureWorksLT2008R2;

This can be specified in the Connect dialog. If I don't specify it, I can switch to it in the Select Dialog, but the table list will be empty. Accepted as a bug or not? Check with support.

-Rob