Re: Special characters in MSSQL.

Hi,

Creating the linked server with Microsoft OLE DB Provider for ODBC
Drivers solved the problem. Thanks for your help.

Cheers,
Kenneth

.

Relevant Pages

  • OLE DB Provider for ODBC and Oracle
    ... I created a linked server for MS SQL Server 2005 Express to an Oracle ... database using the OLE DB Provider for ODBC. ... I'm using the OLE DB Provider for ODBC instead of the Oracle OLE DB ...
    (comp.databases.ms-sqlserver)
  • Re: Linked server to as400 - for the love of god please help.
    ... > There is an ODBC DSN on the server machine. ... Creating a linked server using ... > OLE DB provider 'MSDASQL' reported an error. ... > So i instead create a linked server using IBM's own OLEDB provider. ...
    (microsoft.public.sqlserver.server)
  • Linked Server Query Fails
    ... I am working with a linked server (using MS OLE DB Provider for ODBC Drivers) ... performing select queries from the ODBC DB and inserting the results into ...
    (microsoft.public.data.oledb)
  • Linked server for ODBC data source
    ... I have an Alpha box running open VMS which has an ODBC client from easysoft ... set up as a system dsn in ODBC data sources. ... How can I set this up as a linked server in SQL 2k? ... "Microsoft OLE DB Provider for ODBC Drivers" with the data source as ...
    (microsoft.public.sqlserver.connect)
  • Re: Linked server to as400 - for the love of god please help.
    ... You are SO tired of IBM. ... >> There is an ODBC DSN on the server machine. ... Creating a linked server ... >> So i instead create a linked server using IBM's own OLEDB provider. ...
    (microsoft.public.sqlserver.server)