Re: update query ODBC--call failed

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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


"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"


.

Relevant Pages

  • Re: Any help here???
    ... Well, for starters, I believe MDAC is unnecessary for .NET applications - as ... ADO.NET has its own SQL Server provider for data access. ... > trust me - all that's been done here was to install SP2 or upgrade of XP ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Any help here???
    ... > Well, for starters, I believe MDAC is unnecessary for .NET applications - as ... > ADO.NET has its own SQL Server provider for data access. ... > could think of off hand for installing MDAC is for any old COM applications ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Upgrade MDAC to version 2.8 vs MS03-033 Patch
    ... You should not update MDAC in any way other then using the SQL ... with this but the place to get the definitive answer is the SQL Server ... > I was set to apply the MS03-33 patch to all of the Windows 2000 Server ...
    (microsoft.public.security)
  • RE: Reinstall
    ... I guess one the the updates had back leveled MDAC. ... > practice to install the most recent MDAC before doing any ... > SQL Server maintenance. ... >>I'm trying to reinstall SQL Server without much sucess. ...
    (microsoft.public.sqlserver.server)
  • String or binary data would be truncated, but fields are big enough
    ... One of our software customers is getting an error from the SQL Server ... ODBC Driver that says: "String or binary data would be truncated." ...
    (microsoft.public.sqlserver.programming)