SQL Connection Error

[#1]

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

[#2]

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

[#3]

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]

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.

[#5]

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

[#6]

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

[#7]

quick process

[#8]

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!

[#9]

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.

[#10 · Accepted solution]

Lenny

be careful of ODBC version you are using  32 or 64

must go along with your Q version

chris