July 4, 2006 at 9:47 am
We are trying to move to the 64-bit version of SQL 2005, but have run smack into the 64-bit wall.
Here's the situation:
Server A is 64-bit 2005 and is linked to server B, which is (32-bit) 2000.
Server B is linked to an ODBC source (ISAM files) using a proprietary 32-bit driver.
Can server A access the data on server C?
The driver vendor does not offer a 64-bit driver and I need to access the ISAM data from server A.
TIA,
dj
July 10, 2006 at 8:36 am
have you tried using the 32bit driver from sql 2005?
mdac is really client so how do you normally get your isam data into 2000 , I assume dts ?
If it's openquery then you should be able to use procs in your 32 bit platform and call the procs remotely from your 64 bit platform.
perhaps you could explain your process more?
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply