Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Jo Vandendriessche
  Where is Jo Vandendriessche?
 Vosselare
 Belgium
 Jo Vandendriessche
 Tags
Subject: ODBC connection destroys Excel2000 file
Thread ID: 34093 Message ID: 34093 # Views: 3 # Ratings: 0
Version: Visual FoxPro 8 Category: ODBC, ADO and OLEDB
Date: Monday, December 08, 2003 10:23:11 PM         
   


I create an ODBC connection to a Excel2000 file that contains the
worksheet 'Leden'.

The sourcecode:

* Create connection
bronbestand = ...
connstr = ;
"DSN=Excel-bestanden;" + ;
"DBQ=" + bronbestand + ";" + ;
"DefaultDir=" + JUSTPATH(bronbestand) + ";" + ;
"DriverId=790;" + ;
"MaxBufferSize=2048;" + ;
"PageTimeout=5;"
"Extended Properties=Excel 2000;"
CREATE CONNECTION MyConn CONNSTRING connstr
* Create view
CREATE SQL VIEW Leden REMOTE CONNECTION MyConn AS SELECT * FROM $leden
DBSETPROP("Leden","VIEW","SendUpdates",.T.)
DBSETPROP("Leden.nr","FIELD","KeyField",.T.) && unique number
DBSETPROP("Leden.nr","FIELD","Updatable",.F.)
*
USE "Leden"


If I change a record in the table 'Leden' (programmatically or through a
browse window), I don't get error messages. But when I close the view and
try to open it again with USE

When I try to open the view again with I get an ODBC error message:
The external table has an unexpected format. (did translate this form dutch!)
When I try to open the Excel file in Excel again, I get an application error!!!:
The instruction on 0x3004c518 .....
THE EXCEL FILE IS CORRUPT!

I run on a XP PC but I have the same problem on a Windows98SE PC.
With an Access database everything works fine.
I have exactly the same problem weh I create the connection and the view
through the database user interface!
I have the same problem in FOXPRO 6 and FOXPRO 8!
IF I SAVE THE EXCEL SHEET AS A EXCEL97 VERSION I DON'T HAVE THE PROBLEM,
EVERTHING WORKS JUST FINE WITH EXACTLY THE SAME CODE! But almost all my
customers use Excel2000.

Can anyone help me.

Thanks

ENTIRE THREAD

ODBC connection destroys Excel2000 file Posted by Jo Vandendriessche @ 12/8/2003 10:23:11 PM
RE: ODBC connection destroys Excel2000 file Posted by Yuri Rubinov @ 12/9/2003 4:04:44 PM
RE: ODBC connection destroys Excel2000 file Posted by Jo Vandendriessche @ 12/10/2003 9:38:07 AM
RE: ODBC connection destroys Excel2000 file Posted by Yuri Rubinov @ 12/10/2003 2:47:52 PM
RE: ODBC connection destroys Excel2000 file Posted by Yuri Rubinov @ 12/10/2003 4:02:59 PM
RE: ODBC connection destroys Excel2000 file Posted by Jo Vandendriessche @ 12/10/2003 10:44:44 PM
RE: ODBC connection destroys Excel2000 file Posted by Yuri Rubinov @ 12/12/2003 2:49:07 PM