hi all:
I am a newbie , trying to connect my access to vb.net express edition I wrote the following code:

Imports System.Data
Public Class Form1

Private Sub btnLoad_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLoad.Click
Dim con As OleDb.OleDbConnection
con.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0 ; Data Source = "C:\Documents and Settings\shassanzadeh\Desktop\Sara\extra\AddressBook.mdp"

End Sub
End Class


but the compiler gives me error for this line:
con.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0 ; Data Source = "C:\Documents and and Settings\shassanzadeh\Desktop\Sara\extra\AddressBook.mdp"


the erros says:Character constant must contain exactly one character.
can you guys help me ...

Re: how to connect my data base in vb.net 80 80

You don't need to surround the database path in quotes inside a connection string. The key/value pairs are all delimited. It should look like this instead.

con.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0; Data Source=C:\Documents and Settings\shassanzadeh\Desktop\Sara\extra\AddressBook.mdp"
Re: how to connect my data base in vb.net 80 80

thanks hamrick
I did that now I have this code :
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
'seting the data connection
Dim sql As String
Dim con As New OleDb.OleDbConnection
Dim ds As New DataSet
Dim da As OleDb.OleDbDataAdapter
con.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0; Data Source=C:\Documents and Settings\shassanzadeh\Desktop\Sara\extra\AddressBook.mdp"
'setting the data Adaptor and Data set

con.Open()
Sql = "SELECT * FROM tblContacts"
da = New OleDb.OleDbDataAdapter(Sql, con)
MsgBox("connection open")
con.Close()
MsgBox("connection close")

End Sub

and no syntex error but while I compile it doesnt show any thing and after that I get this error"OleDbException was unhandled "and it poits to a yellow line on con.open()
well according to this link because I am using express edition , I should set my project refrences to System.Xml.dll but here there is no such thing it is only system.xml what do you think I should do?

Re: how to connect my data base in vb.net 80 80

because I am using express edition , I should set my project refrences to System.Xml.dll but here there is no such thing it is only system.xml

System.Xml and System.Xml.dll are the same thing in the reference picker. But that reference should have been added when you made a windows forms project...

Re: how to connect my data base in vb.net 80 80

i changed that but still it gives errors on the line con.open()
I redo it again also I enclude at the top system.Xml but still it doesnt work. :'(

Re: how to connect my data base in vb.net 80 80

What message does the exception give you?

Re: how to connect my data base in vb.net 80 80

it says it cant find this file while I double checked and the path is 100%correct

Re: how to connect my data base in vb.net 80 80

Put it somewhere else without all of the extra nesting, like C:\. Make sure that the extension is right. If this is access, it should be *.mdb, not *.mdp, I think. When it tells you it can't find the file, it can't find the file. :) That means the connection string is wrong somehow.

Re: how to connect my data base in vb.net 80 80

Read this article and you can even download a working sample which uses Connection to Access DB through ASP. Click here

Re: how to connect my data base in vb.net 80 80

thankx hamrick it is solved

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.