On 4/8/2014 8:20 AM, Richard Kaye wrote:
If you type ODBC into the W8 search box you should get two matches; One for the
64 bit and one for the 32 bit. You will probably have to hunt down the ODBC
drivers if they are not appearing in the 32 bit ODBC Manager. I would expect to
find them on the O2003 installation media.
--
rk
-----Original Message-----
From: ProfoxTech [mailto:[email protected]] On Behalf Of Jeff Johnson
Sent: Tuesday, April 08, 2014 11:04 AM
To: [email protected]
Subject: Re: [NF] Excel 2003 on Windows 8
Allen: I saw that but did not understand what I am to do.
"To locate the 32-bit Office System drivers, use the appropriate version of the ODBC
Administrator tool. If you build and then run an application as a 32-bit application on a 64-bit
operating system, you must create the ODBC data source by using the ODBC Administrator tool in
%windir%\SysWOW64\odbcad32.exe. For example, the default location on a Windows 7 64-bit machine is
"C:\Windows\SysWOW64\odbcad32.exe"."
I have no idea what this means. I am a lunkhead.
Okay, I found VFP ODBC drivers and installed them. Now it works with
the below connection string with one slight problem
lnsqlhandle = SQLSTRINGCONNECT([Provider=Microsoft.ACE.OLEDB.12.0;
Data Source="Excel.dsn"; DBQ=] + lcspreadsheet + [; Extended
Properties="Excel 8.0; HDR=YES";])
The Data Source must be incorrect because a window pops up and says
select data source. I select Excel.dsn and it works.
<rant>I can't believe the amount of time spent getting things to work on
Windows 8 that worked fine on Windows 7! ODBC, Remote Desktop, simple
network connections. Sheesh!</rant>
--
Jeff
Jeff Johnson
[email protected]
SanDC, Inc.
623-582-0323
Fax 623-869-0675
http://www.san-dc.com
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
