Connecting 64-bit Pervasive Server to 64-bit SQL Server via 32-bit Per

[skeeziix]

thread318-1536754

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.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(String cmd)
at Microsoft.SqlServer.Management.Smo.LinkedServer.TestConnection()
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.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?Prod...31&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(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)

 

[mirtheil]

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.

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician

http://www.mirtheil.com