Help needed!!

[Angus]

Need help urgently.

Doing a project using ASP, said that I'd use ADO rather than ODBC so that the DSN didn't have to be set by the server admin.

Hand in date nearing and I've just realised that I'm not using ADO.

thought it might just be a case of changing the connection, but now it won't execute my SQL strings (worked fine before with ODBC).

My SQL string:

	strSQL = "SELECT * FROM user "
	strSQL = strSQL & "WHERE userName = '" & Replace(Request.Form("userName"), "'", "''") & "' "
	strSQL = strSQL & "AND userPassword = '" & Replace(Request.Form("userPassword"), "'", "''") & "';"

This is how it appears if I take all the executable stuff out to see what it's doing:

SELECT * FROM user WHERE userName = 'admin' AND userPassword = 'admin';

The error I get in explorer:

Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error in FROM clause.
/projectsystem/System/ASPs/login.asp, line 58

[Spunkey]

im assuming youur using access, if so just use the standard access connection string which you'll find in a link in the Useful Resources sticky at the top of the page

HTH

[Angus]

you trying to leave me hanging in suspense?

[Angus]

Have now tried all the connection strings that appear to be appropriate on the Able Consulting site. I'm still unable to get any of the DSN-less methods to work.

[Shad]

Can you get any queries to work at all?

[Angus]

nothing

[Spunkey]

hmmm intriguing watson.

could you post the offending bit of code up so we can have a quick gander?