|
Hello guys, I'm trying to create a connection on SSIS using provided OLE DB driver (adsoledb_ x86_64 v10.0 to be exact). The driver has worked on SQL Server Management Studio and I've successfully managed to connect to Advantaged Database through Linked Servers (See image #1). However when I jump onto Visual Studio Integration Service I don't seem to be able to find the Advantage OLE DB Provider option (See image #2). Image #1
Image #2
Am I looking at the wrong place? Direction to the right place would be appreciated. |
|
I've not used this or tried to set it up, but when you mention "Visual Studio Integration Service" that make me think something running inside of Visual Studio. I believe that Visual Studio is still 32-bit. (Check if devenv.exe starts in the task manager when you start the Visual Studio Integration Service and see if it has the "*32" next to it). If it is 32-bit, then you need to also install the 32-bit OLE DB Provider. If not, maybe you can comment or edit the question on how to get to that screen. Edgar Thank you Edgar, yes indeed Visual Studio is 32 bit and I've solved the issue by finding a 32 bit version of the OLE DB driver. Thank you. EJK
(17 Jul '14, 14:23)
ejk64
|
