Re: VFPOLEDB: works with DB on my machine but not with network server
- From: "Cindy Winegarden" <CindyWinegarden@xxxxxxxxxxxxxxxx>
- Date: Thu, 6 Apr 2006 18:00:41 -0400
Hi Jim,
As suggested elsewhere (by Dan Freeman I think) OLE DB can't handle any kind
of activity outside of data selection. That would include presenting a debug
message to a user and IO to a debug text file.
You can read about all the commands and functions that are supported by OLE
DB, and also the commands and functions that are supported in stored
procedures that are fired by OLE DB in the VFP Help topic "Supported Visual
FoxPro Commands and Functions in OLE DB Provider ", online at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_foxhelp/html/dglrfsupportedvisualfoxprolanguagefunctions.asp.
--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@xxxxxxx www.cindywinegarden.com
"Jim Walsh" <JimWalsh@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:54F4231C-9912-48A3-8840-031A3AC6D335@xxxxxxxxxxxxxxxx
I finally got this to work.
When I compared the copy of the database on the server, that was not
working, with the version that was on my development computer, I noticed
that
the version that was not working had stored procedures for handling two
events: BeforeTableOpen, and AfterTableOpen. I put this code in a long
time
ago for debugging purposes. All it does it output a debug string. However,
when I commented out these two procedures, the database on the server now
works.
Any idea why this was causing a problem?
.
- References:
- Prev by Date: Re: Error with ole db for visual foxpro
- Next by Date: Re: Accessing Excel data - Some columns are not coming through
- Previous by thread: RE: VFPOLEDB: works with DB on my machine but not with network server
- Next by thread: Re: OleDbDataAdapter
- Index(es):
Relevant Pages
|
Loading
