Re: Are typed bound parameters working with unixODBC/FreeTDS

Pierre Buyle <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <[email protected]> 
Hi,

On Thu, Sep 30, 2010 at 4:53 PM,  <[email protected]> wrote:
> Message: 7
> Date: Thu, 30 Sep 2010 16:53:52 +0200
> From: Frediano Ziglio <[email protected]>
> To: FreeTDS Development Group <[email protected]>
> Subject: Re: [freetds] Are typed bound parameters working with unixODBC/FreeTDS
> A bit similar to
> http://stackoverflow.com/questions/3828215/using-typed-bound-parameters-with-php-pdo-odbc-unixodbc-and-freetds:)
Yes, I cross-posted my issue there :D

> I don't know how PDO works but surely ODBC does not support ":foo" as
> parameter and as ODBC specification only RPC (store procedures) support
> named parameters so PHP should convert ":foo" to "?".
The same code worked fine on a Windows workstation. So I guess PDO
handles named parameters right and convert ":foo" to "?".

> Our driver does not support SQLDescribeParam but there is no reason why PDO
> should pass the integer value as a LONGVARCHAR as it seems to do from log.
> The ODBC trace reported however is a bit too should, it would be better a
> trace that include SQLPrepare and SQLExecute.
Attached to this mail, a more complete unixODBC log. The log is on the
actual script/query which more complex that the sample given code.

Here is the used code

    $sql = "INSERT INTO
kandidaat(kandidaat_id,kandidaat_naam,kandidaat_voornaam,kandidaat_straat,kandidaat_nummer,kandidaat_bus,"
        ."kandidaat_postcode,kandidaat_woonplaats,kandidaat_email,kandidaat_gsm,kandidaat_geboortedatum,kandidaat_nationaliteit,"
        ."kandidaat_geslacht,kandidaat_burgerlijks_staat,kandidaat_taalcode,kandidaat_dossier_taal,kandidaat_status,zoeknaam,"
        ."zoekvoornaam) VALUES (CAST(CAST(:candidat AS varchar) AS
integer),:name,:firstname,:street,:number,:box,:zip,:city,:mail,:gsm,CAST(CAST(:birthdate
AS varchar) AS datetime),:nationality,"
        .":sex,:civil_statue,:language,:language2,1,dbo.searchvalue(:namedbo),dbo.searchvalue(:firstnamedbo));
";
    $stmt = $PDO->prepare($sql);
    $stmt->bindValue(':candidat', $candidat, PDO::PARAM_STR);	
    $stmt->bindValue(':name', $name, PDO::PARAM_STR);
    $stmt->bindValue(':firstname', $firstname, PDO::PARAM_STR);
    $stmt->bindValue(':namedbo', $name, PDO::PARAM_STR);
    $stmt->bindValue(':firstnamedbo', $firstname, PDO::PARAM_STR);
    $stmt->bindValue(':birthdate', "$birth_date", PDO::PARAM_STR);
    $stmt->bindValue(':street', $street, PDO::PARAM_STR);
    $stmt->bindValue(':number', $number, PDO::PARAM_STR);
    $stmt->bindValue(':box', $box, PDO::PARAM_STR);
    $stmt->bindValue(':zip', $zip, PDO::PARAM_STR);
    $stmt->bindValue(':city', $city, PDO::PARAM_STR);
    $stmt->bindValue(':mail', $mail, PDO::PARAM_STR);
    $stmt->bindValue(':gsm', $gsm, PDO::PARAM_STR);
    $stmt->bindValue(':nationality', $nationality, PDO::PARAM_STR);
    $stmt->bindValue(':sex', $sex, PDO::PARAM_STR);
    $stmt->bindValue(':civil_statue', $civil_statue, PDO::PARAM_STR);
    $stmt->bindValue(':language', $language, PDO::PARAM_STR);
    $stmt->bindValue(':language2', $language, PDO::PARAM_STR);
    $stmt->execute();

--
Pierre Buyle

_______________________________________________
FreeTDS mailing list
[email protected]
http://lists.ibiblio.org/mailman/listinfo/freetds
unixodbc.log (application/octet-stream, 25.9 KB) 
[ODBC][26251][SQLPrepare.c][189]
		Entry:            
			Statement = 0x2b73c849fb80            
			SQL = [INSERT INTO kandidaat(kandidaat_id,kandidaat_naam,kandidaat_voornaam,kandidaat_straat,kandidaat_nummer,kandidaat_bus,kandidaat_p...][length = 446 (SQL_NTS)]
[ODBC][26251][SQLPrepare.c][364]
		Exit:[SQL_SUCCESS]
[ODBC][26251][SQLDescribeParam.c][175]
		Entry:            
			Statement = 0x2b73c849fb80            
			Parameter Number = 1            
			SQL Type = 0x7fff9c89e15e            
			Param Def = 0x7fff9c89e154            
			Scale = 0x7fff9c89e15c            
			Nullable = 0x7fff9c89e15a
[ODBC][26251][SQLDescribeParam.c][276]Error: IM001
[ODBC][26251][SQLBindParameter.c][193]
		Entry:            
			Statement = 0x2b73c849fb80            
			Param Number = 1            
			Param Type = 1            
			C Type = 1 SQL_C_CHAR            
			SQL Type = -1 SQL_LONGVARCHAR            
			Col Def = 4000            
			Scale = 5            
			Rgb Value = 0x2b73c941f890            
			Value Max = 0            
			StrLen Or Ind = 0x2b73c93fa1b0
[ODBC][26251][SQLBindParameter.c][339]
		Exit:[SQL_SUCCESS]
[ODBC][26251][SQLDescribeParam.c][175]
		Entry:            
			Statement = 0x2b73c849fb80            
			Parameter Number = 2            
			SQL Type = 0x7fff9c89e15e            
			Param Def = 0x7fff9c89e154            
			Scale = 0x7fff9c89e15c            
			Nullable = 0x7fff9c89e15a
[ODBC][26251][SQLDescribeParam.c][276]Error: IM001
[ODBC][26251][SQLBindParameter.c][193]
		Entry:            
			Statement = 0x2b73c849fb80            
			Param Number = 2            
			Param Type = 1            
			C Type = 1 SQL_C_CHAR            
			SQL Type = -1 SQL_LONGVARCHAR            
			Col Def = 4000            
			Scale = 5            
			Rgb Value = 0x2b73c941fbb0            
			Value Max = 0            
			StrLen Or Ind = 0x2b73c9409568
[ODBC][26251][SQLBindParameter.c][339]
		Exit:[SQL_SUCCESS]
[ODBC][26251][SQLDescribeParam.c][175]
		Entry:            
			Statement = 0x2b73c849fb80            
			Parameter Number = 3            
			SQL Type = 0x7fff9c89e15e            
			Param Def = 0x7fff9c89e154            
			Scale = 0x7fff9c89e15c            
			Nullable = 0x7fff9c89e15a
[ODBC][26251][SQLDescribeParam.c][276]Error: IM001
[ODBC][26251][SQLBindParameter.c][193]
		Entry:            
			Statement = 0x2b73c849fb80            
			Param Number = 3            
			Param Type = 1            
			C Type = 1 SQL_C_CHAR            
			SQL Type = -1 SQL_LONGVARCHAR            
			Col Def = 4000            
			Scale = 5            
			Rgb Value = 0x2b73c941ea00            
			Value Max = 0            
			StrLen Or Ind = 0x2b73c94600c8
[ODBC][26251][SQLBindParameter.c][339]
		Exit:[SQL_SUCCESS]
[ODBC][26251][SQLDescribeParam.c][175]
		Entry:            
			Statement = 0x2b73c849fb80            
			Parameter Number = 17            
			SQL Type = 0x7fff9c89e15e            
			Param Def = 0x7fff9c89e154            
			Scale = 0x7fff9c89e15c            
			Nullable = 0x7fff9c89e15a
[ODBC][26251][SQLDescribeParam.c][276]Error: IM001
[ODBC][26251][SQLBindParameter.c][193]
		Entry:            
			Statement = 0x2b73c849fb80            
			Param Number = 17            
			Param Type = 1            
			C Type = 1 SQL_C_CHAR            
			SQL Type = -1 SQL_LONGVARCHAR            
			Col Def = 4000            
			Scale = 5            
			Rgb Value = 0x2b73c941ec10            
			Value Max = 0            
			StrLen Or Ind = 0x2b73c9409a90
[ODBC][26251][SQLBindParameter.c][339]
		Exit:[SQL_SUCCESS]
[ODBC][26251][SQLDescribeParam.c][175]
		Entry:            
			Statement = 0x2b73c849fb80            
			Parameter Number = 18            
			SQL Type = 0x7fff9c89e15e            
			Param Def = 0x7fff9c89e154            
			Scale = 0x7fff9c89e15c            
			Nullable = 0x7fff9c89e15a
[ODBC][26251][SQLDescribeParam.c][276]Error: IM001
[ODBC][26251][SQLBindParameter.c][193]
		Entry:            
			Statement = 0x2b73c849fb80            
			Param Number = 18            
			Param Type = 1            
			C Type = 1 SQL_C_CHAR            
			SQL Type = -1 SQL_LONGVARCHAR            
			Col Def = 4000            
			Scale = 5            
			Rgb Value = 0x2b73c941ee30            
			Value Max = 0            
			StrLen Or Ind = 0x2b73c9397760
[ODBC][26251][SQLBindParameter.c][339]
		Exit:[SQL_SUCCESS]
[ODBC][26251][SQLDescribeParam.c][175]
		Entry:            
			Statement = 0x2b73c849fb80            
			Parameter Number = 4            
			SQL Type = 0x7fff9c89e15e            
			Param Def = 0x7fff9c89e154            
			Scale = 0x7fff9c89e15c            
			Nullable = 0x7fff9c89e15a
[ODBC][26251][SQLDescribeParam.c][276]Error: IM001
[ODBC][26251][SQLBindParameter.c][193]
		Entry:            
			Statement = 0x2b73c849fb80            
			Param Number = 4            
			Param Type = 1            
			C Type = 1 SQL_C_CHAR            
			SQL Type = -1 SQL_LONGVARCHAR            
			Col Def = 4000            
			Scale = 5            
			Rgb Value = 0x2b73c941f040            
			Value Max = 0            
			StrLen Or Ind = 0x2b73c93f4190
[ODBC][26251][SQLBindParameter.c][339]
		Exit:[SQL_SUCCESS]
[ODBC][26251][SQLDescribeParam.c][175]
		Entry:            
			Statement = 0x2b73c849fb80            
			Parameter Number = 5            
			SQL Type = 0x7fff9c89e15e            
			Param Def = 0x7fff9c89e154            
			Scale = 0x7fff9c89e15c            
			Nullable = 0x7fff9c89e15a
[ODBC][26251][SQLDescribeParam.c][276]Error: IM001
[ODBC][26251][SQLBindParameter.c][193]
		Entry:            
			Statement = 0x2b73c849fb80            
			Param Number = 5            
			Param Type = 1            
			C Type = 1 SQL_C_CHAR            
			SQL Type = -1 SQL_LONGVARCHAR            
			Col Def = 4000            
			Scale = 5            
			Rgb Value = 0x2b73c941e7f0            
			Value Max = 0            
			StrLen Or Ind = 0x2b73c940dcb0
[ODBC][26251][SQLBindParameter.c][339]
		Exit:[SQL_SUCCESS]
[ODBC][26251][SQLDescribeParam.c][175]
		Entry:            
			Statement = 0x2b73c849fb80            
			Parameter Number = 6            
			SQL Type = 0x7fff9c89e15e            
			Param Def = 0x7fff9c89e154            
			Scale = 0x7fff9c89e15c            
			Nullable = 0x7fff9c89e15a
[ODBC][26251][SQLDescribeParam.c][276]Error: IM001
[ODBC][26251][SQLBindParameter.c][193]
		Entry:            
			Statement = 0x2b73c849fb80            
			Param Number = 6            
			Param Type = 1            
			C Type = 1 SQL_C_CHAR            
			SQL Type = -1 SQL_LONGVARCHAR            
			Col Def = 4000            
			Scale = 5            
			Rgb Value = 0x2b73c941e5e0            
			Value Max = 0            
			StrLen Or Ind = 0x2b73c94107f0
[ODBC][26251][SQLBindParameter.c][339]
		Exit:[SQL_SUCCESS]
[ODBC][26251][SQLDescribeParam.c][175]
		Entry:            
			Statement = 0x2b73c849fb80            
			Parameter Number = 7            
			SQL Type = 0x7fff9c89e15e            
			Param Def = 0x7fff9c89e154            
			Scale = 0x7fff9c89e15c            
			Nullable = 0x7fff9c89e15a
[ODBC][26251][SQLDescribeParam.c][276]Error: IM001
[ODBC][26251][SQLBindParameter.c][193]
		Entry:            
			Statement = 0x2b73c849fb80            
			Param Number = 7            
			Param Type = 1            
			C Type = 1 SQL_C_CHAR            
			SQL Type = -1 SQL_LONGVARCHAR            
			Col Def = 4000            
			Scale = 5            
			Rgb Value = 0x2b73c941e3c8            
			Value Max = 0            
			StrLen Or Ind = 0x2b73c9414360
[ODBC][26251][SQLBindParameter.c][339]
		Exit:[SQL_SUCCESS]
[ODBC][26251][SQLDescribeParam.c][175]
		Entry:            
			Statement = 0x2b73c849fb80            
			Parameter Number = 8            
			SQL Type = 0x7fff9c89e15e            
			Param Def = 0x7fff9c89e154            
			Scale = 0x7fff9c89e15c            
			Nullable = 0x7fff9c89e15a
[ODBC][26251][SQLDescribeParam.c][276]Error: IM001
[ODBC][26251][SQLBindParameter.c][193]
		Entry:            
			Statement = 0x2b73c849fb80            
			Param Number = 8            
			Param Type = 1            
			C Type = 1 SQL_C_CHAR            
			SQL Type = -1 SQL_LONGVARCHAR            
			Col Def = 4000            
			Scale = 5            
			Rgb Value = 0x2b73c941e0a8            
			Value Max = 0            
			StrLen Or Ind = 0x2b73c9415e60
[ODBC][26251][SQLBindParameter.c][339]
		Exit:[SQL_SUCCESS]
[ODBC][26251][SQLDescribeParam.c][175]
		Entry:            
			Statement = 0x2b73c849fb80            
			Parameter Number = 9            
			SQL Type = 0x7fff9c89e15e            
			Param Def = 0x7fff9c89e154            
			Scale = 0x7fff9c89e15c            
			Nullable = 0x7fff9c89e15a
[ODBC][26251][SQLDescribeParam.c][276]Error: IM001
[ODBC][26251][SQLBindParameter.c][193]
		Entry:            
			Statement = 0x2b73c849fb80            
			Param Number = 9            
			Param Type = 1            
			C Type = 1 SQL_C_CHAR            
			SQL Type = -1 SQL_LONGVARCHAR            
			Col Def = 4000            
			Scale = 5            
			Rgb Value = 0x2b73c941de98            
			Value Max = 0            
			StrLen Or Ind = 0x2b73c9415ff0
[ODBC][26251][SQLBindParameter.c][339]
		Exit:[SQL_SUCCESS]
[ODBC][26251][SQLDescribeParam.c][175]
		Entry:            
			Statement = 0x2b73c849fb80            
			Parameter Number = 10            
			SQL Type = 0x7fff9c89e15e            
			Param Def = 0x7fff9c89e154            
			Scale = 0x7fff9c89e15c            
			Nullable = 0x7fff9c89e15a
[ODBC][26251][SQLDescribeParam.c][276]Error: IM001
[ODBC][26251][SQLBindParameter.c][193]
		Entry:            
			Statement = 0x2b73c849fb80            
			Param Number = 10            
			Param Type = 1            
			C Type = 1 SQL_C_CHAR            
			SQL Type = -1 SQL_LONGVARCHAR            
			Col Def = 4000            
			Scale = 5            
			Rgb Value = 0x2b73c941da60            
			Value Max = 0            
			StrLen Or Ind = 0x2b73c9408508
[ODBC][26251][SQLBindParameter.c][339]
		Exit:[SQL_SUCCESS]
[ODBC][26251][SQLDescribeParam.c][175]
		Entry:            
			Statement = 0x2b73c849fb80            
			Parameter Number = 11            
			SQL Type = 0x7fff9c89e15e            
			Param Def = 0x7fff9c89e154            
			Scale = 0x7fff9c89e15c            
			Nullable = 0x7fff9c89e15a
[ODBC][26251][SQLDescribeParam.c][276]Error: IM001
[ODBC][26251][SQLBindParameter.c][193]
		Entry:            
			Statement = 0x2b73c849fb80            
			Param Number = 11            
			Param Type = 1            
			C Type = 1 SQL_C_CHAR            
			SQL Type = -1 SQL_LONGVARCHAR            
			Col Def = 4000            
			Scale = 5            
			Rgb Value = 0x2b73c941d958            
			Value Max = 0            
			StrLen Or Ind = 0x2b73c940b080
[ODBC][26251][SQLBindParameter.c][339]
		Exit:[SQL_SUCCESS]
[ODBC][26251][SQLDescribeParam.c][175]
		Entry:            
			Statement = 0x2b73c849fb80            
			Parameter Number = 12            
			SQL Type = 0x7fff9c89e15e            
			Param Def = 0x7fff9c89e154            
			Scale = 0x7fff9c89e15c            
			Nullable = 0x7fff9c89e15a
[ODBC][26251][SQLDescribeParam.c][276]Error: IM001
[ODBC][26251][SQLBindParameter.c][193]
		Entry:            
			Statement = 0x2b73c849fb80            
			Param Number = 12            
			Param Type = 1            
			C Type = 1 SQL_C_CHAR            
			SQL Type = -1 SQL_LONGVARCHAR            
			Col Def = 4000            
			Scale = 5            
			Rgb Value = 0x2b73c941d850            
			Value Max = 0            
			StrLen Or Ind = 0x2b73c940cb10
[ODBC][26251][SQLBindParameter.c][339]
		Exit:[SQL_SUCCESS]
[ODBC][26251][SQLDescribeParam.c][175]
		Entry:            
			Statement = 0x2b73c849fb80            
			Parameter Number = 13            
			SQL Type = 0x7fff9c89e15e            
			Param Def = 0x7fff9c89e154            
			Scale = 0x7fff9c89e15c            
			Nullable = 0x7fff9c89e15a
[ODBC][26251][SQLDescribeParam.c][276]Error: IM001
[ODBC][26251][SQLBindParameter.c][193]
		Entry:            
			Statement = 0x2b73c849fb80            
			Param Number = 13            
			Param Type = 1            
			C Type = 1 SQL_C_CHAR            
			SQL Type = -1 SQL_LONGVARCHAR            
			Col Def = 4000            
			Scale = 5            
			Rgb Value = 0x2b73c941d630            
			Value Max = 0            
			StrLen Or Ind = 0x2b73c9406808
[ODBC][26251][SQLBindParameter.c][339]
		Exit:[SQL_SUCCESS]
[ODBC][26251][SQLDescribeParam.c][175]
		Entry:            
			Statement = 0x2b73c849fb80            
			Parameter Number = 14            
			SQL Type = 0x7fff9c89e15e            
			Param Def = 0x7fff9c89e154            
			Scale = 0x7fff9c89e15c            
			Nullable = 0x7fff9c89e15a
[ODBC][26251][SQLDescribeParam.c][276]Error: IM001
[ODBC][26251][SQLBindParameter.c][193]
		Entry:            
			Statement = 0x2b73c849fb80            
			Param Number = 14            
			Param Type = 1            
			C Type = 1 SQL_C_CHAR            
			SQL Type = -1 SQL_LONGVARCHAR            
			Col Def = 4000            
			Scale = 5            
			Rgb Value = 0x2b73c941d510            
			Value Max = 0            
			StrLen Or Ind = 0x2b73c939b938
[ODBC][26251][SQLBindParameter.c][339]
		Exit:[SQL_SUCCESS]
[ODBC][26251][SQLDescribeParam.c][175]
		Entry:            
			Statement = 0x2b73c849fb80            
			Parameter Number = 15            
			SQL Type = 0x7fff9c89e15e            
			Param Def = 0x7fff9c89e154            
			Scale = 0x7fff9c89e15c            
			Nullable = 0x7fff9c89e15a
[ODBC][26251][SQLDescribeParam.c][276]Error: IM001
[ODBC][26251][SQLBindParameter.c][193]
		Entry:            
			Statement = 0x2b73c849fb80            
			Param Number = 15            
			Param Type = 1            
			C Type = 1 SQL_C_CHAR            
			SQL Type = -1 SQL_LONGVARCHAR            
			Col Def = 4000            
			Scale = 5            
			Rgb Value = 0x2b73c941d2f0            
			Value Max = 0            
			StrLen Or Ind = 0x2b73c93c44c8
[ODBC][26251][SQLBindParameter.c][339]
		Exit:[SQL_SUCCESS]
[ODBC][26251][SQLDescribeParam.c][175]
		Entry:            
			Statement = 0x2b73c849fb80            
			Parameter Number = 16            
			SQL Type = 0x7fff9c89e15e            
			Param Def = 0x7fff9c89e154            
			Scale = 0x7fff9c89e15c            
			Nullable = 0x7fff9c89e15a
[ODBC][26251][SQLDescribeParam.c][276]Error: IM001
[ODBC][26251][SQLBindParameter.c][193]
		Entry:            
			Statement = 0x2b73c849fb80            
			Param Number = 16            
			Param Type = 1            
			C Type = 1 SQL_C_CHAR            
			SQL Type = -1 SQL_LONGVARCHAR            
			Col Def = 4000            
			Scale = 5            
			Rgb Value = 0x2b73c941d1e8            
			Value Max = 0            
			StrLen Or Ind = 0x2b73c93ca1a8
[ODBC][26251][SQLBindParameter.c][339]
		Exit:[SQL_SUCCESS]
[ODBC][26251][SQLExecute.c][183]
		Entry:            
			Statement = 0x2b73c849fb80
[ODBC][26251][SQLExecute.c][344]
		Exit:[SQL_NEED_DATA]
[ODBC][26251][SQLParamData.c][156]
		Entry:            
			Statement = 0x2b73c849fb80            
			Value = 0x7fff9c89e178
[ODBC][26251][SQLParamData.c][327]
		Exit:[SQL_NEED_DATA]                
			Value = 0x2b73c941f890
[ODBC][26251][SQLPutData.c][144]
		Entry:            
			Statement = 0x2b73c849fb80            
			Data = 0x2b73c941cec8            
			StrLen = 5
[ODBC][26251][SQLPutData.c][289]
		Exit:[SQL_SUCCESS]
[ODBC][26251][SQLParamData.c][156]
		Entry:            
			Statement = 0x2b73c849fb80            
			Value = 0x7fff9c89e178
[ODBC][26251][SQLParamData.c][327]
		Exit:[SQL_NEED_DATA]                
			Value = 0x2b73c941fbb0
[ODBC][26251][SQLPutData.c][144]
		Entry:            
			Statement = 0x2b73c849fb80            
			Data = 0x2b73c9403e38            
			StrLen = 4
[ODBC][26251][SQLPutData.c][289]
		Exit:[SQL_SUCCESS]
[ODBC][26251][SQLParamData.c][156]
		Entry:            
			Statement = 0x2b73c849fb80            
			Value = 0x7fff9c89e178
[ODBC][26251][SQLParamData.c][327]
		Exit:[SQL_NEED_DATA]                
			Value = 0x2b73c941ea00
[ODBC][26251][SQLPutData.c][144]
		Entry:            
			Statement = 0x2b73c849fb80            
			Data = 0x2b73c9403f00            
			StrLen = 4
[ODBC][26251][SQLPutData.c][289]
		Exit:[SQL_SUCCESS]
[ODBC][26251][SQLParamData.c][156]
		Entry:            
			Statement = 0x2b73c849fb80            
			Value = 0x7fff9c89e178
[ODBC][26251][SQLParamData.c][327]
		Exit:[SQL_NEED_DATA]                
			Value = 0x2b73c941f040
[ODBC][26251][SQLPutData.c][144]
		Entry:            
			Statement = 0x2b73c849fb80            
			Data = 0x2b73c9409780            
			StrLen = 4
[ODBC][26251][SQLPutData.c][289]
		Exit:[SQL_SUCCESS]
[ODBC][26251][SQLParamData.c][156]
		Entry:            
			Statement = 0x2b73c849fb80            
			Value = 0x7fff9c89e178
[ODBC][26251][SQLParamData.c][327]
		Exit:[SQL_NEED_DATA]                
			Value = 0x2b73c941e7f0
[ODBC][26251][SQLPutData.c][144]
		Entry:            
			Statement = 0x2b73c849fb80            
			Data = 0x2b73c940a328            
			StrLen = 3
[ODBC][26251][SQLPutData.c][289]
		Exit:[SQL_SUCCESS]
[ODBC][26251][SQLParamData.c][156]
		Entry:            
			Statement = 0x2b73c849fb80            
			Value = 0x7fff9c89e178
[ODBC][26251][SQLParamData.c][327]
		Exit:[SQL_NEED_DATA]                
			Value = 0x2b73c941e5e0
[ODBC][26251][SQLPutData.c][144]
		Entry:            
			Statement = 0x2b73c849fb80            
			Data = 0x2b73c94094e8            
			StrLen = 0
[ODBC][26251][SQLPutData.c][289]
		Exit:[SQL_SUCCESS]
[ODBC][26251][SQLParamData.c][156]
		Entry:            
			Statement = 0x2b73c849fb80            
			Value = 0x7fff9c89e178
[ODBC][26251][SQLParamData.c][327]
		Exit:[SQL_NEED_DATA]                
			Value = 0x2b73c941e3c8
[ODBC][26251][SQLPutData.c][144]
		Entry:            
			Statement = 0x2b73c849fb80            
			Data = 0x2b73c940a0b8            
			StrLen = 4
[ODBC][26251][SQLPutData.c][289]
		Exit:[SQL_SUCCESS]
[ODBC][26251][SQLParamData.c][156]
		Entry:            
			Statement = 0x2b73c849fb80            
			Value = 0x7fff9c89e178
[ODBC][26251][SQLParamData.c][327]
		Exit:[SQL_NEED_DATA]                
			Value = 0x2b73c941e0a8
[ODBC][26251][SQLPutData.c][144]
		Entry:            
			Statement = 0x2b73c849fb80            
			Data = 0x2b73c9415c80            
			StrLen = 9
[ODBC][26251][SQLPutData.c][289]
		Exit:[SQL_SUCCESS]
[ODBC][26251][SQLParamData.c][156]
		Entry:            
			Statement = 0x2b73c849fb80            
			Value = 0x7fff9c89e178
[ODBC][26251][SQLParamData.c][327]
		Exit:[SQL_NEED_DATA]                
			Value = 0x2b73c941de98
[ODBC][26251][SQLPutData.c][144]
		Entry:            
			Statement = 0x2b73c849fb80            
			Data = 0x2b73c940a470            
			StrLen = 21
[ODBC][26251][SQLPutData.c][289]
		Exit:[SQL_SUCCESS]
[ODBC][26251][SQLParamData.c][156]
		Entry:            
			Statement = 0x2b73c849fb80            
			Value = 0x7fff9c89e178
[ODBC][26251][SQLParamData.c][327]
		Exit:[SQL_NEED_DATA]                
			Value = 0x2b73c941da60
[ODBC][26251][SQLPutData.c][144]
		Entry:            
			Statement = 0x2b73c849fb80            
			Data = 0x2b73c93f9d70            
			StrLen = 0
[ODBC][26251][SQLPutData.c][289]
		Exit:[SQL_SUCCESS]
[ODBC][26251][SQLParamData.c][156]
		Entry:            
			Statement = 0x2b73c849fb80            
			Value = 0x7fff9c89e178
[ODBC][26251][SQLParamData.c][327]
		Exit:[SQL_NEED_DATA]                
			Value = 0x2b73c941d958
[ODBC][26251][SQLPutData.c][144]
		Entry:            
			Statement = 0x2b73c849fb80            
			Data = 0x2b73c941b2b0            
			StrLen = 19
[ODBC][26251][SQLPutData.c][289]
		Exit:[SQL_SUCCESS]
[ODBC][26251][SQLParamData.c][156]
		Entry:            
			Statement = 0x2b73c849fb80            
			Value = 0x7fff9c89e178
[ODBC][26251][SQLParamData.c][327]
		Exit:[SQL_NEED_DATA]                
			Value = 0x2b73c941d850
[ODBC][26251][SQLPutData.c][144]
		Entry:            
			Statement = 0x2b73c849fb80            
			Data = 0x2b73c9409678            
			StrLen = 1
[ODBC][26251][SQLPutData.c][289]
		Exit:[SQL_SUCCESS]
[ODBC][26251][SQLParamData.c][156]
		Entry:            
			Statement = 0x2b73c849fb80            
			Value = 0x7fff9c89e178
[ODBC][26251][SQLParamData.c][327]
		Exit:[SQL_NEED_DATA]                
			Value = 0x2b73c941d630
[ODBC][26251][SQLPutData.c][144]
		Entry:            
			Statement = 0x2b73c849fb80            
			Data = 0x2b73c94038b0            
			StrLen = 1
[ODBC][26251][SQLPutData.c][289]
		Exit:[SQL_SUCCESS]
[ODBC][26251][SQLParamData.c][156]
		Entry:            
			Statement = 0x2b73c849fb80            
			Value = 0x7fff9c89e178
[ODBC][26251][SQLParamData.c][327]
		Exit:[SQL_NEED_DATA]                
			Value = 0x2b73c941d510
[ODBC][26251][SQLPutData.c][144]
		Entry:            
			Statement = 0x2b73c849fb80            
			Data = 0x2b73c940a360            
			StrLen = 0
[ODBC][26251][SQLPutData.c][289]
		Exit:[SQL_SUCCESS]
[ODBC][26251][SQLParamData.c][156]
		Entry:            
			Statement = 0x2b73c849fb80            
			Value = 0x7fff9c89e178
[ODBC][26251][SQLParamData.c][327]
		Exit:[SQL_NEED_DATA]                
			Value = 0x2b73c941d2f0
[ODBC][26251][SQLPutData.c][144]
		Entry:            
			Statement = 0x2b73c849fb80            
			Data = 0x2b73c93bf7c8            
			StrLen = 2
[ODBC][26251][SQLPutData.c][289]
		Exit:[SQL_SUCCESS]
[ODBC][26251][SQLParamData.c][156]
		Entry:            
			Statement = 0x2b73c849fb80            
			Value = 0x7fff9c89e178
[ODBC][26251][SQLParamData.c][327]
		Exit:[SQL_NEED_DATA]                
			Value = 0x2b73c941d1e8
[ODBC][26251][SQLPutData.c][144]
		Entry:            
			Statement = 0x2b73c849fb80            
			Data = 0x2b73c93c7a48            
			StrLen = 2
[ODBC][26251][SQLPutData.c][289]
		Exit:[SQL_SUCCESS]
[ODBC][26251][SQLParamData.c][156]
		Entry:            
			Statement = 0x2b73c849fb80            
			Value = 0x7fff9c89e178
[ODBC][26251][SQLParamData.c][327]
		Exit:[SQL_NEED_DATA]                
			Value = 0x2b73c941ec10
[ODBC][26251][SQLPutData.c][144]
		Entry:            
			Statement = 0x2b73c849fb80            
			Data = 0x2b73c9408f10            
			StrLen = 4
[ODBC][26251][SQLPutData.c][289]
		Exit:[SQL_SUCCESS]
[ODBC][26251][SQLParamData.c][156]
		Entry:            
			Statement = 0x2b73c849fb80            
			Value = 0x7fff9c89e178
[ODBC][26251][SQLParamData.c][327]
		Exit:[SQL_NEED_DATA]                
			Value = 0x2b73c941ee30
[ODBC][26251][SQLPutData.c][144]
		Entry:            
			Statement = 0x2b73c849fb80            
			Data = 0x2b73c9409020            
			StrLen = 4
[ODBC][26251][SQLPutData.c][289]
		Exit:[SQL_SUCCESS]
[ODBC][26251][SQLParamData.c][156]
		Entry:            
			Statement = 0x2b73c849fb80            
			Value = 0x7fff9c89e178
[ODBC][26251][SQLParamData.c][327]
		Exit:[SQL_ERROR]                
			Value = 0x2b73c941ee30
		DIAG [22018] [FreeTDS][SQL Server]Operand type clash: text is incompatible with int

		DIAG [22018] [FreeTDS][SQL Server]Operand type clash: text is incompatible with datetime

		DIAG [42000] [FreeTDS][SQL Server]Statement(s) could not be prepared.

[ODBC][26251][SQLGetDiagRec.c][710]
		Entry:                
			Statement = 0x2b73c849fb80                
			Rec Number = 1                
			SQLState = 0x2b73c93bfba8                
			Native = 0x2b73c93bfdb0                
			Message Text = 0x2b73c93bfbae                
			Buffer Length = 511                
			Text Len Ptr = 0x7fff9c89e11e
[ODBC][26251][SQLGetDiagRec.c][747]
		Exit:[SQL_SUCCESS]                    
			SQLState = 22018                    
			Native = 0x2b73c93bfdb0 -> 206                    
			Message Text = [[FreeTDS][SQL Server]Operand type clash: text is incompatible with int]
[ODBC][26251][SQLGetDiagRec.c][710]
		Entry:                
			Statement = 0x2b73c849fb80                
			Rec Number = 2                
			SQLState = 0x7fff9c89e110                
			Native = 0x7fff9c89e118                
			Message Text = 0x7fff9c89dd10                
			Buffer Length = 1023                
			Text Len Ptr = 0x7fff9c89e11e
[ODBC][26251][SQLGetDiagRec.c][747]
		Exit:[SQL_SUCCESS]                    
			SQLState = 22018                    
			Native = 0x7fff9c89e118 -> 206                    
			Message Text = [[FreeTDS][SQL Server]Operand type clash: text is incompatible with datetime]
[ODBC][26251][SQLGetDiagRec.c][710]
		Entry:                
			Statement = 0x2b73c849fb80                
			Rec Number = 3                
			SQLState = 0x7fff9c89e110                
			Native = 0x7fff9c89e118                
			Message Text = 0x7fff9c89dd10                
			Buffer Length = 1023                
			Text Len Ptr = 0x7fff9c89e11e
[ODBC][26251][SQLGetDiagRec.c][747]
		Exit:[SQL_SUCCESS]                    
			SQLState = 42000                    
			Native = 0x7fff9c89e118 -> 8180                    
			Message Text = [[FreeTDS][SQL Server]Statement(s) could not be prepared.]
[ODBC][26251][SQLGetDiagRec.c][710]
		Entry:                
			Statement = 0x2b73c849fb80                
			Rec Number = 4                
			SQLState = 0x7fff9c89e110                
			Native = 0x7fff9c89e118                
			Message Text = 0x7fff9c89dd10                
			Buffer Length = 1023                
			Text Len Ptr = 0x7fff9c89e11e
[ODBC][26251][SQLGetDiagRec.c][747]
		Exit:[SQL_NO_DATA]
[ODBC][26251][SQLFreeHandle.c][365]
		Entry:
			Handle Type = 3
			Input Handle = 0x2b73c849d7a0
[ODBC][26251][SQLFreeHandle.c][462]
		Exit:[SQL_SUCCESS]
[ODBC][26251][SQLFreeHandle.c][365]
		Entry:
			Handle Type = 3
			Input Handle = 0x2b73c849fb80
[ODBC][26251][SQLFreeHandle.c][462]
		Exit:[SQL_SUCCESS]
[ODBC][26251][SQLEndTran.c][315]
		Entry:            
			Connection = 0x2b73c818e280            
			Completion Type = 1
[ODBC][26251][SQLGetInfo.c][214]
		Entry:            
			Connection = 0x2b73c818e280            
			Info Type = SQL_CURSOR_ROLLBACK_BEHAVIOR (24)            
			Info Value = 0x7fff9c8a6d8e            
			Buffer Length = 8            
			StrLen = 0x7fff9c8a6d8c
[ODBC][26251][SQLGetInfo.c][528]
		Exit:[SQL_SUCCESS]
[ODBC][26251][SQLEndTran.c][488]
		Exit:[SQL_SUCCESS]
[ODBC][26251][SQLDisconnect.c][204]
		Entry:            
			Connection = 0x2b73c818e280
[ODBC][26251][SQLDisconnect.c][341]
		Exit:[SQL_SUCCESS]
[ODBC][26251][SQLFreeHandle.c][268]
		Entry:
			Handle Type = 2
			Input Handle = 0x2b73c818e280
[ODBC][26251][SQLFreeHandle.c][317]
		Exit:[SQL_SUCCESS]
[ODBC][26251][SQLFreeHandle.c][203]
		Entry:
			Handle Type = 1
			Input Handle = 0x2b73c818dca0
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.