Problem while connecting to DataBase ASP.NET

Question

I have a database in the same workspace, I've tried to connect to this DB using this codes :

Dim CX As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data source=" & "./Learning.mdb")

Dim CX As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data source=" & "~/Learning.mdb")

Dim CX As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data source=" & "~Learning.mdb")

But none of them work.

File 'c:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\Learning.mdb' not found. — Farmer
– Farmer, Commented Jun 22, 2010 at 23:58
c: \ Program Files \ Microsoft Visual Studio 9.0 \ Common7 \ IDE \ ~ \ Learning.mdb 'is not a valid path. Make sure the name of the path is correct and a connection is established with the server on which the file resides. — Farmer
– Farmer, Commented Jun 22, 2010 at 23:59
Sure, it work just if I specify the full path like : "C:\Users\ZiGi\Desktop\IHM\Learning\Learning.mdb" And my website is inside the folder Learning\ — Farmer
– Farmer, Commented Jun 23, 2010 at 0:05

JBrooks · Accepted Answer · 2010-06-23 00:07:46Z

4

Try:

        Dim CX As OleDbConnection = New 
    OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data source=" &
 System.AppDomain.CurrentDomain.BaseDirectory & "/Learning.mdb")

answered Jun 23, 2010 at 0:07

JBrooks

10k2 gold badges31 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Problem while connecting to DataBase ASP.NET

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related