Now is on the list where it belongs :)
Em .... please help!
----- Original Message -----
From: "Carl Karsten" <[EMAIL PROTECTED]>
To: "Stan Sebastian" <[EMAIL PROTECTED]>
Sent: Thursday, March 11, 2004 5:58 PM
Subject: Re: Load data + odbc
> One of us (looks like me) replied directly instead of posting to the list.
I
> have some ideas, but this and my ideas should be on the list. post it up
there
> and I will reply to it.
>
> Carl K
>
>
> ----- Original Message -----
> From: "Stan Sebastian" <[EMAIL PROTECTED]>
> To: "Carl Karsten" <[EMAIL PROTECTED]>
> Sent: Thursday, March 11, 2004 1:39 AM
> Subject: Re: Load data + odbc
>
>
> > Thanks for you reply.
> >
> > 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. It's funny that another sql statements, SELECT,
> > DELETE, UPDATE, INSERT work.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
