Re: update query ODBC--call failed

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi Bob,

Thanks for that, I an running vista ultimate. I have done a search for the latest version of MDAC, which appears to be 2.8 back from 2003. My laptop is only 12 months old, so assume it would already be installed.

I also note from other info on MDAC, vista uses something called Windows DAC

Ultimately I want to post this small application on my server, (win2008) as a runtime to do some import and updates on some tables on the local server SQL database.

I am doing it this way as I need to import data from spreadsheets then run add/update queries to modify the data in the SQL tables, without the complication of using bulk insert commands, which is causing me no end of problems.

So by using import data from the spread*** into temp access tables, then run the update query on the relevant tables in the SQL database

Regards
Lez


"Bob Barrows" <reb01501@xxxxxxxxxxxxxxx> wrote in message news:eiN0e8aRKHA.4600@xxxxxxxxxxxxxxxxxxxxxxx
Lez wrote:
Hi Guys,

I am trying to do an update query to an SQL table in a local db, and
each time I run the query I get this error message:

ODBC--call failed
[Microsoft][ODBC Driver Manager] invalid argument value(#0)

And no data gets updated, can anyone advise please?

The SQL table is a linked table in the access database

Very hard to say. In fact, it's impossible without more information. I am a little unclear about why the "ODBC Driver Manager" is reporting the error rather than the "ODbc Driver For SQL Server" (not the exact wording). Since the SQL Server Driver is not reporting the error, it is probably a problem with ODBC itself.

It sounds as if ODBC is not correctly installed on your machine. I would start by downloading the latest version of MDAC from Microsoft and installing it (just do a search at support.microsoft.com to find the KB article that describes how to find the latest version of MDAC that is relevant for whatever operating system you are using ... incidently, that is one of the pieces of information that is missing from your post).


--
Microsoft MVP - ASP/ASP.NET - 2004-2007
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.

Quantcast