|
| |
|
|
JohnH
Posts: 43
Joined: 12/1/2004
Status: offline
 |
SQL error - 5/1/2008 7:33:05
I am getting the following error after installing the spookylogin and trying to enter via the admin_main.asp page:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '='.
/includes/a_login.asp, line 48
Does anyone have any ideas?
Regards,
John
|
|
|
|
JohnH
Posts: 43
Joined: 12/1/2004
Status: offline
|
RE: SQL error - 5/1/2008 11:46:29
I am really stuck with this one, can anyone help?
| |
|
|
|
JohnH
Posts: 43
Joined: 12/1/2004
Status: offline
|
RE: SQL error - 5/1/2008 12:11:56
I've cracked it by modifying
Const sDateFormat = "yyyymmdd"
to
Const sDateFormat = "yyyyddmm"
in the a_config.asp file as per post:
http://www.frontpagewebmaster.com/m-272151/tm.htm#272151
Thanks,
John
| |
|
|
|
Spooky
Posts: 26597
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: SQL error - 5/1/2008 15:32:32
You beat me to it :)
| |
|
|
|
JohnH
Posts: 43
Joined: 12/1/2004
Status: offline
|
RE: SQL error - 5/7/2008 11:13:24
Hi Spooky,
I have had to recreate the database tables on my hosted SQL database. I used the login.sql file for this.
Now that I have done this I am getting the same error as above. I have tried changing the data format in noth ways to no avail.
Any ideas?
Regards,
John
| |
|
 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¥ 