You are Here: Home > ASP.NET Home > Asp.net Questions > SQL Server Express connection string, without \"Server=\" ?
Subscribe to Question

SQL Server Express connection string, without "Server=" ?

With venerable old Access, it was possible to make a DNS-less connection string by pointing to the MDB file. As long as the file was in the expected location within my ASP.NET site, all was well.

Is this possible as well with SQL Server Express?

I'm thinking not, because the only connection strings I can conjure up that connect to it either need:

- User Instance=True (which causes all sorts of file-creation activity in the c:Documents and Settings tree, which won't fly on a hosted site, or...

- User ID=MyName;Password=pwd; (which free-standing SQL Server Express files don't seem to understand, as login credentials are usually handled at the "server" level...and I'm trying to use SSE without a SQL Server installation)

If any of this doesn't make sense, first, I'm not surprised. Second, please ask me to elaborate.

- Tom

Nov 11, 2007 - tkc

Answers

Go to view menu, select serverexplorer selct database and table, right click get the properties of the table and select datasource. Copy and paste to the string (str) instead of the above command which can be used without server.

Dec 05, 2007 - ramjee70
1 - 1 of 1 First | Previous | Next | Last  
Newsletter
Copyright © 2013 VisualBuilder. All rights reserved

Warning: Unknown(): write failed: Disk quota exceeded (122) in Unknown on line 0

Warning: Unknown(): Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/tmp) in Unknown on line 0