freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- From: "Vanderlei Silva" <vandersilva AT hotmail.com>
- To: freetds AT franklin.oit.unc.edu
- Subject: Re: Multiples inserts using DB-Lib/MSSQL 7.
- Date: Thu, 02 Dec 1999 15:29:19 GMT
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
-
Multiples inserts using DB-Lib/MSSQL 7.,
Vanderlei Silva, 12/01/1999
- <Possible follow-up(s)>
- Re: Multiples inserts using DB-Lib/MSSQL 7., Michael Peppler, 12/01/1999
- Re: Multiples inserts using DB-Lib/MSSQL 7., Vanderlei Silva, 12/02/1999
- Re: Multiples inserts using DB-Lib/MSSQL 7., Brian Bruns, 12/02/1999
- Re: Multiples inserts using DB-Lib/MSSQL 7., Vanderlei Silva, 12/02/1999
Archive powered by MHonArc 2.6.24.