topic SQL Connection Error in QlikView

SQL Connection Error

Thu, 05 Jun 2014 12:38:33 GMT

Hello,

I am trying to connect to a sql database and I am getting the following error connection. Any assistance would be greatly appreciated.

Connection failed:

SQLState: '01000'

SQL Server Error:5

[Microsoft][ODBC SQL Server Drover][DBNETLIB]ConnectionOpen

(Connect()).

Connection failed:

SQLState:'08001'

SQL Server Error: 17

[Microsoft][ODBC SQL Server Drover][DBNETLIB]SQK Serer does not exist or access denied.

Thanks in advance,

-Lenny

Re: SQL Connection Error

Thu, 05 Jun 2014 12:43:06 GMT

Hi Lenny

is your database running ?

is your ODBC driver declared ?

What happens if you test to connect to database while declaring in ODBC ?

regards

Chris

Re: SQL Connection Error

Thu, 05 Jun 2014 12:49:39 GMT

Hi Chris,

The database is running, however I am not sure if the ODBC driver is declared? Not sure how to test the connection as I can't add the database IP address or server name.

-Lenny

Re: SQL Connection Error

ThornOfCrowns — Thu, 05 Jun 2014 12:57:01 GMT

a) Can you ping the server from the command line?

b) If you don't have a server name that resolves to an IP address or a raw IP in your link then it will fail.

Re: SQL Connection Error

Thu, 05 Jun 2014 12:59:14 GMT

Lenny

you must open "Config panel" "ODBC driver" and use declare your database driver

then declare and config your database and test connection here first

then in QV, use wizard to create connection string

best regards

Chris

Re: SQL Connection Error

Thu, 05 Jun 2014 13:01:23 GMT

I am able to ping the server. I will try and declare the ODBC connection.

Re: Re: SQL Connection Error

Thu, 05 Jun 2014 13:06:20 GMT

quick process

Re: SQL Connection Error

Thu, 05 Jun 2014 13:08:34 GMT

I received the following error message when I tried to declare the ODBC driver...

Microsoft SQL Server ODBC Driver Version 06.01.7601

Running connectivity tests...

Attempting connection
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied.

TESTS FAILED!

Re: Re: SQL Connection Error

Thu, 05 Jun 2014 13:28:06 GMT

I was able to declare the ODBC connection...

Microsoft SQL Server ODBC Driver Version 06.01.7601

Running connectivity tests...

Attempting connection
Connection established
Verifying option settings
Disconnecting from server

TESTS COMPLETED SUCCESSFULLY!

However, when I tried using QV, I wasn't able to connect.

Re: SQL Connection Error

Thu, 05 Jun 2014 13:32:40 GMT

Lenny

be careful of ODBC version you are using 32 or 64

must go along with your Q version

chris

Re: Re: SQL Connection Error

Thu, 05 Jun 2014 13:41:45 GMT

Hi Chris,

That worked... I had to force 32 bit.

I think I will have other questions because I can see the different tables in the SQL db, I can fetch some data, however the data isn't showing up.