Re: ODBC to SQL Server Express?

Have you tried SQL Native Client? It wraps up both OleDb and Odbc. See
http://msdn2.microsoft.com/en-us/library/ms130892 for more
information.

--Mary

On Fri, 11 Nov 2005 15:36:04 -0800, "BeanDog"
<BeanDog@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

>Can I create an ODBC connection to SQL Server Express? I just installed SQL
>Server Express and Visual Web Developer Express (for a database frontend
>only). I need to access the SQL Server Express databases via ODBC. I turned
>on Named Pipes and TCP/IP access to the server via the SQL Server
>Configuration Manager.
>
>When I try to create a new ODBC connection, I have two relevant ODBC driver
>options: SQL Server and SQL Native Client. I go into the ODBC Administration
>screen through the control panel in Windows XP and try to create a new system
>data source. When I click the dropdown box for which server to use (under
>either driver), I get both (local) and LAPTOP, this computer's name, listed.
>No matter which I choose, or which driver I'm using, when I try to test the
>connection I get this error:
>
>Named Pipes Provider: Could not open a connection to SQL Server (2)
>
>This despite the fact that I've changed the settings to allow named pipes
>connections, shut down both the SQL Server and the SQL Server Browser
>services, and started them both back up again.
>
>Under Visual Web Developer, I can create a new local database file, but I
>cannot make a connection to the actual SQL Server that's running. Even
>making an ODBC connection to the database file itself would be enough, I
>suppose.
>
>What can I do?
>
>
>
>~BenDilts( void );
.

Relevant Pages

  • Re: Strange Problems with ODBC connection to SQL Server
    ... When accessing Jet data, use DAO. ... This way you are not exposing connection information in clear ... >accesses an SQL Server 2000 repository via ODBC data source. ...
    (microsoft.public.data.odbc)
  • Re: Access and processor usage
    ... and you are using an ODBC connection, that would be your bottle neck. ... bottleneck - need to step up to Sql Server. ...
    (comp.databases.ms-access)
  • Re: provider: Named Pipes Provider, error: 40 - Could not open a c
    ... I have tried connecting to Sql Management Studio and it worked pretty much ... An error has occurred while establishing a connection to the server. ... under the default settings SQL Server does not allow remote connections. ... I have a sql server install / database on the web server. ...
    (microsoft.public.sqlserver.connect)
  • RE: Logging in in background
    ... wold take all kinds of modifictions as I'd need to be checking that each SQL ... my database and all have connection strings associated with them. ... I suspect that there is also an issue on the SQL Server side as I keep ...
    (microsoft.public.access.modulesdaovba)
  • RE: [ODBC SQL Server Driver][Shared Memory]ConnectionWrite (send()) er
    ... I understand that you encountered the ODBC error message on your ecommerce ... TCP/IP protocol to your SQL Server instance by calling conn.Open, ... SQL Server instance and see if there is a connection reset when this issue ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.connect)