Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1462
  • Last Modified:

OPENROWSET in 64-bit SQL 2005 installation

I'm trying the following command in a 64-bit installation of SQL Server 2005:


select * from
 OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Text;Database=C:\csv\;HDR=Yes;FMT=Delimited', Names#csv) i

but I get:

Msg 7403, Level 16, State 1, Line 2
The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered.

What can I do?
0
PeterErhard
Asked:
PeterErhard
  • 2
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
I read here:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=494063&SiteID=1
<...>
The is no way to use Jet driver from a 64-bit SQL Server unfortunately.  
They did not port the driver to 64-bit.  
So this would only work from a 32-bit SQL Server.
Matt Neerincx [MSFT]
<...>
0
 
PeterErhardAuthor Commented:
What other options do I have for referencing a CSV file from a 64-bit installation?
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
My initial try would be to setup a (mini-) sql 2000 32 bit on that machine, that could server as intermediate step for such an operation...
alternatively, the BULK INSERT with a format file might be helpful, if the file is truly csv.
otherwise, only code (for example vbscript) could do the job...
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now