SQL/ODBC
Mirtheil Software Forums»SQL/ODBC

Topic: 64bit SQL Linked Server via 32bit ODBC

Author Message Prev Topic | Next Topic  skeeziix Newbie Joined: 12 May 2010 United States Posts: 1 Posted: 12 May 2010 at 2:01pm | IP Logged I am trying to utilize a 32-bit ODBC Client Interface Driver to connect a 64-bit Pervasive SQL Server to a 64-bit MS SQL Server on Windows Server 2008 R2. I can test the connection via the C:\Windows\SysWOW64\odbcad32.exe Data Source Administrator but when I go into SQL Management Studio it will not accept the Linked Server due to the 32-bit vs 64-bit conflicts (i am assuming)... The client doesn't have a 64-bit ODBC driver as of yet also - is there some kind of simple work around to get this working???     =================================== The test connection to the linked server failed. =================================== An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ Program Location:    at Microsoft.SqlServer.Management.Common.ServerConnection.Exe cuteNonQuery(String sqlCommand, ExecutionTypes executionType)    at Microsoft.SqlServer.Management.Smo.ExecutionManager.Execut eNonQuery(String cmd)    at Microsoft.SqlServer.Management.Smo.LinkedServer.TestConnec tion()    at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExpl orer.LinkedServerConnectionTest.Invoke() =================================== Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "REIAGRIS". OLE DB provider "MSDASQL" for linked server "REIAGRIS" returned message "[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application". (.Net SqlClient Data Provider) ------------------------------ For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.00.2531&EvtSrc=MSSQLServer&EvtID=7303&LinkId=20476 ------------------------------ Server Name: reistageone\stageone Error Number: 7303 Severity: 16 State: 1 Procedure: sp_testlinkedserver Line Number: 1 ------------------------------ Program Location:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)    at System.Data.SqlClient.SqlInternalConnection.OnError(SqlExc eption exception, Boolean breakConnection)    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(T dsParserStateObject stateObj)    at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)    at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(Strin g methodName, Boolean async)    at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(D bAsyncResult result, String methodName, Boolean sendToPipe)    at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()    at Microsoft.SqlServer.Management.Common.ServerConnection.Exe cuteNonQuery(String sqlCommand, ExecutionTypes executionType) Back to Top    mirtheil Admin Group Joined: 09 February 2006 United States Posts: 209 Posted: 12 May 2010 at 2:15pm | IP Logged Unfortunately, there is no simple workaround.  The PSQL ODBC drivers are 32 bit only.  If SQL Server 64 bit cannot access the 32 bit driver, then you are limited in your options.  PSQL v11, currently in beta, is scheduled to have 64 bit ODBC drivers.  You might take a look at that but remember, it is a beta and you shouldn't use it in production.  Back to Top

If you wish to post a reply to this topic you must first login
If you are not already registered you must first register

Printable version You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum Powered by Web Wiz Forums version 7.9 Copyright ©2001-2004 Web Wiz Guide