Re: ODBC to SQL Server Express?

I'm not sure what's going on -- it might be some sort of configuration
issue. I'd post on microsoft.public.sqlserver.odbc,
microsoft.public.sqlserver.msde or microsoft.public.sqlserver.client.
Stay away from .programming, they get a gazillion messages a day and
yours might fall through the cracks.

--Mary

On Mon, 14 Nov 2005 11:42:08 -0800, "BeanDog"
<BeanDog@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

>Yes, I've tried connecting using SQL Native CLient as well as the normal SQL
>Server connection, in both the system's ODBC connection manager and the
>Visual Web Developer Express database connection wizard, and neither will
>work.
>
>"Mary Chipman [MSFT]" wrote:
>
>> 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: My Book is Incomplete Regarding SQL Commands ;-(
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... Create a Connection object and pass in a ConnectionString to ... manage the database table you reference. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: (Newbie)Application Roles
    ... level: the database itself. ... SQL Server accommodates these needs through the use of application ... the user's connection through a specific application. ... the connection permanently loses all permissions applied to ...
    (microsoft.public.sqlserver.security)
  • Re: Help! Set up Windows Group to access application
    ... The connection string for a trusted connection is: ... --add login as database user ... SQL Server MVP ... If you have troubles with finding your ways in Crystal Reports, ...
    (microsoft.public.sqlserver.security)
  • Re: My Book is Incomplete Regarding SQL Commands ;-(
    ... Visual Studio but not to VS 2003. ... Create a Connection object and pass in a ConnectionString to address ... manage the database table you reference. ... Yep, my latest book can help too, but mostly if you're targeting SQL Server ...
    (microsoft.public.dotnet.framework.adonet)
  • 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)