Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

SQL Connection Error

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

1 Solution

Accepted Solutions
Not applicable

Re: SQL Connection Error

Lenny

be careful of ODBC version you are using  32 or 64

must go along with your Q version

chris

10 Replies
Not applicable

Re: SQL Connection Error

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

Not applicable

Re: SQL Connection Error

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

thornofcrowns
Valued Contributor II

Re: SQL Connection Error

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.

Not applicable

Re: SQL Connection Error

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

Not applicable

Re: SQL Connection Error


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

Not applicable

Re: Re: SQL Connection Error

quick process

Not applicable

Re: SQL Connection Error

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!

Not applicable

Re: Re: SQL Connection Error

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.

Not applicable

Re: SQL Connection Error

Lenny

be careful of ODBC version you are using  32 or 64

must go along with your Q version

chris

Community Browser