| Author |
 Topic  |
|
|
Alice
Recruit
26 Posts |
 Posted - 03/15/2004 : 1:48:49 PM
|
I posted this one under DNS-less connections several days ago. Don't want to sound like a nag, but I really need some help on this. Everything I've tried doesn't work!
I'm trying to add a password to the database, and I can't seem to get it to work with Pilot Cart. I've added the password to the database succesfully. I can connect to the database through a Dreamweaver connection string, but not through Pilot database_connect.asp. Tried putting in the password into the file. No success. Tried running pilot_setup.asp again. Still no success. Through pilot_setup.asp, I get this info to put into the connection file:
'DON'T EDIT this manually unless you know what you're doing. Instead . . .
'Use the Setup Wizard (controlpanel\pilot_setup.asp) to configure your database connection.
Const DB_PROVIDER = "Microsoft.Jet.OLEDB.4.0"
Const DB_SERVER = ""
Const DB_NAME = ""
Const DB_USERNAME = ""
'For security reasons we do not print the password here.
'If using a password, please replace the asterisks (*) below with your password.
'DON'T EDIT this manually unless you know what you're doing. Instead . . .
'Use the Setup Wizard (controlpanel\pilot_setup.asp) to configure your database connection.
Const DB_PROVIDER = "Microsoft.Jet.OLEDB.4.0"
Const DB_SERVER = ""
Const DB_NAME = ""
Const DB_USERNAME = ""
'For security reasons we do not print the password here.
'If using a password, please replace the asterisks (*) below with your password.
Const DB_PASSWORD = ""
Const DB_PATH = "d:\wwwroot\ourdomain.com\database"
'For security reasons we do not print the password here.
'If using a password, please replace the asterisks (*) below with your password.
Const CONNECTION_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\wwwroot\ourdomain.com\database\database.mdb;"
Const DB_PATH = "d:\wwwroot\ourdomain.com\database"
'For security reasons we do not print the password here.
'If using a password, please replace the asterisks (*) below with your password.
Const CONNECTION_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\wwwroot\ourdomain.com\database\database.mdb;"
There aren't any asterisks to replace! What I've tried is adding info like this:
'DON'T EDIT this manually unless you know what you're doing. Instead . . .
'Use the Setup Wizard (controlpanel\pilot_setup.asp) to configure your database connection.
Const DB_PROVIDER = "Microsoft.Jet.OLEDB.4.0"
Const DB_SERVER = ""
Const DB_NAME = ""
Const DB_USERNAME = ""
'For security reasons we do not print the password here.
'If using a password, please replace the asterisks (*) below with your password.
Const DB_PASSWORD = "ourpassword"
Const DB_PATH = "d:\wwwroot\ourdomain.com\database"
'For security reasons we do not print the password here.
'If using a password, please replace the asterisks (*) below with your password.
Const CONNECTION_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\wwwroot\ourdomain.com\database\database.mdb;pwd=ourpassword"
Which to the best of my knowledge should work but doesn't. I get this message:
-2147467259
There seems to be an error.
Could not find installable ISAM.
You may need to run the Pilot_Setup.asp file.
If you need help, contact ASPilot.com
Can you help? I'll appreciate any and all! |
|
|
zwemkec
Moderator
USA
713 Posts |
Posted - 03/15/2004 : 3:11:27 PM
|
Do you have the workgroup file on the server as well as the database?
p.s. Sorry about the delay, one of the forums was set to need moderation so we didn't see the post
<%
Chris Zwemke
zwemkec @ aspilot . com
www.aspilot.com
%> |
 |
|
|
Alice
Recruit
26 Posts |
Posted - 03/15/2004 : 3:44:30 PM
|
I've only tried it on my local testing server - wanted to get the bugs worked out before I applied it to the database on the website. I run two computers, connected simply by a passthrough cable. Internet connection is on computer "A"; server is on computer "B". I set this up through the XP wizards, and I suppose I do have a workgroup file. Is that what's messing it up? If so, why do you suppose I can connect to the passworded database through a Dreamweaver connection? I'll go ahead and try it on the website and see what happens.
No problem about the delay - I'm very appreciative, as always, for all your help. |
|
|
| |
Topic |
|
|
|
passwording Access database
