Solved

ODCB Datasource no driver for csv, excel, access

Posted on 2010-09-13
8
997 Views
Last Modified: 2012-06-27
We've got a Terminal Server (Windows Server 2008 R2 64 bit )
For Database imports we need to have some ODBC Drivers for txt, csv, excel and access.
Unfortunately I can't find any ohter drivers then the SQL Server drivers.
From where can I get the other drivers and how can I install them?

0
Comment
Question by:Opusretis
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
  • 2
8 Comments
 
LVL 5

Expert Comment

by:ewkelly
ID: 33661509
Usually you go to the control panel and choose ODBC and then choose add. You should get a list of drivers to add.
0
 
LVL 5

Accepted Solution

by:
ewkelly earned 500 total points
ID: 33661541
Here is more information which includes a link to purchase more drivers.
http://support.microsoft.com/kb/110093 
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 33668910
Unfortunately there are none available for you.
0
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 33668918
There are 1001 workarounds using 32-bit drivers, but there are no 64-bit JET drivers.
0
 

Author Comment

by:Opusretis
ID: 33707017
Is there realy no text driver for 64bit?
I understand the problem with office apps but csv or text should be supported
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 33712172
What exactly are you doing?  Have you considered using SSIS or BCP?
0
 

Author Comment

by:Opusretis
ID: 33714060
not of all.

It is a third party software with the functionality to import data into the tables.
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 33718300
Then I am afraid I have no idea.  Your best bet would be to contact them for a solution.
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

628 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question