Re: Connection to SQL Server 2005 lost

Thank you for the suggestion.

We have not tried the native client, because the FAQ says:

Q. Must I upgrade clients to use SQL Native Client as soon as I upgrade my
server?

A. Applications deployed before SQL Server 2005 was released can and should
continue to use MDAC.

Most likely it is a server configuration problem. Our program is used by
many clients, accessing the datebase from different computers/configurations,
and all of them experience this error message when conneting to a given SQL
Server 2005 Server. Some of our clients from other firms also have their own
SQL Server 2005 running, and they have successfully managed to connect to
their database using MDAC and never experience this error message.


"Andrew J. Kelly" wrote:

Have you tried using the SQL Native Client (SNAC) instead to see if that
makes a difference?
http://msdn2.microsoft.com/en-us/data/aa937733.aspx


--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Glenn Handeland" <Glenn Handeland@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:9A2E8820-DEFC-4209-B019-8A0996CF7FDF@xxxxxxxxxxxxxxxx
We have developed a VB6 client program accsessing SQL Sever 7.0 via ADO
(Provider=sqloledb) and MDAC 2.8. This program has worked flawlessly for
years, but after upgrading to SQL Server 2005, the database connection is
sometimes lost during larger operation involving open/close of several
recordsets. The general error message says:
“[DBNETLIB][ConnectionOpen,Connect()).]SQL Server does not exsist or
access
denied". "Simpler" parts of the program involving just a recordset or two
always work fine. Any idea of what is going on here?


.

Relevant Pages

  • RE: MSDE to SQL Server
    ... I understand that you want to upgrade MSDE instances ... We can upgrade the instance SHAREPOINT to SQL and it is not recommended ... Business Server 2003 ...
    (microsoft.public.windows.server.sbs)
  • RE: NT clients after 2K3 server upgrade
    ... it seems that the NT clients cannot find ... The following article describes how to install a WINS server on Win2k3 ... I would like give you the detailed upgrade ... 5.Use the Windows Server 2003 Active Directory wizard to turn on the Active ...
    (microsoft.public.windows.server.migration)
  • Re: Inplace Upgrade os SMS2.0 to 2003
    ... the distribution points so I know which ones need updating? ... >> Currently our SMS 2.0 Installation consists of a Central Site Server and one ... On the Central Site server there are roughly 700+ clients, ... > Site boundaries should be retained after the upgrade. ...
    (microsoft.public.sms.setup)
  • Re: SBS 2003 R" Premium stops responding to clients
    ... Sometimes the SBS lost DC ... when all clients were down and there are no sql ... The sql load on this system is very small, and there were no sql server ... Mem is 2 GB and there are 10 clients. ...
    (microsoft.public.windows.server.sbs)
  • Re: Inplace Upgrade os SMS2.0 to 2003
    ... > Currently our SMS 2.0 Installation consists of a Central Site Server and one ... On the Central Site server there are roughly 700+ clients, ... > another server that is being used as a SMS Distribution Point. ... Site boundaries should be retained after the upgrade. ...
    (microsoft.public.sms.setup)
Loading