Suzuki
|
| Posted: 01/13/2005, 11:21 PM |
|
Please help me to make a connection to a system database. It keeps asking for the group information file. After studying this forum, I added the system.mdw in the connection string and it gives me the error of "invalid account or password. CodeCharge really drives me crazy after spending five hours for nothing.
These are what I tried for connection:
1. ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=C:\Program Files\CodeChargeStudio\Projects\PPPP\Internet.mdb.mdb;Persist Security Info=False
This string gave me an error "Workgroup information file or other user opens exclusively.
2. ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=C:\Program Files\CodeChargeStudio\Projects\PPPP\Internet.mdb;Persist Security Info=False;Jet OLEDB:System database=C:\Program Files\Microsoft Office\Office\system.mdw
This string gave me an error "invalid account or password"
3. ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=" & Server.MapPath("Internet.mdb") & ";Persist Security Info=False
This string gave me an error as attempt #1.
I have these errors both in the CodeCharge and browser.
How can I create a standard database instead of system database such that I do not need the workgroup information file.
All I did to the bookstore example of codecharge is setting up the password for database and connection string.
Can anybody can send me the bookstore sample with the connection to the database with password? or show me how to make a connection to a password protected MS Access database.
Thanks in advance.
|
|
|
 |
mrachow
Posts: 509
|
| Posted: 01/13/2005, 11:55 PM |
|
The easiest check should be creating an ODBC datasource. Here you would specify the system file. And now you can check if you have access to your Access database.
The selection of the ODBC datasource is then easy in Studio.
_________________
Best regards,
Michael |
 |
|
peterr
Posts: 5971
|
| Posted: 01/14/2005, 12:00 AM |
|
Yes, ODBC is another method of connecting and you can try that instead.
If you still try Jet, please do not use any .mdw files and do not specify any password. Your first connection string has a small error: Internet.mdb.mdb instead of Internet.mdb
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
Suzuki
|
| Posted: 01/14/2005, 6:58 AM |
|
Thank you for fast response.
I like to use DNS-less with password protected MS Access database .
I test the bookstore sample fine with DNS-less connection and database with no password.
Please help with questions:
1. Do I need to convert the database from system database to standard database for DNS-less connection? If yes, how?
2. Is this Connection string correct to test both in CodeCharge and browser?:
ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=" & Server.MapPath("Internet.mdb") & ";Persist Security Info=False
If not, what is it?
3. What could be a tricky one to make it work?
Thanks a bunch,
|
|
|
|
peterr
Posts: 5971
|
| Posted: 01/14/2005, 9:48 AM |
|
In this case your 2nd string could be almost correct, but it needs to have the login and password as well.
Take a look at http://www.able-consulting.com/MDAC/ADO/Connection/OLED...iders.htm#OLEDB
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\somepath\mydb.mdb;Jet OLEDB:System Database=MySystem.mdw", "myUsername", "myPassword"
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
Suzuki
|
| Posted: 01/14/2005, 12:21 PM |
|
I tried :
ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\CodeChargeStudio\Projects\PPPP\PPPP.mdb;Jet OLEDB:System Database=C:\Program Files\CodeChargeStudio\Projects\PPPP\System.mdw;User Id=admin;Password=XXXXXX"
Error:
Unable to establish connection to database.
Error information:
Microsoft JET Database Engine (0x80040E4D)
Not a valid account name or password.
What could be wrong? Not my password.
Thanks a bunch for keeping up with me.
|
|
|
|
Suzuki
|
| Posted: 01/14/2005, 12:25 PM |
|
I mean "User Id=Admin". What could be wrong?
|
|
|
|
