Re: ODBC: Call Failed 3146

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Thank you very much, the problem is solved. Did not know about the
tracer, but when i used it, it gave me just the info i needed. It
seemed i had a wrong unique index ;)

Fixed it and now everything runs smoothly !



Sue Hoegemeier wrote:
ODBC call failed can be anything so it's not real fun to
troubleshoot. I think the easiest way though is to turn on
ODBC tracing on the client until you get the error. Having
ODBC tracing on will bog down the client so you want to try
to get the error soon and turn tracing off after that. Once
you hit the error, you can go through the ODBC trace log to
find the specific call that had the error.
You turn on ODBC tracing from the ODBC Data Source
Administrator. Go to the tracing tab and click on Start
Tracing now. Note where the log is going to - you can change
the location if you want. You turn off the tracing from the
same place. Just make sure you turn it back off.

-Sue

On 24 Sep 2006 02:54:21 -0700, "Johan"
<hello_2you@xxxxxxxxxxx> wrote:

Hello,

I have a vb program that connects to odbc to an sqlexpress server. When
i try to write data to the db, i get this message:

Release Error: Script #1 (Ascent Capture Database) [3146 Index Table
(dbo.DIGIDOS): ODBC: de oproep is mislukt.]

"de oproep is mislukt" is dutch for "Call failed"

It is an on/off problem, sometimes it works perfectly, but when i try
for the second time i get the error message again. Also found a
suggestion on the internet to walk through the errors of the
dbengine.error but this gave me nothing more then the shown error.

I am using windows xp and a local SQLexpress 2005 server. I am using
the sql server odbc driver 2000.85.1117.00 or should i been using the
sql native client version 2005.90.1399.00 ?

Can someone explain to me what i must do to correct this problem. ?

Thnx,

Johan
The Netherlands

.

Relevant Pages

  • RE: Remoting - Some methods hang on certain setups.
    ... "[ODBC SqlBase driver] You are not licensed to use this Merant Driver under ... The weird part is when we run both client & server at the same location, ... The ODBC-Driver is used to query the AccountancyDb through a provided API ...
    (microsoft.public.dotnet.languages.vb)
  • RE: Error 10054: [DBNETLIB]ConnectionRead/ConnectionWrite
    ... it will be hard to match it up with a network trace. ... > I'm checking on some additional tracing tools for you. ... I managed to get the ODBC traces and yes it is very very verbose ... > Is there any hardware between the client machine and the server? ...
    (microsoft.public.sqlserver.connect)
  • Re: error setting up ODBC for remote sqlexpress database
    ... We were able to get it to work with the ODBC native client driver. ... Server could be stopped in the client. ... is to install Management Studio for SQL Server 2005 Express ...
    (microsoft.public.sqlserver.odbc)
  • Re: xampp odb Zugriff
    ... auf meinem Client installiert und wollte dann eine Benutzer-DNS ... Datenbank: mysql ... Rechner aus zu dem angegebenen Server per mysql (das ... Bevor ODBC funktionieren ...
    (de.comp.datenbanken.mysql)
  • ODBC wire encryption
    ... Is there a method to enable an ODBC client to encrypt all communications ... an ODBC driver to DBMS server unencrypted. ...
    (microsoft.public.sqlserver.odbc)