DBMSSOCN is for the TCP/IP network library. My guess would be that a
firewall is blocking the connection or that the instance
computername\SQLEXPRESS is not set to accept TCP/IP connection. Another
possibility would be to you forgot to specify the name of the instance -
using only "computername" instead of computername\SQLExpress" - or that the
SQL-Server Browsing service is not running. BTW, you don't tell us where
this sql-server is located: on the same machine or on another?
It's also possible that you have a security problem, for example, yo try to
use a sql-server login instead of a windows login but the Mixed
Authentification mode has not been enable on the sql-server.
I suggest that you take the time to study the various configuration options
for SQL-Server as well as at its security panel.
--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Blog/web site:
http://coding-paparazzi.sylvainlafontaine.com
Independent consultant and remote programming for Access and SQL-Server
(French)
"Filips Benoit" <(E-Mail Removed)> wrote in message
news:eBN%m.37500$(E-Mail Removed)2...
> Found a solution:
> Have to reset the property 'Network library' to null under the ALL-tab in
> the Data-link-properties
> It was set to DBMSSOCN ( means nothing to me).
> Now I can connect to any existing database but NOT migrate a mdb to a new
> sql-database
> since Magrating a mdb doesn't show the Data-link-properties-window !
>
> Filip
>
> "Filips Benoit" <(E-Mail Removed)> schreef in bericht
> news:yFM%m.16813$(E-Mail Removed)2...
>> Dear All,
>>
>> New computer having Windows 7 and office 2007
>> old computer having Windows XP and office 2003
>>
>> I have copied a adp from old to new and changed the servername >
>> computername\SQLEXPRESS and works OK
>>
>> BUT when i try to make a new adp on new computer using the same
>> serverpropertied I receive this error
>>
>> [DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or access
>> denied
>>
>> any idea where it goes wrong?
>>
>> Filip
>
Similar Threads
