Re: Linked Server Connection Problem


Sophie,

Can you list the SQL SP you are using and the ver/date of the drivers
for both ODBC and OLEDB?

Thanks!

Joseph


*** Sent via Developersdex http://www.developersdex.com ***
.

Relevant Pages

  • filter for SQL commad ?
    ... = ?abc? ... example: ODBC found 100 records. ... Joseph ... Prev by Date: ...
    (microsoft.public.sqlserver.clients)
  • Re: SQL Server Access via C#
    ... Are you using a ODBC, OLEDB, SQLClient provider?? ... Prev by Date: ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: OLEDB performance in ADO.NET
    ... > Will i get any performance improvements by using ODBC instead of OLEDB? ... Prev by Date: ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: best provider for connection to SQL ??
    ... OLEDB will give you more functionality than ODBC so that's a ... >"Microsoft ADO OLEDB for SQL". ... Prev by Date: ...
    (microsoft.public.sqlserver.connect)
  • Re: Is ODBC useless, or OK in some circumstances?
    ... Sometimes you have to use ODBC if there is no other choice. ... if you can use a native data provider or at least oledb I personally ... Prev by Date: ...
    (microsoft.public.dotnet.general)