> > > The first test i've done was on, lets say, BoxA and it worked just fine.
> > > Than, i said,'ok, lets install the client on another WKS' that is BoxB.
> And
> > > from BoxB it's not working.
> > >
> > > > > I've got 2 workstations and a server on which i have Mysql 3.23.52 -
> nt.
> > > >
> > > > Lets call the workstations BoxA and BoxB, and the server BoxC.
> > > >
> > > > >
> > > > > The clients are build in Visual FoxPro and use MyODBC for connecting
> to
> > > > > server.
> > > > >
> > > > > >From both WKS statements like select, insert, update, delete work
> just
> > > fine,
> > > > > but when i want to 'LOAD DATA local INFILE' it works OK only from
> one
> > > WKS.
> > > >
> > >
> > > Here's my code
> > >
> > > open database opreluare
> > >
> > > CREATE CONNECTION transfer ;
> > > DATASOURCE "MYSQLSERVER" ;
> > > USERID "incarc" PASSWORD "incarc" ;
> > > DATABASE "OCUPAT"
> > >
> > > vQuery="LOAD DATA local INFILE 'c:/ocupat/preluare/baza.txt' into
> table
> > > baza FIELDS TERMINATED BY ''"
> > >
> > > r=sqlexec(sqlconnect("transfer"),vQuery)
> > >
> > > and r is -1 after that.
h = SqlConnect("transfer")
r=sqlexec(h,vQuery)
if r<0
? aError( laErrors )
_cliptext = laErrors[1,2]
endif
Paste the result here.
Carl K
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
