Discussion board where members can get started with QlikView.
I am trying to connect to a sql database and I am getting the following error connection. Any assistance would be greatly appreciated.
SQL Server Error:5
[Microsoft][ODBC SQL Server Drover][DBNETLIB]ConnectionOpen
SQL Server Error: 17
[Microsoft][ODBC SQL Server Drover][DBNETLIB]SQK Serer does not exist or access denied.
Thanks in advance,
Go to Solution.
be careful of ODBC version you are using 32 or 64
must go along with your Q version
is your database running ?
is your ODBC driver declared ?
What happens if you test to connect to database while declaring in ODBC ?
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.
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.
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
I am able to ping the server. I will try and declare the ODBC connection.
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.
I was able to declare the ODBC connection...
Attempting connectionConnection establishedVerifying option settingsDisconnecting from server
TESTS COMPLETED SUCCESSFULLY!
However, when I tried using QV, I wasn't able to connect.