|
Next: Record locking in Access and SQL Server
|
| Author |
Message |
External
Since: Aug 25, 2003
Posts: 3
|
(Msg. 1) Posted: Mon Jan 12, 2004 1:16 am
Post subject: Visual FoxPro Versions.
Archived from groups: microsoft>public>vb>database>odbc (more info?)
|
|
|
Hi all
I have a system that reads a VF FoxPro Database version 6. It runs using an
MDAC 2.5 of the VFProDriver VFPODBC.DLL V6.1.8629.1
I have just heard that the system creating the databases is being converted
to VFoxPro v 7. I would be grateful for some advice as to which version of
the ODBC drivers I should aim at these databases.
Roger Stenson |
|
| Back to top |
|
 | |
External
Since: Nov 30, 2003
Posts: 96
|
(Msg. 2) Posted: Mon Jan 12, 2004 1:16 am
Post subject: Re: Visual FoxPro Versions. [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
"Roger Stenson" <r.stenson DeleteThis @ntlworld.com> wrote in message <news:O6FVPCJ2DHA.2528@TK2MSFTNGP10.phx.gbl>...
> I have a system that reads a VF FoxPro Database version 6. It runs using an
> MDAC 2.5 of the VFProDriver VFPODBC.DLL V6.1.8629.1
>
> I have just heard that the system creating the databases is being converted
> to VFoxPro v 7. I would be grateful for some advice as to which version of
> the ODBC drivers I should aim at these databases.
Hopefully VFP7 includes updated redistributable ODBC drivers!
Otherwise, you'll have to switch over to the "native" OLEDB
driver for MDAC 2.6 or later:
URL:http://microsoft.com/downloads/details.aspx?familyid=0f43eb58-7a94-4ae1-a59e-965869cb3bc9
Where do you want to be goaded today?
--
Joe Foster <mailto:jlfoster%40znet.com> DC8s in Spaace: <http://www.xenu.net/>
WARNING: I cannot be held responsible for the above They're coming to
because my cats have apparently learned to type. take me away, ha ha!<!-- ~MESSAGE_AFTER~ --> |
|
| Back to top |
|
| |
External
Since: Oct 02, 2003
Posts: 32
|
(Msg. 3) Posted: Wed Jan 14, 2004 2:13 pm
Post subject: Re: Visual FoxPro Versions. [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
In news: O6FVPCJ2DHA.2528.RemoveThis@TK2MSFTNGP10.phx.gbl,
Roger Stenson <r.stenson.RemoveThis@ntlworld.com> wrote:
> I have a system that reads a VF FoxPro Database version 6. It runs
> using an MDAC 2.5 of the VFProDriver VFPODBC.DLL V6.1.8629.1
>
> I have just heard that the system creating the databases is being
> converted to VFoxPro v 7. I would be grateful for some advice as to
> which version of the ODBC drivers I should aim at these databases.
Hi Roger,
Visual FoxPro 7 and 8 have new database features that render the tables
unreadable via ODBC. They can, however, be read via OLE DB. The latest VFP
OLE DB data provider is downloadable from a link on
<a style='text-decoration: underline;' href="http://msdn.microsoft.com/vfoxpro/downloads/updates/default.aspx" target="_blank">http://msdn.microsoft.com/vfoxpro/downloads/updates/default.aspx</a> .
Even though the tables are created in VFP7 or VFP8, if none of the new
database features have been used then the tables are still accessible via
ODBC. The driver you have is the latest ODBC driver.
--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy.winegarden.RemoveThis@mvps.org <a style='text-decoration: underline;' href="http://www.cindywinegarden.com" target="_blank">www.cindywinegarden.com</a><!-- ~MESSAGE_AFTER~ --> >> Stay informed about: Visual FoxPro Versions. |
|
| Back to top |
|
| |
External
Since: Oct 02, 2003
Posts: 32
|
(Msg. 4) Posted: Wed Jan 14, 2004 2:13 pm
Post subject: Re: Visual FoxPro Versions. [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
In news: Ow2HpbK2DHA.3656.RemoveThis@TK2MSFTNGP11.phx.gbl,
Joe "Nuke Me Xemu" Foster <joe.RemoveThis@bftsi0.UUCP> wrote:
> Hopefully VFP7 includes updated redistributable ODBC drivers!
As in my other post, the latest and last ODBC drivers are version
6.1.8629.1, which Roger has. There will be no further updates to these
drivers. Microsoft is moving away from ODBC as a data access method.
--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy.winegarden.RemoveThis@mvps.org <a style='text-decoration: underline;' href="http://www.cindywinegarden.com" target="_blank">www.cindywinegarden.com</a><!-- ~MESSAGE_AFTER~ --> >> Stay informed about: Visual FoxPro Versions. |
|
| Back to top |
|
| |
External
Since: Jan 14, 2004
Posts: 7
|
(Msg. 5) Posted: Wed Jan 14, 2004 2:26 pm
Post subject: Re: Re: Visual FoxPro Versions. [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
|
|
| Back to top |
|
| |
External
Since: Jan 14, 2004
Posts: 7
|
(Msg. 6) Posted: Wed Jan 14, 2004 2:56 pm
Post subject: Re: Re: Visual FoxPro Versions. [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
>As in my other post, the latest and last ODBC drivers are version
>6.1.8629.1, which Roger has. There will be no further updates to these
>drivers. Microsoft is moving away from ODBC as a data access method.
In other words, database connectivity will no longer be "open." Does this
mean that Java will no longer be able to access MS databases? It does
doesn't it? Not that that access was ever good enough that anyone would
want to build a commercial level application using it.
And if it were so that there might be a bug in odbc access, like the "query-based
update failed" issue, well, that bug will not be fixed.
Buy the new development tools folks. No thanks. Fooled me once, your fault.
There is at least one commercial replacement for ODBC available. Expensive, but
less so than the latest from .net, by far.
The one suggestion made a few years ago to the "query-based" problem that I was
not able to try was to make what I need a FoxPro "stored procedure." Which means
that the procedure is stored in the database. Can anyone suggest a place on the
www with a good discussion of FoxPro stored procedures, and a few examples?
Can they be done as a named sql query?
Gleason<!-- ~MESSAGE_AFTER~ --> >> Stay informed about: Visual FoxPro Versions. |
|
| Back to top |
|
| |
External
Since: Oct 02, 2003
Posts: 32
|
(Msg. 7) Posted: Thu Jan 15, 2004 1:52 am
Post subject: Re: Re: Visual FoxPro Versions. [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
In news: 9s5b001i7241fgnb0897d0v81m92365uev RemoveThis @4ax.com,
Noah Sombrero <sombrero RemoveThis @mm.st> wrote:
> With all your qualifications, you must have come across my
> "query-based update failed" problem. I would love to hear what you
> have to say about it.
Hi Noah,
I hadn't seen it before you drew my attention to it. It didn't trigger any
of my OE rules that highlight certian messages. Since you see the problem
with many different back-end databases then I doubt the problem is in the
database. Which ODBC driver were you using?
--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy.winegarden RemoveThis @mvps.org <a style='text-decoration: underline;' href="http://www.cindywinegarden.com" target="_blank">www.cindywinegarden.com</a><!-- ~MESSAGE_AFTER~ --> >> Stay informed about: Visual FoxPro Versions. |
|
| Back to top |
|
| |
External
Since: Jan 14, 2004
Posts: 7
|
(Msg. 8) Posted: Thu Jan 15, 2004 1:52 am
Post subject: Re: Re: Re: Visual FoxPro Versions. [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
While not effing the ineffable, "Cindy Winegarden" <cindy.winegarden.DeleteThis@mvps.org> managed to say:
>I hadn't seen it before you drew my attention to it. It didn't trigger any
>of my OE rules that highlight certian messages. Since you see the problem
>with many different back-end databases then I doubt the problem is in the
>database. Which ODBC driver were you using?
I have only first hand experience with this error in VB/FoxPro. My research in
google showed me that this problem occurs on many platforms in very much
the same form. In my continued frenzy to finally solve this problem, I came
across a discussion in mailing.database.myodbc (yes that is usenet). They
were talking about Myodbc there as they should, but about my problem in
their environment.
The suggestion was to never use update on a recordset. Always do updates
with
connection.execute "update table set x=y where condition" (vb speak)
Guess what...
There are hundreds of people out there probably still searching for that answer.
Gleason<!-- ~MESSAGE_AFTER~ --> >> Stay informed about: Visual FoxPro Versions. |
|
| Back to top |
|
| |
External
Since: Oct 02, 2003
Posts: 32
|
(Msg. 9) Posted: Thu Jan 15, 2004 1:57 am
Post subject: Re: Re: Visual FoxPro Versions. [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
In news: r26b009btdq6jb6t1rpc5l4f8dbc5lk9nb DeleteThis @4ax.com,
Noah Sombrero <sombrero DeleteThis @mm.st> wrote:
> The one suggestion made a few years ago to the "query-based" problem
> that I was not able to try was to make what I need a FoxPro "stored
> procedure." Which means that the procedure is stored in the
> database. Can anyone suggest a place on the www with a good
> discussion of FoxPro stored procedures, and a few examples?
All of the Visual FoxPro documentation is online in the MSDN Library.
--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy.winegarden DeleteThis @mvps.org <a style='text-decoration: underline;' href="http://www.cindywinegarden.com" target="_blank">www.cindywinegarden.com</a><!-- ~MESSAGE_AFTER~ --> >> Stay informed about: Visual FoxPro Versions. |
|
| Back to top |
|
| |
External
Since: Jan 14, 2004
Posts: 7
|
(Msg. 10) Posted: Thu Jan 15, 2004 1:57 am
Post subject: Re: Re: Re: Visual FoxPro Versions. [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
While not effing the ineffable, "Cindy Winegarden" <cindy.winegarden RemoveThis @mvps.org> managed to say:
>> procedure." Which means that the procedure is stored in the
>> database. Can anyone suggest a place on the www with a good
>> discussion of FoxPro stored procedures, and a few examples?
>
>All of the Visual FoxPro documentation is online in the MSDN Library.
Yes, I have the cd and I have looked at what is online. As is so often the
case, the answer that I need is not there. And that includes a good
discussion of stored procedures. Stored procedures was a useless idea
by the way. I went to the local technical bookstore and spent $50
for a good book on the subject to find out that FoxPro stored procedures
work very poorly through odbc. If you want to do stored procedures with
FoxPro, you need to also have SQL Server involved. Wrong answer.
Gleason<!-- ~MESSAGE_AFTER~ --> >> Stay informed about: Visual FoxPro Versions. |
|
| Back to top |
|
| |
External
Since: Oct 02, 2003
Posts: 32
|
(Msg. 11) Posted: Thu Jan 15, 2004 12:16 pm
Post subject: Re: Re: Re: Visual FoxPro Versions. [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
In news: u5bc005mh8gu5p6viqobs2qgss9fjtgrtc.DeleteThis@4ax.com,
Noah Sombrero <sombrero.DeleteThis@mm.st> wrote:
> The suggestion was to never use update on a recordset. Always do
> updates
> with
>
> connection.execute "update table set x=y where condition" (vb speak)
I'm glad you found a solution!
--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy.winegarden.DeleteThis@mvps.org <a style='text-decoration: underline;' href="http://www.cindywinegarden.com" target="_blank">www.cindywinegarden.com</a><!-- ~MESSAGE_AFTER~ --> >> Stay informed about: Visual FoxPro Versions. |
|
| Back to top |
|
| |
External
Since: Oct 02, 2003
Posts: 32
|
(Msg. 12) Posted: Thu Jan 15, 2004 12:17 pm
Post subject: Re: Re: Re: Visual FoxPro Versions. [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
In news: lubc00585coe2dltbjpc08o6f3fe78jt4f DeleteThis @4ax.com,
Noah Sombrero <sombrero DeleteThis @mm.st> wrote:
> ... FoxPro stored procedures
> work very poorly through odbc.
The VFP OLE DB data provider has much better support for stored procedures.
--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy.winegarden DeleteThis @mvps.org <a style='text-decoration: underline;' href="http://www.cindywinegarden.com" target="_blank">www.cindywinegarden.com</a><!-- ~MESSAGE_AFTER~ --> >> Stay informed about: Visual FoxPro Versions. |
|
| Back to top |
|
| |
External
Since: Mar 08, 2004
Posts: 1
|
(Msg. 13) Posted: Mon Mar 08, 2004 10:30 am
Post subject: Re: Visual FoxPro Versions. [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Noah Sombrero wrote:
> Cindy,
>
> With all your qualifications, you must have come across my "query-based
> update failed" problem. I would love to hear what you have to say about
> it.
>
> Gleason<!-- ~MESSAGE_AFTER~ --> >> Stay informed about: Visual FoxPro Versions. |
|
| Back to top |
|
| |
External
Since: Jan 19, 2004
Posts: 8
|
(Msg. 14) Posted: Thu May 27, 2004 9:21 am
Post subject: Re: Visual FoxPro Versions. [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
If 8129 is the last driver to be made available then where did I get version 8630 (6/19/2003)?
----- Cindy Winegarden wrote: -----
In news: Ow2HpbK2DHA.3656.RemoveThis@TK2MSFTNGP11.phx.gbl,
Joe "Nuke Me Xemu" Foster <joe.RemoveThis@bftsi0.UUCP> wrote:
> Hopefully VFP7 includes updated redistributable ODBC drivers!
As in my other post, the latest and last ODBC drivers are version
6.1.8629.1, which Roger has. There will be no further updates to these
drivers. Microsoft is moving away from ODBC as a data access method.
--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy.winegarden.RemoveThis@mvps.org <a style='text-decoration: underline;' href="http://www.cindywinegarden.com" target="_blank">www.cindywinegarden.com</a><!-- ~MESSAGE_AFTER~ --> >> Stay informed about: Visual FoxPro Versions. |
|
| Back to top |
|
| |
External
Since: Oct 02, 2003
Posts: 32
|
(Msg. 15) Posted: Thu May 27, 2004 2:23 pm
Post subject: Re: Visual FoxPro Versions. [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
In news: 993C98B5-0FE8-4E65-8179-951D4AF9EAEB RemoveThis @microsoft.com,
Darrell Wesley <anonymous RemoveThis @discussions.microsoft.com> wrote:
> If 8129 is the last driver to be made available then where did I get
> version 8630 (6/19/2003)?
I think there were two versions - one installed separately and one as part
of a merge module. Otherwise, the function was the same.
--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy.winegarden RemoveThis @mvps.org <a style='text-decoration: underline;' href="http://www.cindywinegarden.com" target="_blank">www.cindywinegarden.com</a><!-- ~MESSAGE_AFTER~ --> >> Stay informed about: Visual FoxPro Versions. |
|
| Back to top |
|
| |
FAQ
Profile
Private Messages
Log in
