How do I connect an Access DataProject to MSSQL Express 2005 datasource? regards reidarT
R reidarT Nov 12, 2005 #1 How do I connect an Access DataProject to MSSQL Express 2005 datasource? regards reidarT
C Chris Burnette Nov 15, 2005 #2 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
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
