topic Re: A Problem with connection to SQL SERVER 2008 in QlikView

A Problem with connection to SQL SERVER 2008

Mon, 10 Oct 2011 19:50:23 GMT

i connected to my DB on SQL Server and couldn't see my tables when used: Ctrl+T.

I might did somethong wrong but don't know what..

here are the steps i took:

1. opened a new qv document.

2. Ctrl+E

3. Changed "Database" to: OLE DB

4. pressed "Connect"

5. and then put my local server name (its on my computer) as wall as the server DB

6. this raw appears:

OLEDB CONNECT TO [Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=master;Data Source=YAEL-PC\SQLEXPRESS;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=YAEL-PC;Use Encryption for Data=False;Tag with column collation when possible=False];

now when i click on "SELECT"

i see all the tables. but when i use ctrl+t i don't see anything.

What am i missing?

Thanks.

A Problem with connection to SQL SERVER 2008

Mon, 10 Oct 2011 19:59:53 GMT

PS
When i tried to reload after "SELECT"-ing a table i got this: (See attached file)

A Problem with connection to SQL SERVER 2008

Tue, 11 Oct 2011 02:42:38 GMT

Two things:

You said OLE DB but script shows it as ODBC. You need to check this first.

Did you try testing the connection from the data sources in your control panel?

Regards,

Kiran.

Re: A Problem with connection to SQL SERVER 2008

Tue, 11 Oct 2011 07:22:25 GMT

how can i check that?

10x

Yael

2011/10/11 Jollybaba <qliktech@sgaur.hosted.jivesoftware.com>

**
QlikCommunity <http://community.qlik.com/index.jspa> Re: A
Problem with connection to SQL SERVER 2008 created by Jollybaba<http://community.qlik.com/people/jollybaba>in
Connectivity and Data Sources - View the full discussion<http://community.qlik.com/message/156518#156518>

Re: A Problem with connection to SQL SERVER 2008

Tue, 11 Oct 2011 07:26:48 GMT

You can edit your ODBC data sources from control panel->administrative toos->data sources. On the final window you can test your connection as in the image:

Regards,

Kiran.