problem connecting to access

[shvonne]

i try to connect my project in interdev to a local copy database on my comp using add connection method. but an error call "ADO could not find the specified provider" occur...

any idea?

[Dr_Michael]

Goto: Control Panel->ODBC32Bit->System DSN->Add->Microsoft Access Driver->Finish.
Give a Data Source Name (your choice) and then select the database (the .mdb file). After that, in your code you must point to this connection with the source name you provided (e.g. if you gave a name "MyDB", then you must type:

Dim db as adodb.Connection
set db = new adodb.Connection
db.Open "PROVIDER=MSDASQL.1;Data Source=MyDB;"




Michael Vlastos
Company MODUS SA
Development Department
Athens, Greece
Tel: +3-01-9414900

[shvonne]

hai michael..

i try it out.. didn't work.. still the same problem... =(

i'm using ADO in interDev... is there any different from VB?

[Dr_Michael]

Sorry my friend, beyond my knowledge...

Michael Vlastos
Company MODUS SA
Development Department
Athens, Greece
Tel: +3-01-9414900

[shvonne]

is ok.. thanks anyway