SQL error (Full Version)

All Forums >> [Product Help] >> Spooky Login Product Support



Message

JohnH -> 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 -> RE: SQL error (5/1/2008 11:46:29)

I am really stuck with this one, can anyone help?



JohnH -> 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 -> RE: SQL error (5/1/2008 15:32:32)

You beat me to it :)



JohnH -> 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



Spooky -> RE: SQL error (5/7/2008 15:30:08)

At line 47, can you add these 2 lines of new code to see what format is being passed? 

Call GetUserRecord()
response.write sSQL
response.end



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.078125