[Resolved]connectionstring with password problem!

[senthilkumartd]

ADOOpenWithPassword = "Provider=Microsoft.Jet.OLEDB.3.51;user id=;Password='senthil';Data Source=F:\RengaPassword\Finance.mdb"
Adodc1.ConnectionString = ADOOpenWithPassword

I am using the above coding for connectionstring. But it shows the following error message:
"Can't start your application. The workgroup information file is missing or opened exclusively by another user"

But the file is not already opened. The database password is also correct.

Where is the bug?. Is there any other connection string syntax?

[zynder]

Are you running your program on a domain server?

[senthilkumartd]

This is not the server. But one of the computer in local interanet. Peer to Peer connection. The OS is XP

[si_the_geek]

First off, you haven't specified the username (if it is a 'database password', use the username Admin).

Next up, is your password 'senthil' or is it senthil (without quotes)?

I think these changes may be what you need:
...OLEDB.3.51;user id=Admin;Password=senthil;Data Source...

[brucevde]

If it is a database password use

ADOOpenWithPassword = "Provider=Microsoft.Jet.OLEDB.3.51;JET OLEDB: Database Password=senthil;Data Source=F:\RengaPassword\Finance.mdb"

[zynder]

Make sure you got the right username and password and try to test your connection first.

[senthilkumartd]

brucevde! It is a database password, I tried as per your sugession, it showing "Couldnot find installable ISAM" message.

[si_the_geek]

That tends to just mean that your connection string is not correct.. Try removing the space between "JET OLEDB:" and "Database Password".

Have you tried my suggestion?

[senthilkumartd]

si_the_geek

ADOOpenWithPassword = "Provider=Microsoft.Jet.OLEDB.3.51;user id=Admin;Password=senthil;Data Source=F:\RengaPassword\Finance.mdb"

This also showing the error "Can't start your application. The workgroup information file is missing or opened exclusively by another user"

[danasegarane]

Have a Look at this site

[senthilkumartd]

si_the_geek, I got connectionstring from your singnature.Thanks.
Thanks to all

[senthilkumartd]

thanks dana

[danasegarane]

If u have your answer please go to the thread tools and click "Mark Thread Resolved"