Skip to main content

UPDATED: How do i map access database on windows 2008 r2 64bit?

I am having a really hard time today in searching for a solution for mapping the access database file on windows server 2008 r2 64bit.

The issue at hand is that I cannot find the Microsoft Jet Engine drivers for the windows server 2008. I am not sure as to why there are no drivers easily available not just for odbc of access but for excel as well.

After I installed sql server I got the sql server drivers and I hoped that after installing the Microsoft office 2007 trial edition on the server, it will install the odbc drivers for both access and excel, but it does not seems to be the case.

now the dilemma is on how to find these drivers, how do I get the same kind of sys 32 drivers work on a sys 64 bit system and map the old access mdb files so that I can make the coldfusion application work.

UPDATE:
Ok, i found a solution online as to what I was missing the knowledge of
http://forums.adobe.com/thread/230023

Solution posted by kbjohnson:
Run the following file for 32bit ODBC mapping:
C:\Windows\SysWow64\odbcad32.exe

Comments

Popular posts from this blog

Completed UiPath - RPA Developer Advance Training

After a month of training, with late nights and weekends I have completed the UiPath RPA Developer Advance Training.

The Level 1 Foundation Training pretty much covered all the basics of Desktop studio and workflows, only draw back was I started with the default foundation course which was for 2016, and all document reference links where pointing to 2016 version. I didn't understand it during the foundation training and kept switching to 2018 version document/page.

Only after completing the Foundation course that I realized, I was suppose to have started with the 2018 version of Level 1 Foundation Training, but as it was optional I didn't have to retake the 2018 version, the 2016 was good enough for moving to level 2.

The Level 2 Orchestrator 2018.3 Training as good. It gave good understanding of Queue's, Jobs, and schedules and I was able to complete the level two much faster then the level 1.

The Level 3 UiPath Advanced Training was bit tough as it involved the assignme…

KB 294807 - IIS Server - PHP FastCGI 500 Error 0xfffffffe

Resolved issue today of IIS Server - PHP FastCGI 500 Error 0xfffffffe by deleting "Windows Temp" folder files.

We used Cygwin to customize some permissions of "Windows Temp" folder and after few hours the website stopped working.

The search online was giving all kinds of different solution except what I was looking for.

I was hoping the stackoverflow will have answers but even this post didn't cover the issue I was running into.
https://stackoverflow.com/questions/15302080/fastcgi-500-failure

Restarting the IIS didn't work, but deleting temp files cleared the issue, but now the problem is how long before the site will go down again?

Hope the issue is resolved for ever, if not; I will update this post later.

Grow with Google Scholarship / Udacity

Grow with Google Scholarship / Udacity

Today on Jan 11, 2018, I have received the Grow with Google Scholarship.

I am really excited because, previously I had joined Udacity to complete a Nano Degree, but due to price and family priorities, I had to abandon that goal.

Today, I feel like I am getting a second chance to give it another shot to completing my Nano Degree.