sql server 2005 express edition connection string (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

barking mad -> sql server 2005 express edition connection string (4/20/2008 13:26:17)

i think i'm being a bit dim tonight can someone let me have a connection string for ms sql server 2005 express edition please?

I've set the database up on the server

instance is standard SQLExpress

database name is mydatabase

username is mylogin

password is mypassword

I'm using ASP vbscript

thanks



Spooky -> RE: sql server 2005 express edition connection string (4/20/2008 18:33:21)

Heres one example that may work for you : 

datastore = "Provider=SQLOLEDB.1; User ID=mylogin; Password=mypassword; Initial Catalog=mydatabase; Data Source=.\SQLExpress"



barking mad -> RE: sql server 2005 express edition connection string (4/25/2008 4:14:18)

I am using this one quite successfully 

conSQLServer.ConnectionString = "Provider=SQLNCLI;Server=serverinstance*;Database=dbname;UID=dbusername;PWD=dbpassword;"



re serverinstance, in this case SERVER\SQLEXPRESS



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.0470047