• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 715
  • Last Modified:

Cannot Connect via ODBC

We are running SQL Server 2005 and I would connect to the Database in Access 2007 via an ODBC (App_Map) from a Vista Compuer -- as of Thursday last week I am not able to connect.  When I open my Access database I get the following:

Connection failed:
SQLState" '01000'
SQL Server Error: 10054
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead
(recv()).
Connection failed:
SQLState: '08S01'
SQL Server Error: 11
[Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error.
Check your network documentation.

But when trying to rebuild the ODBC - I tell it to use Windows NT authentication when I click next it should prompt me to select the Database.  So I think I have a permission issue not at the Database level but at the Server level  -- just a thought.   But insetad I get the same error as above.  

When I try to test the connection I get the following error.

Attempting connection
[Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error.
Check your network documentation.


Now here is where it gets werid -- I can login to the same machine with our SMS_Service account and I am able to connect just fine.  so it appears to be a permissions issue.  I have checked and the non working account has permissions to the database.   Any help would be great.

0
stratasoft
Asked:
stratasoft
  • 5
  • 3
1 Solution
 
jpipkinsCommented:
Test your database connection.
-Right Click on desktop ->
Create new text document->
Save as test.UDL->
double click
Click the Provider tab and test connection by selecting driver name,datasource name,user id and password.
Click on Test Connection.
It should be succeed.
0
 
jpipkinsCommented:
I would use the sql native client as my provider, to test the connection directly.  If this fails, then I would try some basic, albeit somewhat illogical things (reboot client, reset password, double-check not only the sql user permissions, but also the login account to make sure it hasn't somehow lost it's connection to your AD account).  Maybe you can delete that login and create another one.
0
 
stratasoftAuthor Commented:
Just did this - on the Connection tab I am able to select my SERVER - select Window NT Security, but when I select the DATABASE I get a Microsoft Data Link Error:

[DBNETLIB][ConnectionRead (recv()).]General network error. Chek your network documentation.
0
Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

 
jpipkinsCommented:
Try it again, except before clicking Test Connection, click on the Advanced tab and change ConnectionTimeout to 15
0
 
stratasoftAuthor Commented:
I just changed that to 15 seconds -- But as soon as I click on the Drop down button to select the DataBase  --- Instead of showing me the Databases I get an a Data Link Error

[DBNETLIB][ConnectionRead (recv()).]General network error. Chek your network documentation
0
 
jpipkinsCommented:
I've read where entering Pooling=False in your connection string will help.
0
 
stratasoftAuthor Commented:
I had to switch the connectiong from TCP/IP to Pipe Names -- then it worked.    Dont know why this happened, just know it works
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now