garymgordon
Posts: 7
|
| Posted: 11/16/2004, 7:43 AM |
|
I have no problem connecting to a particular database when I remove the password. But when I set a password on the database .. I have problems. (MS ACCESS 2000 Database)
1. When I set up the connection to the database (which is password protected) .. I can test it and it test fine. This is in the Data Link Properties window. It ends up testing fine.
I end up having to use the SERVER tab, then connecting using "Use Connection String" and unchecking the box for "Same as Design".
When I try to use Microsoft Jet 4.0 - I get an error.
When I use Microsoft OLE DB Provider for ODBC Drivers ... and enter the password .. everything is fine ... up until after I click the OK button.
Also when I select the Data Source I need to go into Machine Data Source .. etc.
But I don't want to set up a DSN. I want DSN-less.
The error I am getting is ...
"Test connection failed because of an error in initializing provider. Cannot start your application. The workgroup information file is missing or opened exclusively by another user."
I just don't understand why I get this error ONLY when the database has a password protecting it?
I am a novice at this .. and would greatly appreciate your clear guideance on how to fix this.
I looked online at your information titled "Configuring the Server-Side Database Connection" but that didn't seem to correct it.
Help?
Thanks,
Gary Gordon
PS: The connection string is currently set to:
Provider=Microsoft.Jet.OLEDB.4.0;Password=xxxxxxx;Data Source=C:\Program Files\CodeChargeStudio\Examples\Internet\directory_with_password.mdb;Persist Security Info=True
PS: If you could IM me to help me with this .. it would be appreciated. My IM on AOL and Yahoo is garymgordon. My IM on MSN isgarymgordon@hotmail.com .
_________________
Gary M. Gordon
Webmaster - Developer.Designer.Programmer
ggordon@garymgordon.com
http://www.garymgordon.com/
New Jersey, USA
|
 |
 |
Marcus
Posts: 49
|
| Posted: 11/16/2004, 10:10 AM |
|
Your RESUME on yoyr website http://www.garymgordon.com/ says that you have expertise in
* JAVASCRIPT
* ASP / VBScript
* DATABASES: MySQL, MS ACCESS, MS SQL, as well as others including flat files
* CGI / PERL / PHP
THAN HOW COME YOU CANNOT FIGURE OUT A SIMPLE PROBLE?
|
|
|
|
garymgordon
Posts: 7
|
| Posted: 11/16/2004, 10:22 AM |
|
Marcus,
Well ... maybe it's old age. hahaha
So, ... what is the answer (if the problem is so simple)?
Gary
_________________
Gary M. Gordon
Webmaster - Developer.Designer.Programmer
ggordon@garymgordon.com
http://www.garymgordon.com/
New Jersey, USA
|
|
|
|
peterr
Posts: 5971
|
| Posted: 11/16/2004, 12:21 PM |
|
Gary,
1. What is the DSN-less connection string that you are using?
2. Where do you see this error? On the ASP page in the Web browser, or inside CCS as a Windows error dialog?
Also see:
http://www.google.com/search?hl=en&lr=&q=asp+jet+%22ms+...e+is+missing%22
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
garymgordon
Posts: 7
|
| Posted: 11/16/2004, 12:50 PM |
|
Peterr,
Ok. (thanks) So ....
How can I change the connection string from something like:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\CodeChargeStudio\Examples\Internet\directory_with_password.mdb;Persist Security Info=True;"
to
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\CodeChargeStudio\Examples\Internet\directory_with_password.mdb;Properties("Jet OLEDB: Database Password") = njcu2012002189;Persist Security Info=True;"
Something is wrong in the above line .. but based on what I saw in:
http://www.andreavb.com/forum/viewtopic_3628.html
I need to do something like this ... correct?
Can you tell me what the connection string should be for this?
Thanks,
Gary
_________________
Gary M. Gordon
Webmaster - Developer.Designer.Programmer
ggordon@garymgordon.com
http://www.garymgordon.com/
New Jersey, USA
|
|
|
|
peterr
Posts: 5971
|
| Posted: 11/16/2004, 1:05 PM |
|
Gary,
What about my 2nd question?
Because I don't know if we're talking about connecting CCS, or connecting your ASP application to the database.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
garymgordon
Posts: 7
|
| Posted: 11/16/2004, 1:14 PM |
|
Peter,
Well...
I get the error when I am in CCS trying to create the connection.
But ... even if I finagle a way around it .. I end up getting an error when I go to the webpage (looking at it locally on my PC .. through "localhost".)
I hope that helps you.
:)
If you need more specific information, just let me know. I greatly appreciate your help.
Gary
_________________
Gary M. Gordon
Webmaster - Developer.Designer.Programmer
ggordon@garymgordon.com
http://www.garymgordon.com/
New Jersey, USA
|
|
|
|
peterr
Posts: 5971
|
| Posted: 11/16/2004, 2:44 PM |
|
OK, here are all the various connection strings for MS Access:
http://www.able-consulting.com/MDAC/ADO/Connection/OLED...ForMicrosoftJet
So in CCS you can use:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C\...database.mdb;Jet OLEDB:Database Password=password
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
garymgordon
Posts: 7
|
| Posted: 11/16/2004, 2:50 PM |
|
Peter,
Thank you. That's perfect.
Gary
_________________
Gary M. Gordon
Webmaster - Developer.Designer.Programmer
ggordon@garymgordon.com
http://www.garymgordon.com/
New Jersey, USA
|
|
|
|
