topic Re: Native Client connection - dosent show list of tables in QlikView

Native Client connection - dosent show list of tables

ilanbaruch — Sun, 01 Mar 2015 08:50:59 GMT

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?

Re: Native Client connection - dosent show list of tables

luciancotea — Sun, 01 Mar 2015 09:00:40 GMT

Try

SELECT field1, field2

FROM dbname.dbo.table1;

Re: Native Client connection - dosent show list of tables

ilanbaruch — Sun, 01 Mar 2015 10:36:01 GMT

I got this error:

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

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

Re: Native Client connection - dosent show list of tables

ilanbaruch — Sun, 01 Mar 2015 11:27:31 GMT

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

Re: Native Client connection - dosent show list of tables

rwunderlich — Sun, 01 Mar 2015 15:52:48 GMT

What version (build) of QV?

-Rob

Re: Native Client connection - dosent show list of tables

ilanbaruch — Sun, 01 Mar 2015 17:19:44 GMT

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

Re: Native Client connection - dosent show list of tables

rwunderlich — Sun, 01 Mar 2015 17:44:41 GMT

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

11.20.123456 SRx

-Rob

Re: Native Client connection - dosent show list of tables

ilanbaruch — Sun, 01 Mar 2015 20:34:59 GMT

11.20.12742.0 SR10 64bit

Re: Native Client connection - dosent show list of tables

rwunderlich — Mon, 02 Mar 2015 05:55:27 GMT

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