ODBC connection problem: 64bit Excel bad but 32bit ok help!

[9tanstaafl9]

My report runs great for everyone except person running 64 bit Excel 2010 on Server 2008. (Can't connect to visual foxpro 32 bit odbc driver using VFPODBC 32 bit)

Pops up the ODBC SCREEN asking for the data source.

Here is the connection string from one of the queries, they are all pretty much the same:

DSN=Visual FoxPro Tables;UID=;;SourceDB=M:\MB7\De-Cal;SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;Null=Yes;Deleted=Yes;

Here is the command text: (I doubt it matters, but then again this is not my area.)

SELECT prmchg.phsnum, sbcgln.cstcde, sbcgln.csttyp, Sum(sbcgln.bdgprc) AS 'Sum of bdgprc'
FROM prmchg prmchg, sbcgln sbcgln
WHERE prmchg.recnum = sbcgln.recnum AND ((prmchg.status=$1)) AND (prmchg.jobnum=?) AND (prmchg.actper<=?) AND (sbcgln.chgsts=$1)
GROUP BY prmchg.phsnum, sbcgln.cstcde, sbcgln.csttyp

Any suggesitons? Anything, even something really obvious. Keep in mind that I have no experience in ODBC so something super obvious I might not know.

Thank you in advance!

Jennifer

 

[Firefly2012]

Any suggesitons? Anything, even something really obvious....

Smack user across head until they agree to use 32bit Excel?

Seriously, sounds like a driver problem to me (ie non-Excel related) and if there is no talk between 64bit Excel and the 32bit driver then unless you can lay your hands on a 64bit driver version then it ain't gonna work.

Unless someone else has a clever suggestion.

 

[9tanstaafl9]

To the best of my knowledge, there is no 64 bit version of a VisualFoxPro driver, and that is the only thing that works with the program I need to connect to.

And smacking the person isn't an option, it's my husband's client.

 

[9tanstaafl9]

Seriously, sounds like a driver problem to me (ie non-Excel related) and if there is no talk between 64bit Excel and the 32bit driver then unless you can lay your hands on a 64bit driver version then it ain't gonna work.

Do you know if it would work if I mapped it directly to a named 32bit file DSN, or would that still be an issue?

 

[Firefly2012]

You can but try - I suspect nothing you do will get it to work, however.

I understand that Microsoft itself advises users to stick with 32bit Excel unless they have a pressing need to use the 64bit version (eg because they have truly mahoosive spreadsheets).