Multiples inserts using DB-Lib/MSSQL 7.
Vanderlei Silva
vandersilva at hotmail.com
Thu Dec 2 10:29:19 EST 1999
>Vanderlei Silva writes:
> > Hello,
> > I'm trying to write a migration app in order to transfer our data
>from
> > mySql to MSSQL 7. Using DB-Lib via freeTDS.
> > The following code generates, apparently, good logs in
>/tmp/freetds.log
> > but the true is that only 1 or two rows are really affected in the
>server.
> >
> > dbinit();
> > login = dblogin();
> > DBSETLPWD(login,"xxx");
> > DBSETLUSER(login,"xxx");
> > DBSETLAPP(login,"sqsh");
> > DBSETLHOST(login,"x.x.x.x");
> > dbproc = dbopen(login, "IMSSQL");
> > dbuse(dbproc, "REGISTRATION");
> > .
> > .
> > .
> > while((qrow = mysql_fetch_row(qresult))) {
> > if (qrow[0] != NULL) data.memory = atol(qrow[0]);
> > if (qrow[1] != NULL) strcpy(data.platform, qrow[1]);
> > sprintf(final_sql_cmd, sql_cmd, data.memory, data.platform);
> > dbcmd(dbproc, final_sql_cmd);
> > dbsqlexec(dbproc);
> > }
>
>I guess it's a typo, but... you *do* have a loop on dbresults() in
>there too, right?
>
>Michael
No, no loop on dbresults(). The command in final_sql_cmd is a INSERT. So,
I'm not analysing the results. Should I?
Can the problem be related to the fact that maybe my SQL Server is not
able to process a lot of requests (one after the order very fast, like 100
per second!!!)???
Any help will be valuable.
Vanderlei Silva
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com
More information about the FreeTDS
mailing list