|
| |
|
|
A1234
Posts: 101
Joined: 10/7/2004
Status: offline
 |
DB Connection Trouble - 10/21/2004 22:32:27
I created a 2nd DB (spooky_login), copied all the DB files and pasted them in a new folder "employers". I renamed the DB Spooky2001 and placed it in "employers/fpdb" folder. I edited the db_conn.asp file (in the employers/includes folder) to read:
CONST DatabaseFolder = "\fpdb\spooky_login2001.mdb"
When I log into the employer/admin_main.asp, everything seems fine. I even renamed it "Employer Login Management Center" so there would be no mistakes as to which admin section I was in. However, when I make changes in the employer/admin_main.asp, employers/admin_users.asp, etc. - it changes the other DB in my root folder (data). To make sure I was logging into the right DB, I changed the code
"CONST DatabaseFolder "\fpdb\spooky_login2001.mdb"
to
"CONST DatabaseFolder "\fpdb\spooky_login2008.mdb", tried to log in again and it gave me the expected error. So I changed it back to
"CONST DatabaseFolder "\fpdb\spooky_login2001.mdb", and the error disappeared as expected. SO...it seems i'm connecting to the DB in my "employers/fpdb" folder, but anything I change in there changes the DB in the "data" folder. It baffles me to no end, how can this be happening?
|
|
|
|
A1234
Posts: 101
Joined: 10/7/2004
Status: offline
|
RE: DB Connection Trouble - 10/21/2004 22:58:42
I just ran a diagnostics on the DB from my root folder and this is the string:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Webs\nadras\data\spooky_login2000.mdb
I ran a diagnostics on my DB in my "employers" folder and here is that string:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Webs\nadras\fpdb\spooky_login2001.mdb
So each one seems to be connecting to a separate DB, but when I make changes to one DB, it changes the other DB too...???
| |
|
|
|
A1234
Posts: 101
Joined: 10/7/2004
Status: offline
|
RE: DB Connection Trouble - 10/22/2004 8:21:00
Thanks Spooky
With my very limited experience, I thought it might be easier to just create a new DB (maybe not). Well I changed the appName in my a_config.asp file in my "employers" folder. However, now when I go to make changes in the admin, both present this error message on the bottom of the page admin_system.asp (both, the one in the root folder and in employers folder)
Microsoft VBScript runtime error '800a0009'
Subscript out of range: '[number: 252]'
/includes/a_system.asp, line 264
| |
|
|
|
A1234
Posts: 101
Joined: 10/7/2004
Status: offline
|
RE: DB Connection Trouble - 10/22/2004 10:27:42
Actually just the employers/admin_system.asp page is giving the error above. (not the admin_system.asp in the root folder).
| |
|
|
|
A1234
Posts: 101
Joined: 10/7/2004
Status: offline
|
RE: DB Connection Trouble - 10/23/2004 9:30:59
I've searched the microsoft knowledge base and other forums, but can't seem to find this error anywhere. Does anyone know what this means?
Microsoft VBScript runtime error '800a0009'
Subscript out of range: '[number: 252]'
/includes/a_system.asp, line 264
This is a result of changing the appName in one of the config files (i think). More info on what I did is posted above.
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
k¥ 