Hi,

I'm using myodbc 3.51.22, mysql 4.1.20 and Clarion. I don't know why,
but sometimes, without reason it (myodbc, mysql or clarion) creates a
new connection between two queries that couldn't be separate. For
example I do "INSERT INTO ...." (in a autoinc table) and after I do
"SELECT last_insert_id()", but each query was executed in their own
connection, than the second query return 0. Do you think that it could
be myodbc error?
Here is some part of mysql log:

C:\Arquivos de programas\MySQL\MySQL Server 4.1\bin\mysqld-nt, Version:
4.1.22-community-nt-log. started with:
TCP Port: 3306, Named Pipe: MySQL
Time Id Command Argument
071129 14:52:17 1 Connect root [at] 192.168.1.234 on Test
1 Query SET SQL_AUTO_IS_NULL =3D 0
1 Query SELECT [at] [at] tx_isolation
1 Query SET SESSION TRANSACTION ISOLATION LEVEL
REPEATABLE READ
1 Query SELECT * FROM Empresa WHERE 0 =3D 1
1 Query SELECT
CodEmpresa,NomeEmpresa,CodSistema,NrUsuarios,DriverBD,AliqPi s,AliqCofins,=
AliqCS,AliqIRF,VlrMinimoIRF,AliqIRLucro,PrazoIRJ,PrazoICMS,P razoIPI,Prazo=
PIS,PrazoCofins,PrazoCS,PrazoFP,PrazoFGTS,PrazoINSS,VlrMinim oICMSDifer,Co=
dFilialPadrao,SeImpressoraFilial,CodClienteINSS,CodClienteIR F,CodClienteP=
CC,CodClienteISS,MetPrevisaoFluxo
FROM Empresa WHERE 0 =3D 1
=2E..
1 Query INSERT INTO NotaPed
(NrCadDoc,CodEmpresa,CodFilial,TipoDocto,NrNota,SerieNF,CodC liente,NrPedi=
do,NrAtendimento)
VALUES (117286,1,5,1,15188,'3',23574,6344,214)
1 Query Begin
1 Query INSERT INTO DocIte
(NrCadDoc,CodEmpresa,CodFilial,TipoDocto,NrNota,SerieNF,CodC liente,NrSeqI=
te,CodProduto,CodVariante,CodTamanho,CodQualidade,UnidMedida ,QtdePecas,Qt=
deMovto,PesoLiquido,PesoBruto,PrecoUnitario,PrecoUnitarioLiq ,TipoOperFat,=
CodNatFiscal,CodProced,CodICMS,CodIPI,IncidePIS,IncideCofins ,IncideCSLL,A=
liqICMS,CodClaFis,TaxaIPI,VlrProduto,VlrSeguro,VlrDespAces,V lrIpiNContrib=
,VlrBonif,VlrBonif2,VlrFrete,VlrFreteCalc,VlrOutDespesas,Vlr ISS,VlrIRF,Vl=
rFunRural,VlrICMS,VlrICMSSubs,VlrICMSDifer,VlrIPI,VlrIPIDesp ,VlrPIS,VlrCo=
fins,VlrCSLL,VlrPCC,VlrINSS,VlrTaxaImportacao,VlrImpostosCob r,VlrServicoP=
ago,VlrContabil,VlrComissao,VlrComissaoAdic,VlrEncFinanc,Cod Colecao,CodLo=
cal,CodLocalDest,CodCusto,CodAplic,NrLoteProd,NrVolume,NrAte ndimento,NrPe=
dido,NrSeqPed,NrOrcam,NrSeqOrc,NrOrdem,NrSeqProd,QtdePerda,S itEstoque,Tip=
oOperEtq,CodMensNF,CodFuncionario,CodProdutoCli,DescProduto, Observ,QtdeGr=
ade1,QtdeGrade2,QtdeGrade3,QtdeGrade4,QtdeGrade5,QtdeGrade6, QtdeGrade7,Qt=
deGrade8,QtdeGrade9,QtdeGrade10,QtdeGrade11,QtdeGrade12)
VALUES
(117286,1,5,1,15188,'3',23574,1,'20120174','','','','PC',0,1 .000
,0.000 ,0.000 ,23.000000 ,23.000000
,'P','510202','0','00','90','S','S','S',17.00 ,' ',0.00
,23.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 =

,0.00 ,0.00 ,0.00 ,0.00 ,3.91 ,0.00 ,0.00 ,0.00
,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00
,0.00 ,0.00 ,1.15 ,0.00 ,0.00
,8,0,0,0,0,'',0,214,6344,1,0,0,0,0,0.000
,'N','N',0,0,'','T-SHIRT','',0,0,0,0,0,0,0,0,0,0,0,0)
131 Connect root [at] 192.168.1.234 on Test
131 Query SET SQL_AUTO_IS_NULL =3D 0
131 Query SET SESSION TRANSACTION ISOLATION LEVEL
REPEATABLE READ
131 Query Select last_insert_id()
1 Query Commit
=2E..

Thanks in advance,
Mauricio Bruns


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=3Dgcdmo-myodbc [at] m.gmane.o rg

Mauricio -

Do you have control over whether Clarion is using a separate connection
to execute the "select last_insert_id()" query? The driver doesn't have
any direct control of which connection is used for a specific query. If
you have some code that you can share, it might help reveal the problem.

Jess

On Mon, Dec 03, 2007 at 09:01:22AM -0300, Mauricio Bruns wrote:
> Hi,
>
> I'm using myodbc 3.51.22, mysql 4.1.20 and Clarion. I don't know why,
> but sometimes, without reason it (myodbc, mysql or clarion) creates a
> new connection between two queries that couldn't be separate. For
> example I do "INSERT INTO ...." (in a autoinc table) and after I do
> "SELECT last_insert_id()", but each query was executed in their own
> connection, than the second query return 0. Do you think that it could
> be myodbc error?
> Here is some part of mysql log:
>
> C:\Arquivos de programas\MySQL\MySQL Server 4.1\bin\mysqld-nt, Version:=

> 4.1.22-community-nt-log. started with:
> TCP Port: 3306, Named Pipe: MySQL
> Time Id Command Argument
> 071129 14:52:17 1 Connect root [at] 192.168.1.234 on Test
> 1 Query SET SQL_AUTO_IS_NULL =3D 0
> 1 Query SELECT [at] [at] tx_isolation
> 1 Query SET SESSION TRANSACTION ISOLATION LEVEL
> REPEATABLE READ
> 1 Query SELECT * FROM Empresa WHERE 0 =3D 1
> 1 Query SELECT
> CodEmpresa,NomeEmpresa,CodSistema,NrUsuarios,DriverBD,AliqPi s,AliqCofins,=
AliqCS,AliqIRF,VlrMinimoIRF,AliqIRLucro,PrazoIRJ,PrazoICMS,P razoIPI,PrazoPI=
S,PrazoCofins,PrazoCS,PrazoFP,PrazoFGTS,PrazoINSS,VlrMinimoI CMSDifer,CodFil=
ialPadrao,SeImpressoraFilial,CodClienteINSS,CodClienteIRF,Co dClientePCC,Cod=
ClienteISS,MetPrevisaoFluxo
> FROM Empresa WHERE 0 =3D 1
> ...
> 1 Query INSERT INTO NotaPed
> (NrCadDoc,CodEmpresa,CodFilial,TipoDocto,NrNota,SerieNF,CodC liente,NrPedi=
do,NrAtendimento)
> VALUES (117286,1,5,1,15188,'3',23574,6344,214)
> 1 Query Begin
> 1 Query INSERT INTO DocIte
> (NrCadDoc,CodEmpresa,CodFilial,TipoDocto,NrNota,SerieNF,CodC liente,NrSeqI=
te,CodProduto,CodVariante,CodTamanho,CodQualidade,UnidMedida ,QtdePecas,Qtde=
Movto,PesoLiquido,PesoBruto,PrecoUnitario,PrecoUnitarioLiq,T ipoOperFat,CodN=
atFiscal,CodProced,CodICMS,CodIPI,IncidePIS,IncideCofins,Inc ideCSLL,AliqICM=
S,CodClaFis,TaxaIPI,VlrProduto,VlrSeguro,VlrDespAces,VlrIpiN Contrib,VlrBoni=
f,VlrBonif2,VlrFrete,VlrFreteCalc,VlrOutDespesas,VlrISS,VlrI RF,VlrFunRural,=
VlrICMS,VlrICMSSubs,VlrICMSDifer,VlrIPI,VlrIPIDesp,VlrPIS,Vl rCofins,VlrCSLL=
,VlrPCC,VlrINSS,VlrTaxaImportacao,VlrImpostosCobr,VlrServico Pago,VlrContabi=
l,VlrComissao,VlrComissaoAdic,VlrEncFinanc,CodColecao,CodLoc al,CodLocalDest=
,CodCusto,CodAplic,NrLoteProd,NrVolume,NrAtendimento,NrPedid o,NrSeqPed,NrOr=
cam,NrSeqOrc,NrOrdem,NrSeqProd,QtdePerda,SitEstoque,TipoOper Etq,CodMensNF,C=
odFuncionario,CodProdutoCli,DescProduto,Observ,QtdeGrade1,Qt deGrade2,QtdeGr=
ade3,QtdeGrade4,QtdeGrade5,QtdeGrade6,QtdeGrade7,QtdeGrade8, QtdeGrade9,Qtde=
Grade10,QtdeGrade11,QtdeGrade12)
> VALUES (117286,1,5,1,15188,'3',23574,1,'20120174','','','','PC',0,1 .000 =

> ,0.000 ,0.000 ,23.000000 ,23.000000
> ,'P','510202','0','00','90','S','S','S',17.00 ,' ',0.00
> ,23.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 =

> ,0.00 ,0.00 ,0.00 ,0.00 ,3.91 ,0.00 ,0.00 ,0.00 =

> ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 =

> ,0.00 ,0.00 ,1.15 ,0.00 ,0.00
> ,8,0,0,0,0,'',0,214,6344,1,0,0,0,0,0.000
> ,'N','N',0,0,'','T-SHIRT','',0,0,0,0,0,0,0,0,0,0,0,0)
> 131 Connect root [at] 192.168.1.234 on Test
> 131 Query SET SQL_AUTO_IS_NULL =3D 0
> 131 Query SET SESSION TRANSACTION ISOLATION LEVEL
> REPEATABLE READ
> 131 Query Select last_insert_id()
> 1 Query Commit
> ...
>
> Thanks in advance,
> Mauricio Bruns
>
>
> --
> MySQL ODBC Mailing List
> For list archives: http://lists.mysql.com/myodbc
> To unsubscribe: http://lists.mysql.com/myodbc?unsub=3Djbalint [at] mysql.com

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=3Dgcdmo-myodbc [at] m.gmane.o rg