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 said:
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 said:
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
