connection problems

[turrican]

can someone tell me where I am going wrong here? This is driving me nuts.

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

Dim MyConnection As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source= d:\DvdList.mdb;User Id=admin;")

MyConnection.Open()

it stops at the lasr line when I try to run it. I can connect to this database with the wizard but I want to learn how to do it like this. Please help.

 

[turrican]

oh and i did include the imports system.data.oledb at the top.

 

[a_jam_sandwich]

it looks ok to me maybe your username or password is wrong??

try

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
try
Dim MyConnection As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source= d:\DvdList.mdb;User Id=admin;")
MyConnection.Open()
catch
msgbox(err.description)
end try

See what comes up as the error, bound to be simple.

http://www.computerhelp.forum/showthread.php?s=&threadid=69746

Check the above link for a simple ado.net tutorial

Andy

 

[turrican]

I keep getting a message saying that the connection is not intialized. any ideas?

 

[turrican]

Hey it works. Thanks for all your help.

 

[hemenkap]

but i have a doubt

bot codes look the same excet that below we are handling an exception.
however handling exceptions is a good practice, it is not absolutely necessary

so i want to know where exactly was athe fault above.

please guide me.

Hemen

 

[turrican]

your right it is the same. I think that the problem was actualy in my sql command. I didnt have the reference to the connection at the end. I thought that the problem was with the connection because that is where the program originaly apeared to be stopping.