Linked server to as400 - for the love of god please help. ... i'm trying to setup a linked server between SQL Server and an AS400/DB2/IBM ...OLE DB provider 'MSDASQL' reported an error. ... OLE DB error trace [OLE/DB Provider 'IBMDA400' IColumnsInfo::MapColumnIDs ... (microsoft.public.sqlserver.server)
Re: Linked server from SQL Server to Access db on network share? ... What it looks like is this: SQL can create a linked server to a file on a remote share, but you can't query against it using Query Analyzer from any system other than the one hosting SQL... ...EXEC sp_tables_ex 'OLDSQL' ...OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. ... (microsoft.public.sqlserver.msde)
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)
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)
