addressalign-toparrow-leftarrow-rightbackbellblockcalendarcameraccwcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-checkcircle-with-crosscircle-with-pluscontroller-playcrossdots-three-verticaleditemptyheartexporteye-with-lineeyefacebookfolderfullheartglobegmailgooglegroupshelp-with-circleimageimagesinstagramFill 1light-bulblinklocation-pinm-swarmSearchmailmessagesminusmoremuplabelShape 3 + Rectangle 1ShapeoutlookpersonJoin Group on CardStartprice-ribbonprintShapeShapeShapeShapeImported LayersImported LayersImported Layersshieldstartickettrashtriangle-downtriangle-uptwitteruserwarningyahoo

The Online ColdFusion Meetup Message Board › CF9 excel odbc drives

CF9 excel odbc drives

Joe
user 7520549
Bethlehem, PA
Post #: 38
Hello,
I am migrating our servers from CF8 to CF9. I actually have a new Windows 2008 64 bit server on which I install CF902. The server this is replacing has 3 Excel DBs, I copied the Excel files to the new server, created system DSN which uses "Driver do Microsoft Excel(*.xls) with C:\Windows\SysWOW64\odbcad32.exe. I go into CF admin and create a new data source, give a name which is same as the system DSN, The dropdown select box next to ODBC DSN is empty, nothing, like CF does not recognize the newly created system DSN I created. I rebooted the server to no avail.

Any ideas on getting this working or work arounds appreciated.

Joe
Joe
user 7520549
Bethlehem, PA
Post #: 39
Well, this does not answer my question but we are ditching the xls data sources. That is one way to resolve an issue :)

Joe
Mike C.
user 11731352
Alpharetta, GA
Post #: 1
I needed to do this awhile back. My solution was to keep a 32bit server running to talk odbc. I then called into that server from my 64bit CF server. You need to consider your licensing with this solution.

A few other ideas:
- use cfspreadsheet
- MySQL did have a access migration kit


Powered by mvnForum

Our Sponsors

People in this
Meetup are also in:

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy