Re: CREATE TABLE statement

From: Rick Bean (rgbean_at_unrealmelange-inc.com)
Date: 03/03/04


Date: Wed, 3 Mar 2004 15:21:10 -0500

Geoff,
Just make sure they have the latest (last) VFP ODBC driver installed (6.1.8629.1). It's available at http://msdn.microsoft.com/vfoxpro/downloads/updates/odbc/default.aspx.

Rick

"Geoff" <theauketts(nospam)@hotmail.com> wrote in message news:uI9x8wUAEHA.132@TK2MSFTNGP10.phx.gbl...
> Sorry I'm sure if this is the correct place to post but I could do with some
> advice. I have a VB app that opens an ADO connection using MS ODBC driver
> for Visual Foxpro and creates two tables with the CREATE TABLE Statement.
>
> This all works fine on the three systems in my office (all running XP pro
> SP1) but when I send this out to the Client (running NT 4.0) it falls over
> on the CREATE TABLE execute line saying MS ODBC driver for Visual Foxpro
> syntax Error.
>
> I'm guessing this must be some kind of driver versioning issue but any help
> would be appreicated.
>
> Many Thanks
>
> Geoff Aukett.
>
>