Comments (6)
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.
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.
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.
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.
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.
Closing as this has been confirmed to be not the ODBC driver issue
from homebrew-mssql-release.
Related Issues (20)
- Problems installing msodbcsql17 and mssql-tools HOT 3
- Error trying to run homebrew-mssql formula in mac OS Big Sur (M1) HOT 4
- I had the same error.
- Could not connect to Azure SQL Database on version 17.8.1.1 HOT 1
- My mac cannot connect to SQL Server on Windows Server 2012 R2 with Microsoft ODBC Driver 17 for SQL Server. HOT 6
- Cannot tap microsoft/mssql-release: invalid syntax in tap! HOT 3
- My Mac(m1) cannot install Microsoft ODBC 18 HOT 2
- Cannot install/update Microsoft ODBC 18 on macOS 12 HOT 2
- File not found error for MS ODBC SQL 13 on MacOS Catalina HOT 4
- Download link for msodbcsql18 seems......down? HOT 2
- This repo is missing important files
- Codesign the drivers for use within Microsoft HOT 1
- Can't connect to the server HOT 10
- Silent installs no longer possible HOT 6
- [request] Add install option as alternative to ACCEPT_EULA envvar HOT 2
- This repo is missing a LICENSE file
- weird behavior on Mac M1 when using msodbcsql18 HOT 2
- I can't connect to SQL Server (MacBook Pro M1 Pro) HOT 4
- MSodbcSQL18 is not supported on Macos 14 HOT 11
- Can't open lib ODBC Driver 18 for SQL Server / Rstudio / Mac OS HOT 5
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
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.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from homebrew-mssql-release.