Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



64 bit driver of DSN for Microsoft access database

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 30-11-2010
Member
 
Join Date: Nov 2010
Posts: 101
64 bit driver of DSN for Microsoft access database
  

I contain windows 7 professional 64 bit version on my laptop. I attempted locating DSN that is data source name intended for Microsoft access data. It is giving me an alternative for just SQL server database. Defining connectivity to Microsoft access database all the way through DSN is extremely significant to my ASP applications functioning through IIS that is internet information services. Later than reviewing the resolutions on the web I completed at present there is no 64 bit driver. Should I demote my windows 7 professional to 32 version. Please suggest something??.

Reply With Quote
  #2  
Old 30-11-2010
Member
 
Join Date: Nov 2008
Posts: 1,185
Re: 64 bit driver of DSN for Microsoft access database

At present Microsoft does not contain any 64 bit ODBC that is Open Database Connectivity drivers on hand for the Office products. On the other hand, as long as the application which you wish to connect to is 32 bit, you can utilize the 32 bit ODBC drivers to generate the DSN. To acquire to the 32 bit ODBC drivers, the 32 bit Data Source administrator has to be utilized. The 32 bit Data Source administrator has to be launched unswervingly if you are by means of a 64 bit operating system. The file should be located at the following path: ?c:\windows\system32\odbcad32.exe?.
Reply With Quote
  #3  
Old 30-11-2010
Member
 
Join Date: Nov 2008
Posts: 1,221
Re: 64 bit driver of DSN for Microsoft access database

You can easily download these drivers from Microsoft?s website or any other websites too. But my suggestion is here to download from Microsoft. This file will put in Access to the list of file types in the ODBC administrator. I am completely not certain if its 32 bit or 64 bit. But it worked on a machine running 64bit Win 7. So first download the drivers from Microsoft and try this. Let me know this is working for you or not?
Reply With Quote
  #4  
Old 30-11-2010
Member
 
Join Date: Nov 2008
Posts: 1,022
Re: 64 bit driver of DSN for Microsoft access database

I am utilizing the fresh 64bit Office 2010 drivers with supplier name Microsoft.ACE.OLEDB.12.0. It all works fine for a while just reading comma-separated values (CSV) files and excel sheets and so on okay but afterward throws a "The provider reported an surprising catastrophic failure". My surroundings is 64 bit Windows 7 running VMWare Workstation, with a 64-bit Windows 7 guest running SQL Server 2008 64 Bit. Essentially I'm running the following which works infrequently receiving the failure over.
Code:
 Select top 50 FROM OPENROWSET ('Microsoft.ACE.OLEDB.12.0','Text; Database=c: \temp\captell;HDR=Yes, 'SELECT * FROM [DIGDAS132101091135.TXT]')
I have as well attempted these on Windows server 2003 64 bits with SQL Server 2008 64 bit and obtain the similar error. Has anybody as well had this trouble?
Reply With Quote
  #5  
Old 30-11-2010
Member
 
Join Date: May 2008
Posts: 860
Re: 64 bit driver of DSN for Microsoft access database

I have just attempted your suggestion over and added a System DSN for MS Access. On the other hand it does not come into view to be obtainable to me. I have experienced by means of a UDL file, but just my System DNS for MS SQL which shaped in 64 bit mode comes into sight beneath the list of obtainable System DSN's. I am utilizing Windows 2008 64bit R2.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "64 bit driver of DSN for Microsoft access database"
Thread Thread Starter Forum Replies Last Post
How to defend Microsoft Access 2007 database from copying yummy- Windows Software 5 30-11-2010 11:22 PM
Microsoft Access 2010: crashes when importing a database file Gavinovo Windows Software 3 29-11-2010 10:43 PM
Microsoft Access to prevent database corruption Xylina Windows Software 5 27-03-2010 12:33 AM
Recover a database in Microsoft Access Balamani Windows Software 3 11-11-2009 06:56 PM
Error Message " Microsoft Access was unable to create an MDE Database" Clemens Windows Software 5 18-04-2009 12:42 AM


All times are GMT +5.5. The time now is 12:49 AM.