Relative path to mdb file

Printable View

Apr 10th, 2003, 11:31 AM
Chong

Relative path to mdb file

Is there a way I can specify a relative path to my mdb file instead of an exact path as showing below:

Quote:

Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=C:\VB Project\FormPractice\Login\Scholarship.mdb"

I have tried: Data Source=C:\...\Scholarship.mdb but this doesn't work. I also tried this: Data Source=Data\Scholarship.mdb but same thing happened. I receive an error.

Many thanks in advance!

Chong
Apr 10th, 2003, 11:39 AM
Shurijo

You can use your Application.StartupPath variable to create an absolute path based on relative information, etc. But you have to use an absolute path.

This would be more practical :

VB Code:

Private Shared My_Path As String = Application.StartupPath & "\webdb.mdb"
Private Shared My_Password As String = "YOUR PASSWORD"
 
Private Shared My_Connection As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & MyPath & ";Jet OLEDB:Database Password=" & MyPassword)

Apr 10th, 2003, 12:49 PM
Chong

Thanks for helping me. However, this is the error I got after I follow your suggestion.

Quote:

An unhandled exception of type ‘System.Data.OleDb.OleDbExcetion’ occurred in system.data.dll

I have always received this error if I did not put an exact path to the data source. I did a step by step debug and by using the application.startup variable, I was able see the correct path but after the cn.open(), the application just crashed with the above error.

Chong
:confused:
Apr 10th, 2003, 11:02 PM
Pirate

Check database name , path or post some of your code to see what's wrong ?
Apr 11th, 2003, 01:33 AM
chinhow

Catch Exception
Quote:

Originally posted by Chong
Thanks for helping me. However, this is the error I got after I follow your suggestion.

I have always received this error if I did not put an exact path to the data source. I did a step by step debug and by using the application.startup variable, I was able see the correct path but after the cn.open(), the application just crashed with the above error.

Chong
:confused:
VB Code:
```
Try
    cn.open()
Catch dbException as System.Data.OleDb.OleDbException
    Messagebox.show(dbException.message)
End Try
```
use above code to show what was the error occured
Apr 11th, 2003, 08:30 AM
Chong

Thanks! It's working now. I didn't know that the application.startup starts in the bin folder. I put the mdb files in there and it's working now.

Again, thanks!

Chong
Apr 11th, 2003, 09:37 AM
Pirate

errors regarding paths in ado.net can't be shown when using try...catch structure .;)