Re: sql server + ODBC: error suppressed

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


"vadim" <vadim@dontsend> wrote in message news:ej7Yf3Z2JHA.4880@xxxxxxxxxxxxxxxxxxxxxxx
Hi,

I have a program that connects to SQL Server through ODBC, one of my clients
reports that when the program is trying to insert a record with the values
that violate a unique index, the record is not inserted (which is OK), but
no error message is displayed either (which is strange and it works fine on
other systems).
I am trying to investigate this.
My question is: are there any configuration parameters on sql server or ODBC
that would suppress error messages ?
Or which other direction should I investigate?

Thank you

Hi

I would check versions of MDAC, Service Packs etc. You could turn ODBC logging on, but I doubt that it will tell you anything new. Similarly SQL Profiler will show the error has actually been generated. My assumption that you handle errors with additional information and have stepped through the client code to make sure it is not doing something you don't expect and the application executable is not a different version.

If you use a machine (laptop) you know works on another system when connected to this server do you still have the issue?

John

.

Relevant Pages

  • Re: How to have SQL_ERROR returned from RAISERROR within IF-BLOCK
    ... The problem has been fixed in SQL Server 2005. ... even modify the sequence of ODBC function calls and checking of the return ... I want to return SQL_ERROR to my application with a custom error message ... I get it returned fine when I execute the following statement using ...
    (microsoft.public.data.odbc)
  • 3rd Party App connecting to SQL Server over VPN
    ... little laggy, the sites are able to communicate fully from clients to ... that accesses a SQL Server at the home office. ... If you OK the error message and retry the ...
    (microsoft.public.sqlserver.connect)
  • 3rd Party App connecting to SQL Server over VPN
    ... little laggy, the sites are able to communicate fully from clients to ... that accesses a SQL Server at the home office. ... If you OK the error message and retry the ...
    (microsoft.public.sqlserver.connect)
  • Linked server to ODBC dsn.....
    ... Using my favorite ODBC sql query tool, i can select the System DSN, specify ... i go into SQL Server, and want to create a linked server to this same ODBC ... the error message really shouldn't matter. ...
    (microsoft.public.sqlserver.server)
  • UPDATE query gives Incorrect Syntax error
    ... I'm running SQL Server 2005 Express Edition. ... LastUpdated, allows nulls) ... My VB application connects via ODBC no problems. ... error message. ...
    (comp.databases.ms-sqlserver)