Native Client connection - dosent show list of tables

[ilanbaruch]

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?

[luciancotea]

Try

SELECT field1, field2

FROM dbname.dbo.table1;

[ilanbaruch]

I got this error:

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

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

[ilanbaruch]

"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]

What version (build) of QV?

-Rob

[ilanbaruch]

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]

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

11.20.123456 SRx

-Rob

[ilanbaruch]

11.20.12742.0 SR10 64bit

[rwunderlich]

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