| Author |
|
mhdeaton
New User
Joined: October/03/2006
Location: United States
Online Status: Offline
Info: 10
|
| Added: April/09/2007 at 12:40pm | IP Logged
|
|
|
My installation is dsn less and I had to move tha aspprotect database file into a folder on my root called "access_db" becuase that where my host creaters an msacces database folder with permissions set.
Here's my error when trying to "Get_me_in.asp"
Microsoft VBScript compilation error '800a0400'
Expected statement
D:\HOSTING\MARKDEATON4\PASSWORD_ADMIN\../dataconn_inc.asp, line 25 DBQ=d:\hosting\markdeaton4\access_db\ASPProtect_access2002.m db;Driver={Microsoft Access Driver (*.mdb)};UID=Admin;Password=temp
I installed asp protect months ago successfully on this server but now that I really need it Im having trouble. Please help!! Thanks in advance.
|
| Back to Top |
|
| |
cwilliams
Admin Group
CJWSoft Web Software Developer
Joined: April/06/2004
Online Status: Offline
Info: 1729
|
| Added: April/09/2007 at 12:58pm | IP Logged
|
|
|
that error is not related to the data connection but more likely related t you messing up the format of the string and that line of code..
You need to go look at the original files and make sure you didn't remove/delete things that go on that line of code.. which I am fairly sure you did..
DBQ=d:\hosting\markdeaton4\access_db\ASPProtect_access2002.m db;Driver={Microsoft Access Driver (*.mdb)};UID=Admin;Password=temp
by itself as a line of code is totally invalid and will trigger a basic vbscipt error like you getting...
__________________
Best Regards,
Christopher Williams
www.CJWSoft.com
|
| Back to Top |
|
| |
mhdeaton
New User
Joined: October/03/2006
Location: United States
Online Status: Offline
Info: 10
|
| Added: April/09/2007 at 1:05pm | IP Logged
|
|
|
Here;\'s the origional
ConnectionString = "DBQ=C:\Inetpub\wwwroot\aspprotect\data\database\ASPProtect_ access2002.mdb;Driver={Microsoft Access Driver (*.mdb)};UID=Admin;Password=temp"
DatabaseType = "MSACCESS"
Im just missing "inetpub" which is irrevelant to my host correct ?
I took it from the "probable paths then simply edited the location to the database ??
am I missing somethinjg ?
Thanks for your prompt reply, its appreciated..
mark
|
| Back to Top |
|
| |
cwilliams
Admin Group
CJWSoft Web Software Developer
Joined: April/06/2004
Online Status: Offline
Info: 1729
|
| Added: April/09/2007 at 1:09pm | IP Logged
|
|
|
well, what you showed me for a line of code along with the error message is missing
ConnectionString = "
and the quote after it
I mean
DBQ=d:\hosting\markdeaton4\access_db\ASPProtect_access2002.m db;Driver={Microsoft Access Driver (*.mdb)};UID=Admin;Password=temp
as a line by itslef is not valid...
it's a value for a string and must be in quotes and set to a variable like in the original file
__________________
Best Regards,
Christopher Williams
www.CJWSoft.com
|
| Back to Top |
|
| |
mhdeaton
New User
Joined: October/03/2006
Location: United States
Online Status: Offline
Info: 10
|
| Added: April/09/2007 at 1:18pm | IP Logged
|
|
|
ok thats fixed (thanms..heres my new error
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xb5d0 Thread 0x675c DBC 0xdd86a04 Jet'.
D:\HOSTING\MARKDEATON4\PASSWORD_ADMIN\../scripts/populate_co nfig_variables_inc.asp, line 11
|
| Back to Top |
|
| |
cwilliams
Admin Group
CJWSoft Web Software Developer
Joined: April/06/2004
Online Status: Offline
Info: 1729
|
| Added: April/09/2007 at 1:20pm | IP Logged
|
|
|
ok,, well now your back to the same old song and dance that everyone goes through the 1st time they set up a data connection
http://support.cjwsoft.com/code/moreinfo27-1.htm
that path is wrong or permissions are not properly set.. its one or the other
__________________
Best Regards,
Christopher Williams
www.CJWSoft.com
|
| Back to Top |
|
| |
mhdeaton
New User
Joined: October/03/2006
Location: United States
Online Status: Offline
Info: 10
|
| Added: April/09/2007 at 1:23pm | IP Logged
|
|
|
lol...
Thanks , will you do it for 49.95 or what ever ?
|
| Back to Top |
|
| |
cwilliams
Admin Group
CJWSoft Web Software Developer
Joined: April/06/2004
Online Status: Offline
Info: 1729
|
| Added: April/09/2007 at 1:27pm | IP Logged
|
|
|
I can try but I would suggest you spend a little more time trying different things before you spend 50.00...
But if you want to spend the money I'll try to get it working... ultimately though if permissions are not right or your host wont fix permissions when asked I cant help either..
__________________
Best Regards,
Christopher Williams
www.CJWSoft.com
|
| Back to Top |
|
| |
mhdeaton
New User
Joined: October/03/2006
Location: United States
Online Status: Offline
Info: 10
|
| Added: April/09/2007 at 1:32pm | IP Logged
|
|
|
k, ill keep trying for a bit.. thanks. The path is right so im holding for godaddy now.
thanks
Mark
|
| Back to Top |
|
| |
cwilliams
Admin Group
CJWSoft Web Software Developer
Joined: April/06/2004
Online Status: Offline
Info: 1729
|
| Added: April/09/2007 at 1:35pm | IP Logged
|
|
|
ya, sorry to hear that
godaddy hosting seriously sucks when it comes to hosting ASP.. no doubt permissions are the issue.. good luck getting them to help.. and their interfaces for managing the site completely blow
I keep telling people to host with www.alentus.com or www.1and1.com
__________________
Best Regards,
Christopher Williams
www.CJWSoft.com
|
| Back to Top |
|
| |
cwilliams
Admin Group
CJWSoft Web Software Developer
Joined: April/06/2004
Online Status: Offline
Info: 1729
|
| Added: April/10/2007 at 4:24pm | IP Logged
|
|
|
customer resolved issue
__________________
Best Regards,
Christopher Williams
www.CJWSoft.com
|
| Back to Top |
|
| |
Active Info
Memberlist
Search
Help
Register
Login
Info: Please help dsn error
