Writing to database issue

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   I am new to using MS SQL I normally use mySQL.

I have setup a MS SQL database on my local computer. Using a DSN connection i have managed to connect to the database and run the setup file. All the tables and rows have been created.

However when i try and loggin i get the following error message:

====================================

Server Error in Forum Application
An error has occured while writing to the database.
Please contact the forum administrator.

Support Error Code:- err_SQLServer_loginUser()_update_USR_Code
File Name:- functions_login.asp

Error details:-
Microsoft OLE DB Provider for ODBC Drivers
Query cannot be updated because the FROM clause is not a single simple table name.