Cache to SQL Server Linked Server

[allen black]

This seems to be an old issue, but has can anyone help with SQL Server 2012 Linked Server problems? I'm attempting to script a linked server via the ODBC driver like so.

EXEC master.dbo.sp_addlinkedserver 

@server = N'LIVE_PM', 

@srvproduct=N'MSDASQL.1', 

@provider=N'MSDASQL.1', 

@datasrc=N'LIVE_PM', 

@provstr=N'

DRIVER={InterSystems ODBC35};

Server=CacheServer;

Port=1972'

Execute master.dbo.sp_addlinkedsrvlogin 

        @rmtsrvname = N'LIVE_PM' 

        ,@useself = N'False' 

        ,@locallogin = Null 

        ,@rmtuser = N'LIVE:3792'       

        ,@rmtpassword='######' 

I'm getting the error message below about architecture mismatch, which seems to have happened with a lot of posters in the past. I can't seem to find a good solution. Any ideas?

Cannot initialize the data source object of OLE DB provider "MSDASQL.1" for linked server "LIVE_PM".

OLE DB provider "MSDASQL.1" for linked server "LIVE_PM" returned message "[Microsoft][ODBC Driver Manager] 

The specified DSN contains an architecture mismatch between the Driver and Application". (Microsoft SQL Server, Error: 7303)

[Brendan Bannon]

Based just on the very last line

 

The specified DSN contains an architecture mismatch between the Driver and Application"

 

Is your SQL Server 2012 a 32 bit or 64 bit install?  Whatever that is you need to install that version of the Cache ODBC client.

 

The bitness of the ODBC client needs to match the client application not the database it is connecting to.

 

Brendan

--
--
Caché, Ensemble, DeepSee

---
You received this message because you are subscribed to the Google Groups "Caché, Ensemble, DeepSee" group.
To unsubscribe from this group and stop receiving emails from it, send an email to intersystems-publi...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Basavaprabhayya Hiremath]

Hi,

Can you please provide some documents on cache learning??? to basava...@gmail.com..

I'm interested to learn this...It will be helpful...

Thanks in advance..:)

[John Murray]

http://docs.intersystems.com/