Are you able to update any of the SQL Server tables? QuinStreet does not include all companies or all types of products available in the marketplace. Hello Dirk, My last two replies will give you some detail of the process. When the error occurs, I am opening our MSaccess program that we use to query our mssql database, which is remotely hosted. No I cannot update the tables as I don’t know what is wrong.

Uploader: Gardazragore
Date Added: 25 June 2009
File Size: 16.51 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 68323
Price: Free* [*Free Regsitration Required]

Scenario 1 – Error occurs when trying to insert data into a database Scenario 2 – Error occurs when trying to open an ADO connection Scenario 3 – Error occurs inserting data into Access, where a fieldname has a space Scenario 4 – Error occurs inserting data into Access, when using adLockBatchOptimistic Scenario 5 – Error occurs inserting data into Access, when using Jet.

Is that in fact an application that you are involved with in ldbc way? I ask because it’s entirely possile that those KB articles are irrelevant to your problem, and it’s just coincidence that the error code they’re dealing with is also the one you’re getting.

Thanks for your reply. The error typically looks like:. It’s hard to diagnose when you are restricted from the data source.

This odvc may impact how and where products appear on this site including, for example, the order in which they appear. Is this the same problem as this?


asp classic – Query creating issue with ODBC drivers – Stack Overflow

Results 1 to 16 of 16 Thread: I have passed this information along to our shared odbbc technical support for the database and have been told there is no problem with the log or the database, essentially leaving it to us to fix. If none of these are feasible, you can either change the cursor type, or change the cursor location, or use SQL statements instead. You can follow the question or vote as helpful, but you cannot reply to oebc thread.

The first three techs I spoke to from this company had not ever heard of transaction logs! I also print the same 80400e21 and execute it directly in my database and it is working. ODBC driver does not support the requested properties hi, odbc driver 5 is beta version.

Here is the most current code: I just moved my site to a new server. Also, why do you need to set the provider as such? This forum is now closed to new posts, but you can browse existing content. When i search for something like “www. Extract 80040e221 from database without using hard drive. When the error occurs, I am opening our MSaccess program that we use to query our mssql database, which 800402e1 remotely hosted.

The time now is ODBC driver does not support the requested properties. Otherwise it’s hard to discern the purpose of your SQL Statements and such.


Ovbc can find out more information about the move and how to open a new account if necessary here. The error is caused by attempting to specify a value for an unsupported property in the Connection Object’s connection string.

If you get stuck you can get support by emailing forums sitepoint. For example, suppose your database does not support adDBDate, using the following code would generate an error: Thanks for any help.

While executing following error comes RUn-time error ‘ e21 ‘: I wonder if the recent upgrade involved a large number of inserts as data was transferred to a new database, and that filled up the log. I get no errors when I do that as they are all in my local machine.

Question about a run-time error ‘-2147217887 (80040e21) in MS access 2003

All of these problems occurred after they upgraded to the new server platform, yet they won’t believe me when I tell them we changed nothing, and so I’m stuck. Did this solve your orbc Scenario 2 – Error occurs when opening a connection The error will occur when you call the. Thank you for the reply.