topic Re: How to pull tables from MS sql server ? in QlikView

How to pull tables from MS sql server ?

Anonymous — Mon, 16 Apr 2012 18:37:52 GMT

I have been trying to pull from ms sql server, after entering the credentials (usdrname, password), i'm not able to look at the source table, could someone please guide me

Thnx

How to pull tables from MS sql server ?

Mon, 16 Apr 2012 18:45:44 GMT

What type of connection are you creating: ODBC or OLEDB? What happens when you test the connection? What do you see when you click on the 'select' button? If the owner of the tables in the DB is not the same as the user in your connection string, you may just need to change the owner in the 'Owner' drop down in the 'Create Select Statement' screen.

Re: How to pull tables from MS sql server ?

Anonymous — Mon, 16 Apr 2012 18:49:11 GMT

Hi,

It says connection succeded(ODBC connection), but i don't see any table when i click on select

Thanks

Re: How to pull tables from MS sql server ?

Mon, 16 Apr 2012 18:58:18 GMT

I attached a screen shot of the 'create select statement' screen. If you are able to connect, it might be that there is just a simple setup error. So, check to make sure: you are connected to the correct database; the Owner is set to the owner of the tables, and; at least the radial is checked for the Tables.

Re: How to pull tables from MS sql server ?

Anonymous — Mon, 16 Apr 2012 19:18:25 GMT

Thank you Langaar, let me check...