Connect to an AccessXP database (VB.net)

[Aurel]

Hi !

I am trying and reading now for more than 5 days, but it seems as if i am not clever enough to find the right hints

Most probably you can help me to solve my problem.

I have a VB.net Windows Application and i like to have access on a AccessXP - Database.

I dont like to use the wizard for 2 reasons:
- i like to know who it works, and
- i like to use my own form for showing/editing the data.


I created a new module for the database stuff (i hope thats not the 1st mistake i made :-/ )

I took the code below from this board and put in the Provider for an AccessDB:

    Dim oConnection As New OleDb.OleDbConnection()
    Dim oCommand As New OleDb.OleDbCommand()
    Dim oDataReader As OleDb.OleDbDataReader
oConnection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Password="";User ID=Admin;Data " & _
"Source=F:\Manfred\Fraktura\Fraktura.mdb"

oConnection.Open()

but VB starts to underline
oConnectionin

oConnection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Password="";User ID=Admin;Data " & _
"Source=F:\Manfred\Fraktura\Fraktura.mdb"

(the DIM lines seem to be ok)

and the help says, that he is expecting a declaration.

Ok. I hope you can help me, or give some hints of a homepage, where i can find further informations

(perhaps you can tell me too, where i best place the database-code)

Thank you a lot in Advance !!

---
p.s. i hope its ok when i post it in here (ado.net)

 

[Aurel]

damn it
i am really sorry about it, but i went on looking for the solution, and i found it

---- Closed ----