Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 OPENROWSET is not working in a 64bit machine

Author  Topic 

sql-programmers
Posting Yak Master

190 Posts

Posted - 2010-07-17 : 01:54:34
OPENROWSET is not working in a 64bit machine. Microsoft.Jet provider is not working when running on 64bit machine. It looks like that driver is not being supported under 64bit OS's. Is there any solution for this issue?

SQL Server Programmers and Consultants
http://www.sql-programmers.com/

slimt_slimt
Aged Yak Warrior

746 Posts

Posted - 2010-07-17 : 02:15:57
try create ETL in SSIS
Go to Top of Page

sql-programmers
Posting Yak Master

190 Posts

Posted - 2010-07-17 : 06:32:25
I am familiar with SSIS. But in my case I need to use OPENROWSET only.

SQL Server Programmers and Consultants
http://www.sql-programmers.com/
Go to Top of Page
   

- Advertisement -