80040e4d error SQL OLE DB

[JoeMost]

Hi,


I recently upsized from Access to SQL database. I now get the error
message:

Microsoft OLE DB Provider for SQL Server error '80040e14'

Line 1: Incorrect syntax near '`'.

/_ScriptLibrary/Recordset.ASP, line 636


Any thoughts as to where to look for this problem?

Thanks
Joe

 

[Nanda]

when do u get this error, while connecting or executing any SQL statement. well, possible reason i could think of,
-make sure you have permissions to database,
- username and password used have permissions to network, server and database.
-check DSN is not marked Exclusive, if using DSN to connect to database
-make sure you have not used any reserved word.

See, if it solves your problem.

 

[JoeMost]

Hi Nanda,

I get this message when I try and fire any .asp page that
is connected to the SQl DB. Other .asp pages working off an Access DB worksfine.

I am using a DSN-less connection string:

Provider=SQLOLEDB.1; Network Library=dbmssocn;Password=ocean;User ID=team;Initial Catalog=staff;Data Source=64.224.18.49;

Does this help isolate anything?

Thanks
Joe

 

[Nanda]

Definitely, there is something wrong with database statements. try debugging it in steps
1. take database connect statements and make a new asp page with no other code in it except connecting to database. check you are connected. then,
2. try to read, write any table as test, successful, then
3. take any sql statement from your asp pages, and test
I am sure it may not appear shrt cut, but it helps.

...
hey, do you have string field values assigned using (') single quote.....if yes, check it is single quote not (`). if you copy code from other environment to asp, sometimes quotes formation is different. just try overwritting single quotes again with actual single quote in asp i.e. (')..try this first.

 

[JoeMost]

Thanks again Nanda!

Yes, I followed your instructions and it worked on
the test page fine. So I guess the connection string is OK.


I looked for any (') single quote discrepancies and did
find quite a few. I will change them and see what happens.


Another asp page I have gives me this error:


Microsoft OLE DB Provider for SQL Server error '80040e10'

No value given for one or more required parameters.

/_ScriptLibrary/Recordset.ASP, line 636

Any clue what is missing here? Again these pages all worked
fine when I used MS Access.

Regards

Joe

 

[Esoteric]

Hey post your Query statement if you are running Access now and are converting to SQL you might have some problems due to the QUERY.

For instance with Access when running a QUERY with a date you might use '#02/10/01#' but in SQL you don't use the # so its '02/10/01' There are also some other minor differences that would cause your QUERY to break.

 

[Nanda]

Joe,

for error
No value given for one or more required parameters.
check, you have assigned value to all required fields.

Also compare the database structure of Access vs SQL. You may find, Access does not have a particular required field but SQL. So, insert statement is looking VALUE for that REQ field.

Hope this helps.