Author: Jeff Johnson
Posted: 2014-04-08 at 11:36:48
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:profoxtech-bounces@leafe.com] On Behalf Of Jeff Johnson
> Sent: Tuesday, April 08, 2014 11:04 AM
> To: profoxtech@leafe.com
> 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
jeff@san-dc.com
SanDC, Inc.
623-582-0323
Fax 623-869-0675
_______________________________________________
Post Messages to: ProFox@leafe.com
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/534425A0.6060705@san-dc.com
** 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.