Database connection string

I am tryin to figure out what my database connection string is. I have my database under my _database folder. I used sql server express on my pc to create it if that matters. Does anyone have an example of what the connection string should like like? I was thinking something like this

"Data Source=e:\\web\\myusername here\\htdocs\\_database\\my database name;Persist Security Info=True;Integrated Security=SSPI;"

but it doesn't work.

Thanks for any help!

 

Hi,
I've created a few Webcasts for this sort of thing on DASP servers.
-> http://www.dasptv.com/
More are on the way...

Let me know if you find what you need, and if you don't please repost.
Salute,
Mark

 

I just watched your video at http://www.dasptv.com/avc-view.aspx?videoid=7&categoryid=1. I guess I am a little confussed. I thought I could create a database on my system like you show and then upload it straight to my _database folder in my root folder. But this does not look like the case. So I have to pay for the sql server 2005 or 2008, then upload the db and use the sql server 2005 control panel to get my db connection string?

 

Hi,
Don't fret, this does confuse a lot of developers.
I've spoken to the SQL and Visual Studio teams about this, they both agree this should be easier and Microsoft as a whole is working on better methods for both SQL Server and Visual Studio. (Deployment and local development)

As you may know SQL Server 2008 Express versions now have the ability to pump data, local to remote, which was not there in the past for Express versions.

You can add the Developer version of SQL Server 2008 to your local system for under $50 if you don't want to use the Express versions, it's on Amazon.com now.

Yes to get your current Express DB on-line you will need to add a SQL Server addon.

If you need any help just post. ;-)
Salute,
Mark

 

Thanks so much! I got it to work pretty easily with the help of your video!

 

Sweet ;-)