Re: SQL Server 2005 "Left outer join" return nothing through ODBC call


Hi there,

we were facing a similar problem over here. Some outer joins suddenly returned empty resultsets on SqlServer 2005 in 2000-compatibility-mode, but only within our application (under ODBC). The same query executed in Query Analyzer just worked fine (Query Analyzer of course uses OLEDB). We finally solved that issue by upgrading to the latest SqlServer ODBC driver which can be found at: http://www.microsoft.com/downloads/details.aspx?displaylang=de&FamilyID=D09C1D60-A13C-4479-9B91-9E8B9D835CDC

HTH

Kind regards,
Arno Huetter


SQL Server 2005 ODBC driver problem wrote:

> SQL 2005 “LEFT OUTER JOIN” ISSUE
>
>
> In our C++ application, we call ODBC apis to execute following SQL
> statement. It did work for SQL Server 7.0 and SQL server 2000. When we
> upgrade to SQL server 2005( and SQLNCLI.dll), it does not work any more
> without any error report, it just returns empty result.
>
> Note, not error report. The return code is success. Every thing is looked
> perfect, except no content. It should return one row of the result. It works
> perfect, if we just select same record from the first table without using
> "left outer join" and the correct row was returned.

// snip

>
> However, all three style statements are working find on “SQL server 2005
> query analyzer”.
>
>
> Does any body know what the problem is? IT may be the ODBC driver is not
> working perfect with SQL server 2005. We checked that our ODBC connection
> indeed using the new driver "sqlncli.dll". Btw, it is not working with old
> driver either.
>
> Any feedback is appreciated. Thanks for your time.
.

Relevant Pages

  • Re: SQL Losing Data
    ... the other problem wasn't a SQL Server thing. ... And I would argue that it was an ODBC driver issue, solely, not even Access. ... sidebar shows a pencil, indicating that edits are being performed. ... I've tried using Profiler in the past and found it a bit unwieldy. ...
    (microsoft.public.sqlserver.odbc)
  • Re: SQL2005 sys tables
    ... Maybe you don't have the SQL Editor toolbar open. ... You can also change the database context by using the USE statement in the ... SQL Server Documentation Team ... I mean in sql2000 query analyzer I can do the select statement against ...
    (microsoft.public.sqlserver.security)
  • RE: select during transaction**
    ... > in query analyzer I want to update ... beacuse sql server decide on clustered index scan, therefore this statement must wait on releasing locks made by UPDATE ... because sql server chose clustered index seek and it didn't touch/need ... the data locking by UPDATE from first window. ...
    (microsoft.public.sqlserver.programming)
  • Summing tables in a UDF
    ... developed in Sybase into a SQL Server UDF. ... to run call the function in Query Analyzer even though it ... declare rentrev integer; ... What UDF type do I need to recreate this in SQL Server? ...
    (microsoft.public.sqlserver.programming)
  • Re: Using Query Analyzer with SQL 2005
    ... to 2005) was undone for the release of SP4. ... What version of SQL Server 2000 Query Analyzer are you using? ... or will I always need to keep a copy of SQL Server 2000 to install ...
    (microsoft.public.sqlserver.tools)