Giter Club home page Giter Club logo

Comments (6)

v-makouz avatar v-makouz commented on May 23, 2024

Right now it's hard to know if the issue is caused by the ODBC driver or somewhere else, like the PHP driver. To help isolate it, can you generate an ODBC trace?
To create a trace log:
run odbcinst -j to see the path to odbcinst.ini, then edit it to add

[ODBC]
Trace=yes
TraceFile=<path_to_file>

at the top of it.

Looking at it might help to see what to investigate next

from homebrew-mssql-release.

keithbrinks avatar keithbrinks commented on May 23, 2024

Hi @v-makouz,

Here is the output of the trace file:

[ODBC][86305][1556636295.239067][SQLAllocHandle.c][377]
		Entry:
			Handle Type = 2
			Input Handle = 0x7fd09c815c00
[ODBC][86305][1556636295.239311][SQLAllocHandle.c][493]
		Exit:[SQL_SUCCESS]
			Output Handle = 0x7fd09c817c00
[ODBC][86305][1556636295.239565][SQLDriverConnectW.c][290]
		Entry:
			Connection = 0x7fd09c817c00
			Window Hdl = 0x0
			Str In = [Server={vmi-ckt-db-01,1433};UID={sa};PWD={*******};Database={STAGING_VenturaApps};MARS_Connection={Yes};Driver={ODBC Driver 17...][length = 144]
			Str Out = 0x0
			Str Out Max = 0
			Str Out Ptr = 0x7ffeec95168a
			Completion = 0
		UNICODE Using encoding ASCII 'US-ASCII' and UNICODE 'UCS-2-INTERNAL'

[ODBC][86305][1556636295.341402][__handles.c][460]
		Exit:[SQL_SUCCESS]
			Environment = 0x7fd09c02ae00
[ODBC][86305][1556636295.341786][SQLGetEnvAttr.c][157]
		Entry:
			Environment = 0x7fd09c02ae00
			Attribute = 65002
			Value = 0x7ffeec94e890
			Buffer Len = 128
			StrLen = 0x7ffeec94e874
[ODBC][86305][1556636295.343209][SQLGetEnvAttr.c][273]
		Exit:[SQL_SUCCESS]
[ODBC][86305][1556636295.343515][SQLFreeHandle.c][220]
		Entry:
			Handle Type = 1
			Input Handle = 0x7fd09c02ae00
[ODBC][86305][1556636295.343694][SQLDriverConnectW.c][914]
		Exit:[SQL_SUCCESS_WITH_INFO]                    
			Connection Out [[NULL]]
[ODBC][86305][1556636295.343930][SQLGetDiagRecW.c][535]
		Entry:
			Connection = 0x7fd09c817c00
			Rec Number = 1
			SQLState = 0x7ffeec951540
			Native = 0x106a09910
			Message Text = 0x7ffeec950d30
			Buffer Length = 1025
			Text Len Ptr = 0x7ffeec950d2e
[ODBC][86305][1556636295.344045][SQLGetDiagRecW.c][596]
		Exit:[SQL_SUCCESS]
			SQLState = [01000]
			Native = 0x106a09910 -> 5701
			Message Text = [[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Changed database context to 'STAGING_VenturaApps'.]
[ODBC][86305][1556636295.344297][SQLGetInfo.c][236]
		Entry:
			Connection = 0x7fd09c817c00
			Info Type = SQL_DBMS_VER (18)
			Info Value = 0x7ffeec9517a0
			Buffer Length = 256
			StrLen = 0x7ffeec9516dc
[ODBC][86305][1556636295.344727][SQLAllocHandle.c][540]
		Entry:
			Handle Type = 3
			Input Handle = 0x7fd09c817c00
[ODBC][86305][1556636295.344866][SQLAllocHandle.c][1085]
		Exit:[SQL_SUCCESS]
			Output Handle = 0x7fd09c01ac00
[ODBC][86305][1556636295.345086][SQLPrepareW.c][165]
		Entry:
			Statement = 0x7fd09c01ac00
			SQL = [select [tag] from [app_telescope_monitoring]][length = 44]
[ODBC][86305][1556636295.345199][SQLPrepareW.c][346]
		Exit:[SQL_SUCCESS]
[ODBC][86305][1556636295.345411][SQLExecute.c][187]
		Entry:
			Statement = 0x7fd09c01ac00
[ODBC][86305][1556636295.349411][SQLExecute.c][357]
		Exit:[SQL_SUCCESS]
[ODBC][86305][1556636295.349595][SQLNumResultCols.c][156]
		Entry:
			Statement = 0x7fd09c01ac00
			Column Count = 0x7ffeec951cd6
[ODBC][86305][1556636295.349901][SQLNumResultCols.c][251]
		Exit:[SQL_SUCCESS]
			Count = 0x7ffeec951cd6 -> 1
[ODBC][86305][1556636295.350079][SQLRowCount.c][173]
		Entry:
			Statement = 0x7fd09c01ac00
			Row Count = 0x7ffeec951cc8
[ODBC][86305][1556636295.350358][SQLRowCount.c][247]
		Exit:[SQL_SUCCESS]
			Row Count = 0x7ffeec951cc8 -> 0
[ODBC][86305][1556636295.350499][SQLNumResultCols.c][156]
		Entry:
			Statement = 0x7fd09c01ac00
			Column Count = 0x7ffeec951d48
[ODBC][86305][1556636295.350855][SQLNumResultCols.c][251]
		Exit:[SQL_SUCCESS]
			Count = 0x7ffeec951d48 -> 1
[ODBC][86305][1556636295.350940][SQLRowCount.c][173]
		Entry:
			Statement = 0x7fd09c01ac00
			Row Count = 0x7ffeec951d48
[ODBC][86305][1556636295.351018][SQLRowCount.c][247]
		Exit:[SQL_SUCCESS]
			Row Count = 0x7ffeec951d48 -> 0
[ODBC][86305][1556636295.351106][SQLDescribeColW.c][209]
		Entry:
			Statement = 0x7fd09c01ac00
			Column Number = 1
			Column Name = 0x107c21380
			Buffer Length = 129
			Name Length = 0x7ffeec951c1e
			Data Type = 0x106bcc2b2
			Column Size = 0x106bcc2b8
			Decimal Digits = 0x106bcc2c8
			Nullable = 0x106bcc2ca
[ODBC][86305][1556636295.351255][SQLDescribeColW.c][467]
		Exit:[SQL_SUCCESS]                
			Column Name = [tag](unicode)                
			Data Type = 0x106bcc2b2 -> -9                
			Column Size = 0x106bcc2b8 -> 255                
			Decimal Digits = 0x106bcc2c8 -> 0                
			Nullable = 0x106bcc2ca -> 0
[ODBC][86305][1556636295.351394][SQLNumResultCols.c][156]
		Entry:
			Statement = 0x7fd09c01ac00
			Column Count = 0x7ffeec951be6
[ODBC][86305][1556636295.351504][SQLNumResultCols.c][251]
		Exit:[SQL_SUCCESS]
			Count = 0x7ffeec951be6 -> 1
[ODBC][86305][1556636295.351622][SQLFetchScroll.c][159]
		Entry:
			Statement = 0x7fd09c01ac00
			Fetch Orentation = 1
			Fetch Offset = 1
[ODBC][86305][1556636295.351815][SQLFetchScroll.c][356]
		Exit:[SQL_NO_DATA]
[ODBC][86305][1556636295.351940][SQLRowCount.c][173]
		Entry:
			Statement = 0x7fd09c01ac00
			Row Count = 0x7ffeec951c18
[ODBC][86305][1556636295.352016][SQLRowCount.c][247]
		Exit:[SQL_SUCCESS]
			Row Count = 0x7ffeec951c18 -> 0
[ODBC][86305][1556636295.352113][SQLFreeHandle.c][387]
		Entry:
			Handle Type = 3
			Input Handle = 0x7fd09c01ac00
[ODBC][86305][1556636295.356361][SQLFreeHandle.c][490]
		Exit:[SQL_SUCCESS]
[ODBC][86305][1556636295.410329][SQLAllocHandle.c][540]
		Entry:
			Handle Type = 3
			Input Handle = 0x7fd09c817c00
[ODBC][86305][1556636295.410455][SQLAllocHandle.c][1085]
		Exit:[SQL_SUCCESS]
			Output Handle = 0x7fd09c01ac00
[ODBC][86305][1556636295.416145][SQLPrepareW.c][165]
		Entry:
			Statement = 0x7fd09c01ac00
			SQL = [insert into [app_shopfloor_shifts] ([division_id], [cell_id], [submission_date], [shift], [no_production], [updated_at], [creat...][length = 163]
[ODBC][86305][1556636295.416265][SQLPrepareW.c][346]
		Exit:[SQL_SUCCESS]
[ODBC][86305][1556636295.416374][SQLBindParameter.c][217]
		Entry:
			Statement = 0x7fd09c01ac00
			Param Number = 1
			Param Type = 1
			C Type = -16 SQL_C_SLONG
			SQL Type = 4 SQL_INTEGER
			Col Def = 0
			Scale = 0
			Rgb Value = 0x1080cd8c0
			Value Max = 8
			StrLen Or Ind = 0x7fd09c825600
[ODBC][86305][1556636295.416454][SQLBindParameter.c][434]
		Exit:[SQL_SUCCESS]
[ODBC][86305][1556636295.416505][SQLBindParameter.c][217]
		Entry:
			Statement = 0x7fd09c01ac00
			Param Number = 2
			Param Type = 1
			C Type = -16 SQL_C_SLONG
			SQL Type = 4 SQL_INTEGER
			Col Def = 0
			Scale = 0
			Rgb Value = 0x1080cd280
			Value Max = 8
			StrLen Or Ind = 0x7fd09c825608
[ODBC][86305][1556636295.416556][SQLBindParameter.c][434]
		Exit:[SQL_SUCCESS]
[ODBC][86305][1556636295.416609][SQLBindParameter.c][217]
		Entry:
			Statement = 0x7fd09c01ac00
			Param Number = 3
			Param Type = 1
			C Type = -8 SQL_C_WCHAR
			SQL Type = -9 SQL_WVARCHAR
			Col Def = 4000
			Scale = 0
			Rgb Value = 0x107db6be8
			Value Max = 20
			StrLen Or Ind = 0x7fd09c825610
[ODBC][86305][1556636295.416654][SQLBindParameter.c][434]
		Exit:[SQL_SUCCESS]
[ODBC][86305][1556636295.416703][SQLBindParameter.c][217]
		Entry:
			Statement = 0x7fd09c01ac00
			Param Number = 4
			Param Type = 1
			C Type = -8 SQL_C_WCHAR
			SQL Type = -9 SQL_WVARCHAR
			Col Def = 4000
			Scale = 0
			Rgb Value = 0x10806ebd0
			Value Max = 10
			StrLen Or Ind = 0x7fd09c825618
[ODBC][86305][1556636295.416749][SQLBindParameter.c][434]
		Exit:[SQL_SUCCESS]
[ODBC][86305][1556636295.416807][SQLBindParameter.c][217]
		Entry:
			Statement = 0x7fd09c01ac00
			Param Number = 5
			Param Type = 1
			C Type = -16 SQL_C_SLONG
			SQL Type = 4 SQL_INTEGER
			Col Def = 0
			Scale = 0
			Rgb Value = 0x1080cd1e0
			Value Max = 8
			StrLen Or Ind = 0x7fd09c825620
[ODBC][86305][1556636295.416854][SQLBindParameter.c][434]
		Exit:[SQL_SUCCESS]
[ODBC][86305][1556636295.416900][SQLBindParameter.c][217]
		Entry:
			Statement = 0x7fd09c01ac00
			Param Number = 6
			Param Type = 1
			C Type = -8 SQL_C_WCHAR
			SQL Type = -9 SQL_WVARCHAR
			Col Def = 4000
			Scale = 0
			Rgb Value = 0x1080cd018
			Value Max = 46
			StrLen Or Ind = 0x7fd09c825628
[ODBC][86305][1556636295.416946][SQLBindParameter.c][434]
		Exit:[SQL_SUCCESS]
[ODBC][86305][1556636295.416994][SQLBindParameter.c][217]
		Entry:
			Statement = 0x7fd09c01ac00
			Param Number = 7
			Param Type = 1
			C Type = -8 SQL_C_WCHAR
			SQL Type = -9 SQL_WVARCHAR
			Col Def = 4000
			Scale = 0
			Rgb Value = 0x1080c9e28
			Value Max = 46
			StrLen Or Ind = 0x7fd09c825630
[ODBC][86305][1556636295.417097][SQLBindParameter.c][434]
		Exit:[SQL_SUCCESS]
[ODBC][86305][1556636295.417153][SQLExecute.c][187]
		Entry:
			Statement = 0x7fd09c01ac00
[ODBC][86305][1556636295.420371][SQLExecute.c][357]
		Exit:[SQL_SUCCESS]
[ODBC][86305][1556636295.420522][SQLNumResultCols.c][156]
		Entry:
			Statement = 0x7fd09c01ac00
			Column Count = 0x7ffeec951fe6
[ODBC][86305][1556636295.420622][SQLNumResultCols.c][251]
		Exit:[SQL_SUCCESS]
			Count = 0x7ffeec951fe6 -> 0
[ODBC][86305][1556636295.420679][SQLRowCount.c][173]
		Entry:
			Statement = 0x7fd09c01ac00
			Row Count = 0x7ffeec951fd8
[ODBC][86305][1556636295.420724][SQLRowCount.c][247]
		Exit:[SQL_SUCCESS]
			Row Count = 0x7ffeec951fd8 -> 1
[ODBC][86305][1556636295.420768][SQLNumResultCols.c][156]
		Entry:
			Statement = 0x7fd09c01ac00
			Column Count = 0x7ffeec952058
[ODBC][86305][1556636295.420812][SQLNumResultCols.c][251]
		Exit:[SQL_SUCCESS]
			Count = 0x7ffeec952058 -> 0
[ODBC][86305][1556636295.420853][SQLRowCount.c][173]
		Entry:
			Statement = 0x7fd09c01ac00
			Row Count = 0x7ffeec952058
[ODBC][86305][1556636295.420895][SQLRowCount.c][247]
		Exit:[SQL_SUCCESS]
			Row Count = 0x7ffeec952058 -> 1
[ODBC][86305][1556636295.420950][SQLFreeHandle.c][387]
		Entry:
			Handle Type = 3
			Input Handle = 0x7fd09c01ac00
[ODBC][86305][1556636295.426233][SQLFreeHandle.c][490]
		Exit:[SQL_SUCCESS]
[ODBC][86305][1556636295.427120][SQLAllocHandle.c][540]
		Entry:
			Handle Type = 3
			Input Handle = 0x7fd09c817c00
[ODBC][86305][1556636295.427238][SQLAllocHandle.c][1085]
		Exit:[SQL_SUCCESS]
			Output Handle = 0x7fd09c01ac00
[ODBC][86308][1556636303.063610][__handles.c][460]
		Exit:[SQL_SUCCESS]
			Environment = 0x7ffd3802ac00
[ODBC][86308][1556636303.063800][SQLSetEnvAttr.c][189]
		Entry:
			Environment = 0x7ffd3802ac00
			Attribute = SQL_ATTR_ODBC_VERSION
			Value = 0x3
			StrLen = -6
[ODBC][86308][1556636303.063967][SQLSetEnvAttr.c][381]
		Exit:[SQL_SUCCESS]
[ODBC][86308][1556636303.064076][SQLSetEnvAttr.c][189]
		Entry:
			Environment = 0x7ffd3802ac00
			Attribute = SQL_ATTR_CONNECTION_POOLING
			Value = 0x0
			StrLen = -5
[ODBC][86308][1556636303.064162][SQLSetEnvAttr.c][381]
		Exit:[SQL_SUCCESS]
[ODBC][86308][1556636303.064296][__handles.c][460]
		Exit:[SQL_SUCCESS]
			Environment = 0x7ffd38031000
[ODBC][86308][1556636303.064386][SQLSetEnvAttr.c][189]
		Entry:
			Environment = 0x7ffd38031000
			Attribute = SQL_ATTR_ODBC_VERSION
			Value = 0x3
			StrLen = -6
[ODBC][86308][1556636303.064506][SQLSetEnvAttr.c][381]
		Exit:[SQL_SUCCESS]
[ODBC][86308][1556636303.064622][SQLSetEnvAttr.c][189]
		Entry:
			Environment = 0x7ffd38031000
			Attribute = SQL_ATTR_CONNECTION_POOLING
			Value = 0x2
			StrLen = -5
[ODBC][86308][1556636303.064759][SQLSetEnvAttr.c][381]
		Exit:[SQL_SUCCESS]
[ODBC][86308][1556636303.079269][SQLFreeHandle.c][220]
		Entry:
			Handle Type = 1
			Input Handle = 0x7ffd3802ac00
[ODBC][86308][1556636303.079653][SQLFreeHandle.c][220]
		Entry:
			Handle Type = 1
			Input Handle = 0x7ffd38031000
[ODBC][86311][1556636303.321305][__handles.c][460]
		Exit:[SQL_SUCCESS]
			Environment = 0x7ff227846400
[ODBC][86311][1556636303.321435][SQLSetEnvAttr.c][189]
		Entry:
			Environment = 0x7ff227846400
			Attribute = SQL_ATTR_ODBC_VERSION
			Value = 0x3
			StrLen = -6
[ODBC][86311][1556636303.323035][SQLSetEnvAttr.c][381]
		Exit:[SQL_SUCCESS]
[ODBC][86311][1556636303.323311][SQLSetEnvAttr.c][189]
		Entry:
			Environment = 0x7ff227846400
			Attribute = SQL_ATTR_CONNECTION_POOLING
			Value = 0x0
			StrLen = -5
[ODBC][86311][1556636303.323411][SQLSetEnvAttr.c][381]
		Exit:[SQL_SUCCESS]
[ODBC][86311][1556636303.323572][__handles.c][460]
		Exit:[SQL_SUCCESS]
			Environment = 0x7ff22782fa00
[ODBC][86311][1556636303.323671][SQLSetEnvAttr.c][189]
		Entry:
			Environment = 0x7ff22782fa00
			Attribute = SQL_ATTR_ODBC_VERSION
			Value = 0x3
			StrLen = -6
[ODBC][86311][1556636303.323802][SQLSetEnvAttr.c][381]
		Exit:[SQL_SUCCESS]
[ODBC][86311][1556636303.323868][SQLSetEnvAttr.c][189]
		Entry:
			Environment = 0x7ff22782fa00
			Attribute = SQL_ATTR_CONNECTION_POOLING
			Value = 0x2
			StrLen = -5
[ODBC][86311][1556636303.324023][SQLSetEnvAttr.c][381]
		Exit:[SQL_SUCCESS]
[ODBC][86311][1556636303.324712][SQLFreeHandle.c][220]
		Entry:
			Handle Type = 1
			Input Handle = 0x7ff227846400
[ODBC][86311][1556636303.324795][SQLFreeHandle.c][220]
		Entry:
			Handle Type = 1
			Input Handle = 0x7ff22782fa00
[ODBC][86312][1556636303.510588][__handles.c][460]
		Exit:[SQL_SUCCESS]
			Environment = 0x7fe4e503f000
[ODBC][86312][1556636303.511803][SQLSetEnvAttr.c][189]
		Entry:
			Environment = 0x7fe4e503f000
			Attribute = SQL_ATTR_ODBC_VERSION
			Value = 0x3
			StrLen = -6
[ODBC][86312][1556636303.512215][SQLSetEnvAttr.c][381]
		Exit:[SQL_SUCCESS]
[ODBC][86312][1556636303.512347][SQLSetEnvAttr.c][189]
		Entry:
			Environment = 0x7fe4e503f000
			Attribute = SQL_ATTR_CONNECTION_POOLING
			Value = 0x0
			StrLen = -5
[ODBC][86312][1556636303.512434][SQLSetEnvAttr.c][381]
		Exit:[SQL_SUCCESS]
[ODBC][86312][1556636303.512577][__handles.c][460]
		Exit:[SQL_SUCCESS]
			Environment = 0x7fe4e5008400
[ODBC][86312][1556636303.512672][SQLSetEnvAttr.c][189]
		Entry:
			Environment = 0x7fe4e5008400
			Attribute = SQL_ATTR_ODBC_VERSION
			Value = 0x3
			StrLen = -6
[ODBC][86312][1556636303.512825][SQLSetEnvAttr.c][381]
		Exit:[SQL_SUCCESS]
[ODBC][86312][1556636303.512924][SQLSetEnvAttr.c][189]
		Entry:
			Environment = 0x7fe4e5008400
			Attribute = SQL_ATTR_CONNECTION_POOLING
			Value = 0x2
			StrLen = -5
[ODBC][86312][1556636303.513006][SQLSetEnvAttr.c][381]
		Exit:[SQL_SUCCESS]
[ODBC][85660][1556636306.279033][SQLFreeHandle.c][220]
		Entry:
			Handle Type = 1
			Input Handle = 0x7fd09c815c00
[ODBC][85660][1556636306.279306][SQLFreeHandle.c][220]
		Entry:
			Handle Type = 1
			Input Handle = 0x7fd09c802e00
[ODBC][86312][1556636327.825530][SQLFreeHandle.c][220]
		Entry:
			Handle Type = 1
			Input Handle = 0x7fe4e503f000
[ODBC][86312][1556636327.825684][SQLFreeHandle.c][220]
		Entry:
			Handle Type = 1
			Input Handle = 0x7fe4e5008400

from homebrew-mssql-release.

v-makouz avatar v-makouz commented on May 23, 2024

The ODBC driver sets the locale in SQLDriverConnect, and that was successful it's probably not the ODBC driver. I've alerted pdo_sqlsrv support, they should be able to take a look at this soon.

from homebrew-mssql-release.

yitam avatar yitam commented on May 23, 2024

hi @keithbrinks I remember you've reported a similar problem in issue 909. Any difference this time other than using a more recent pdo_sqlsrv driver?

from homebrew-mssql-release.

keithbrinks avatar keithbrinks commented on May 23, 2024

Hi @yitam,

There does not appear to have been any changes other than updating the drivers.

I know I reported at the end of that that things seemed to be working, but that ended up being premature. I can't recall the specifics, but I essentially gave up after that.

from homebrew-mssql-release.

v-makouz avatar v-makouz commented on May 23, 2024

Closing as this has been confirmed to be not the ODBC driver issue

from homebrew-mssql-release.

Related Issues (20)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.