sql server 2005 express edition connection string

	Home Register Search Help Login

Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums

Recent Posts

Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

sql server 2005 express edition connection string

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP and Database >> sql server 2005 express edition connection string

Page: [1]


barking mad Posts: 268 Joined: 12/6/2002 From: Out in the sticks, UK Status: offline	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 _____________________________ The more I ask, the more I learn, the more I' m confused, therefore the more I ask ...

Spooky

Posts: 26560
Joined: 11/11/1998
From: Middle Earth
Status: offline

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"

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

��k�

Database / DRW help Check out the Tutorials for Frontpage Databases

Forum FAQ' s

Developers Edition Spooky Login User Registration and Management tool

Personalized Frontpage Hosting

(in reply to barking mad)


barking mad Posts: 268 Joined: 12/6/2002 From: Out in the sticks, UK Status: offline	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* _____________________________ The more I ask, the more I learn, the more I' m confused, therefore the more I ask ... (in reply to Spooky)

Page: [1]

All Forums >> Web Development >> ASP and Database >> sql server 2005 express edition connection string

Page: [1]

Jump to: 1

New Messages	No New Messages
Hot Topic w/ New Messages	Hot Topic w/o New Messages
Locked w/ New Messages	Locked w/o New Messages

Post New Thread

Reply to Message

Post New Poll

Submit Vote

Delete My Own Post

Delete My Own Thread

Rate Posts