Connect to MSSQL Express 2005

reidarT · Nov 12, 2005

How do I connect an Access DataProject to MSSQL Express 2005 datasource?
regards
reidarT

Guest · Nov 15, 2005

I'm not an expert on ADP, but I would try using an ODBC connection string:

http://www.connectionstrings.com/

http://www.carlprothman.net/Default.aspx?tabid=81

Personally I use a DSN-less connection, but feel free to use whatever you
prefer.

Note that you'll need to start the SQL Browser and enable TCP/IP and/or
Named Pipes in Configuration Manager if you need to connect over a network.

-Chris

will using MSSQL2005 express as backend overcome danger of wificonnection to backen?	2	Nov 6, 2009
ADP + MSSQL (ADO) vs. ACCDB + linked MSSQL (DAO).	3	Dec 7, 2009
Access and SQL Express	2	Apr 16, 2006
Backup MSSQL db from C# code using SMO without knowing server version	7	Apr 25, 2007
Read very large file in bytearray and upload to MSSQL	11	Nov 18, 2007
2 DBs connections + commit/rollback	3	Mar 10, 2010
SQL fails to start after install .net 3.5	5	Dec 15, 2007
mdb connected to mssql - I get the write conflict alert box	1	May 3, 2006

Connect to MSSQL Express 2005

reidarT

Guest

Ask a Question

Similar Threads