Application.StartupPath Problem. [Resolved]

Printable View

Apr 18th, 2003, 02:32 AM
albertlse

Application.StartupPath Problem. [Resolved]

Instead of setting a static path: "C:\Project\...\...\",
I use "Application.StartupPath" to set the default path of the application dynamically during run-time.

It works well all the while, but I encounter some problem in the situation below:

I use an "OleDbConnection" to set a connection to Access database. And the connection string below is created:

Provider=Microsoft.Jet.OLEDB.4.0;Password="";User ID=Admin;Data Source=D:\Albert\Visual Basic .NET\Address Book\bin\Database\Database.mdb;Mode=Share Deny None;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False

I try to change the Data Source of this OleDbConnection to refer to "Application.StartupPath & \Database\Database.mdb"
because not every PC have this same path.

This changes is done in the View Code mode under "Windows Form Designer generated code" region.

After changing, the "OleDbConnection" connection string is like below:

Provider=Microsoft.Jet.OLEDB.4.0;Password="";User ID=Admin;Data Source=" & Application.StartupPath "\Database\Database.mdb;Mode=Share Deny None;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False

When I run the program, the error occurs showing that the database cannot be found.

When I debugged it deeper, I found that the Data Source is not refer to "Application.StartupPath\Database\Database.mdb"

It actually refer to "C:\Program Files\Microsoft Visual Studio .NET\Common7\IDE\Database\Database.mdb"

Why is this so? How can I solve this problem?

Please guide. Thank you!

Re: Application.StartupPath Problem.

I didn't read the whole post but is this what you're talking about!

VB Code:

Dim MyPath as string =application.startup & "\filename.xxx"
Dim MyPassword as string =nothing 
 
Private My_Connection As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & MyPath & ";Jet OLEDB:Database Password=" & MyPassword)

Re: Re: Application.StartupPath Problem.

Little change :D

VB Code:

Dim MyPath As String = Application.StartupPath & "\__mydb__.mdb"
Dim MyPassword As String = nothing

Apr 18th, 2003, 02:52 AM
Lunatic3

Quote:

Provider=Microsoft.Jet.OLEDB.4.0;Password="";User ID=Admin;Data Source=" & Application.StartupPath "\Database\Database.mdb;Mode=Share Deny

You hamve missed & bettween Application.StartupPath and "\Database\...
Apr 18th, 2003, 03:45 AM
albertlse

It is working fine now! Thank you. :)
Apr 18th, 2003, 05:13 AM
russgreen

don't need app.startup path

If your db resides in the same folder as the exe then you don't need application.startuppath. Just use the name of the db. Also you should be careful with Application.StartupPath as I understand it this is NOT the path to the exe but the Start In path in the shortcut. This defaults to the app.path(vb6) when the path in the shortcut is blank, however, .....

Russ
Apr 18th, 2003, 05:32 AM
Lunatic3

Quote:

If your db resides in the same folder as the exe then you don't need application.startuppath. Just use the name of the db.

Noooooooooooo!
That works untill you have not changed the parent directory. It may happen that you change it in your application without you being noticed and so it will fail. I have faced the situation and dont recommend this at all. And here was the situation.
1. Loaded the database and filled some dataset
2. Showed the report using that dataset and Crystal Reports
3. Exported the report, for example to C:\
4. Closed the report and tryed to load the database again. It failed

Here it looks in C:\ for my database cause now the parent directory has changed without you even thinking that it has changed.

So always try the full path.

Quote:

Also you should be careful with Application.StartupPath as I understand it this is NOT the path to the exe but the Start In path in the shortcut. This defaults to the app.path(vb6) when the path in the shortcut is blank, however, .....

never faced any problem with it, can you bring a smaple that makes problem?
Apr 21st, 2003, 10:44 AM
albertlse

Problem again!!!

I've change the Connection String of the Database Connection to the following one:

(changed in "Windows Form Designer generated code" region)

Me.EntryConnection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Password="""";User ID=Admin;Data Source=" & _
Application.StartupPath & "\Database\Database.mdb;Mode=Share" & _
" Deny None;Extended Properties="""";Jet OLEDB:System database="""";Jet OLEDB:Registr" & _
"y Path="""";Jet OLEDB:Database Password="""";Jet OLEDB:Engine Type=5;Jet OLEDB:Datab" & _
"ase Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Tra" & _
"nsactions=1;Jet OLEDB:New Database Password="""";Jet OLEDB:Create System Database=" & _
"False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=Fa" & _
"lse;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False"

It works well after changing just for a while only!!!

Unfortunately, without my notice, the Connection String change to the following one:

Me.EntryConnection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Password="""";User ID=Admin;Data Source=" & _
"C:\Program Files\Microsoft Visual Studio .NET\Common7\IDE\Database\Database.mdb;Mode=Share" & _
" Deny None;Extended Properties="""";Jet OLEDB:System database="""";Jet OLEDB:Registr" & _
"y Path="""";Jet OLEDB:Database Password="""";Jet OLEDB:Engine Type=5;Jet OLEDB:Datab" & _
"ase Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Tra" & _
"nsactions=1;Jet OLEDB:New Database Password="""";Jet OLEDB:Create System Database=" & _
"False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=Fa" & _
"lse;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False"

It makes me cannot open my database file.

Why and how is this happening? It's so weird.

How can i stop it from changing without my notice?

Please guide. Thank you.
Apr 21st, 2003, 11:06 AM
Pirate

They look completely different ! What have you done with it ?:rolleyes:
Apr 21st, 2003, 01:51 PM
Lunatic3

It happens to me to and I think the reason is you have removed the connection from Server Explorer. Try not deleting the connection in Server Explorer in IDE or if deleted already add it again and see if it happens.