I can't connect to the local sql express server. I see in microsoft sql server management studio express that the server is running but I don't fint the server in access 2003. I work with vista.
what can be the reason?
thanks a lot!
Have you verified your connection string?
You might check with http://www.connectionstrings.com/ to determine how to properly create a conneciton string for Access to use SQL Server.
|||
You need to enable the TCP/IP protocol in SQL Server Configuration Manager in order to connect to SQL Server from Access. Access uses ODBC connections, which is only supported via TCP/IP, thus you need to enable that.
Regards,
Mike
|||i enabled the TCP/ip protocol in sql server configuration manager, but i stil can't connect. when I test the connection in access I get the massage that something went wrong with the initialisation of the application.
|||I don't understand "verified your connection string" ... excuse me I'm en newby
|||
You'll need to provied the exact error message otherwise we're just guessing.
For Access to connect to SQL Server you need to have a DSN, which you create using the Create New Data Source wizard. This is launched in Access when you select ODBC as the source for a Linked table. When you filled out the wizard, you were asked to provide the name of the Server and the name of the database, what did you enter for those fields?
Mike
|||I found the solution: I wrote te servername wrong: it had to be: computername\servername|||
Just in addition and for nitpicking its Computername\Instancename :-)
Jens K. Suessmeyer
http://www.sqlserver2005.de
No comments:
Post a Comment