Connection Error: ADO.Net and SQL Server 2005



Hi guys,

I have an application that uses ADO.Net (2.0) to connect to SQL Server.
We've never had any problems connecting to SQL Server 2005 using this
application, but one client has had problems and the error he gets is of the
type "General Connection Error...[Microsoft][ODBC SQL Server
Driver][DBNETLIB]ConnectionRead (rec())."

I asked him to create an ODBC connection in Windows just to see if it
was only the application, and he has no problem connecting through ODBC.

So, as you can see, it is very puzzling because when we've had problems
in the past, ODBC would not work either.

Is there some issue with ADO.Net (2.0) and SQL Server 2005? Remember
that other clients are using the software connecting to SQL 2005 with no
problem.

The user says that Firewall is disabled and Remote Connection is enabled
at the server.

Anything else I could check??

Any help will be greatly appreciated.

Thank you,
Maer




.



Relevant Pages

  • Re: Cant connect through Management Studio, Can connect Visual Stu
    ... Obviously the same login should work no matter how you are connecting. ... Try connecting from your client using sqlcmd. ... then you know the problem is related to Management Studio. ... I have uninstalled SQL Server 2000 from my machine now. ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL Server 2005 Connection Only By ODBC
    ... that I would like to restrict it from connecting with SSMS only ... connecting with ODBC. ... user account was connection to SQL Server instance? ...
    (microsoft.public.sqlserver.security)
  • Re: How to connect a workstation to SQL Server 2005 thru ODBC?
    ... and open the port in the Windows XP ... Welcome to the Getting Started with the Database Engine tutorial. ... Connecting to the Database Engine ... Either SQL Server Management Studio or Management Studio Express. ...
    (microsoft.public.sqlserver.connect)
  • Re: How to get the IndexNames
    ... are you connecting to ... I connect to a SqlServer 2000 database using an ODBC driver from ... Microsoft 'SQL server v 200.85.1117.00'. ... in that case I would suggest to use the MS SQL Server OLE DB provider ...
    (borland.public.delphi.database.ado)
  • Re: Cannot connect a remote sql server
    ... I too have written quite a bit about connecting. ... Hitchhiker's Guide to Visual Studio and SQL Server ... such as the server's firewall, SQL Server's remote connection setting, ... Microsoft MSDN Online Support Lead ...
    (microsoft.public.dotnet.framework.adonet)

Loading