Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

Lenny

be careful of ODBC version you are using  32 or 64

must go along with your Q version

chris

View solution in original post

10 Replies
Not applicable
Author

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
Author

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
Specialist II
Specialist II

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
Author

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
Author


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

Not applicable
Author

quick process

Not applicable
Author

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
Author

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
Author

Lenny

be careful of ODBC version you are using  32 or 64

must go along with your Q version

chris