update query ODBC--call failed

[Lez]

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

Regards
Lez
Access 2007, SQL 2005,

 

[Bob Barrows]

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).

 

[Lez]

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 spreadsheet into temp access tables, then
run the update query on the relevant tables in the SQL database

Regards
Lez

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"

 

[Bob Barrows]

Sounds like you need to get MS Product Support involved. Based on my
Google results from searching for your error message, this seems to be
an issue that is under-the-hood so to speak. If you have uncovered a
bug, you will not be charged for the call.

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 spreadsheet into temp access tables,
then run the update query on the relevant tables in the SQL database

Regards
Lez

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"