By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,364 Members | 1,343 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,364 IT Pros & Developers. It's quick & easy.

Application.StartupPath

OuTCasT
100+
P: 374
Hi Guys.

Can anyone help me with a problem im having.

I knw in access u can save your db into the application/bin folder and read and write straight to it in ur application

I want to publish my application with the SQL database, right now i need to install sql express on the machine that i am installing the application because i cannot get the app to read the database that i have saved in the application/bin folder.

can anyone help me out with how the connectionstring is surposed to look, ive been to www.connectionstring.com but i dont find anyuthing there.
Mar 31 '08 #1
Share this Question
Share on Google+
3 Replies


ck9663
Expert 2.5K+
P: 2,878
What's your apps? VB? Access? ASP?

-- CK
Mar 31 '08 #2

OuTCasT
100+
P: 374
What's your apps? VB? Access? ASP?

-- CK
Windows app using sql database.

Expand|Select|Wrap|Line Numbers
  1. Provider=Microsoft.Jet.OLEDB.4.0; Data Source = c:\projects\vb1\books.mdb"
this is how i undestand how to connect using an access db and finding the location.
how would i do this with sql ?

i want to be able to publish the db with the application....right now i have to install sql express on the clients machine for it to read and write to the db

Expand|Select|Wrap|Line Numbers
  1. Data Source=[COMPUTER NAME]\SQLEXPRESS;Initial Catalog=ca2000;Integrated Security=True;Pooling=False
how does one get it to point to the db in the application/bin folder so when we publish it we can write/read to the db.
Apr 1 '08 #3

OuTCasT
100+
P: 374
wouldnt it be something like this

Expand|Select|Wrap|Line Numbers
  1. Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=ca2000;Data Source=C:\Users\user\Documents\Visual Studio 2008\Projects\Ca2000WINversion\Ca2000WINversion\bin\Debug\ca2000.mdf
Apr 1 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.