Solved

ODCB Datasource no driver for csv, excel, access

Posted on 2010-09-13
8
996 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
Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

 
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

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

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

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This tutorial will give a an overview on how to deploy remote agents in Backup Exec 2012 to new servers. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as connecting to a remote Back…
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…

752 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