MZ@ !L!This program cannot be run in DOS mode. $ 1=m_nm_nm_n#nm_nnm_nnm_nnm_nnm_nm^n)m_nnm_nnm_nnm_nRichm_nPEL O!  i%@@Hx`p8@ .text `.rdataST@@.data$NL@.rsrc`:@@.reloc$p<@BVW|$ GpPt?@Tt9FjWЃu)L$ QD$V jWҋL$ t T$ _^Ã_^̋L$A;th0Q3D$PPD$PQJыD$ ̋tu HQPYVh@xZ5hH|ZփZuhPփZ^̡ZVWtY=hTh\h`P׋|ZjSPVjhdV׃u NQV҃_^áZtM=jhpP׋ t4|ZjSPVjhtV׃uNQV҃_^_3^̡(Ul$0VhPԲPزu^](fF2F F ܲL$QjT$$RD$$EjMPD$(߇fu7WL$ j.QTtST$$RGWFӃF [_UD$PjL$Qh'R與fu |$YF L$ FFFUQRjD$GfHD$ j]P+fu@L$ Qfu0D$ jjT$RjjPfuL$N T$ jRӆD$ j Pنfu@L$ QÆfu0D$ jjT$RjjP蠆fuL$NT$ jR聆D$ jP臆fu@L$ Qqfu0D$ jjT$RjjPNfuL$NT$ jR/D$ jP5fu@L$ Qfu0D$ jjT$RjjPfuL$NT$ jR݅D$P^](S\$VWt.xZVP̲tuONQV҃_^[ËD$PFtt& xZWVQв tu VBVЃ_^[̅t=F=8th8PȲt ~uZhP3ËË hR3́dSU$pVVIJ=X|"hгQ^]2[dW~8ܲjSjgUWftjUh?C $|uNVL$ܲT$jjjjRD$$PjUWL$݀fNATtHN v3xRf9AwAT@;~9hQ_^]2[dËVBRD$ VPa ܲjjjjjL$0QjUmVfu _^][djUh|,B _^]2[d̃SUVW=ܲD$׋ ZD$PQj-VՃftjjhA _^][ËT$$D$L$RPD$4u ׋L$Qj誂VՃ_^]3[ËHh8RԲPز3ۃ;u ׋D$PjcVՃ_^]3[ËL$D$ 3҄‰NL$(^^$N ^4V ^8^^̃VD$PL$QL$,T$RT$,D$Phhl3QRt$0t$,t$(t$$t u3^ËD$;txX@uH;t9p t q#tSU-ܲWՋL$T$jD$PD$$jQN jRjPQD[W=׃ft V FHRQht _][^ՍT$ ؋F RPZS׃ft N VBQPhi _][^L$ QtT$ jRV u _][3^_][^ÃVD$PL$QL$,T$RT$,D$Ph h3QRt$0t$,t$(t$$t u3^ËD$;txX@uH;t9p t q#>tSU-ܲWՋL$T$jD$PD$$jQN jRjPQYW=׃ft V FHRQh< _][^ՍT$ ؋F RPaYS׃ft N VBQPh _][^L$ QtT$ jRVM u _][3^_][^Ã VD$T$RL$ D$PL$QL$4T$ RT$4D$Ph8#h3QRt$8t$4t$0t$u3^ËD$ ;txX@uH;t9p t q#tŋD$SUW=P׋L$@Q׃@ܲT$L$ WSjRV jD$0PjQR _][^ø D$ft5PGtkT$QRV| u _][3^ӋN D$PQ!PWՋT$V,ft F NQPRhx _][^á_][^̃SD$PD$$L$QL$$T$ Rh.h3PQ\$ \$(\$$tu[ËD$V;t xX@t3H;u39X u3 q#u^3[U-ܲWՋT$L$SSjRV jD$(PjQRZOW=׃ft F NQPRh _]^[ՋN ؍D$PQNS׃ft V FHRQhU _]^[T$RmtD$jPV u _]^3[_]^[̃VD$PD$$L$QL$$T$ Rhh0h3PQt$ t$(t$$tu3^ËD$;txX@uH;t9p t q#'tSU-ܲWՋT$L$jRV jD$ PjQRMW=׃ft F NQPRh, _][^ՋN ؍D$PQQMS׃ft V FHRQh _][^T$RtD$jPV= u _][3^_][^S\$t {X@tZhPP3[ËCuhhH{ uZhR3[ÃxuZhP3[Ã{ uhԼ ZQ3[ËD$ T$RhP t|$u[UVW3ܲ39t$~'΃fuS jjRKLG;|$|Uƃft#fdtK SBQPhp _^][á_^][̋D$L$PQ̋D$VPt$ t ~X@thPIFuZhhR3^Ã~ uZhP3^Ãxuh ZQ3^WD$ ܲjjT$RF jP0KW_ft^Ã|$t롤^̋D$ WP|$ t X@thPKGuZhhR_Ã uZhP_Ãxuh ZQ_ËD$ uh\P_SVPܲO jVjQJSf^[tW GHRQhB _3_̡h@SUVWhX@PԲPز3;|$~n ^ N$nnnnn F(F,n0F$ܲWSRjD$HL$QD$T$ft,GUPh| u NQV҃_^]3[9o$t_ܲ UD$G$PUQHT$Rft.OPQh uVBVЃ_^]3[Ë FPQVRPh_^][jh(xZD$wR$R2ÍIRR̋D$@@Tu=YthYPȲuøSUl$ VWth}tb33$r;u2st3:uv(Y:^u vA:Ft BlrZ_^][_^ R][SUVt$W3t>ul$u VJL$D$ PQ؃u _^]3[VShd t,jVU tG;uGWP| u SBSЃtu NQV҃tu GHWу_^]3[̋D$S2ۅtrWh$PtWVjWht3F@TtL$QVRu FHVу^u WBWЃ_[Ê[SUl$ VW؅t?u,u Wj`u u CHSу_^]3[SjVWuuۋVBVЃ_^]3[PjVjVUu NQV҃_^][́$$(SUVWPh44$H3ۃ\$,\$-\$1\$;tD$(D$ +$<;tD$(D$  ZD$(L$ \$4\$\$\$$ܲT$$RhD$tuHQP҃0Ou_^SՃ]̘=i$pi@øTø`ølø|øøøøøøøøøøøø$ø4øHøXødøpøøÐKiQi3i-i'ici]iWihhhhhi iiii!ih9i?iEiii ̘=l$køøøøøøøøøø ø0ø@øPøhø|øøøøøø ø(øHøhøøøøøøøøø ø0ø@øLø\øløxÍIkkkkkkkkkjkkkjkjjk kk#k)k/k5k;kkAkGkMkSkYk_kekkkqkwk}kkkk''''''''''' ''' '' ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' !"#$%&@@ @̋JVf0;~pt$v;N( fpHP ^Ãfp+pP ^WS{fσT$NJ;y,O=LZt0~,WP+F u2_Í?FFfV_ÉF ?FfV_ú+׹fNV^ _̋T$@;H ‰H Vq Wyff P f2qfp"IfH$[_ffH@ P @^Vq P f2qfp"IfH$\ffH@P @^WP~ ~ _WP~ W~ _WP~ ı~ F_SUl$V؋D$Wxxp T)R`ȃL$8t-q~D$ IR0FOuUj0V~+L$$ _^][Ë;}tLQ`ȅt-HT$43~T$ [0ANu.A;}T$T +2^0AOu_^][Ë+ŃP`ȃL$tPt-q/f0.ۃ~Sj0V*L$$ ~D$ R0FOu_^][QWjhP O SU-QՋW_RD$ՋKffVx ȉN3fN!; NfN +fщNfVPD$S]F [uu GHWу2_YFP@u+‰Fu WBWЃ_YQ $QWf-t4T$J;A0( $N fVFȃFNYúWfV~ ?WFF/+ȉNYWSf̱L$ Q;z0/SfFȱF ~ǃF~_ú+׹~fN^ FV_SUVt$FNWPF~PFPFPPQl$0PREPhӡ(ܲNV \$WQNRVD$(FPQK RPjEUQ'T$RC@u Zh@QP _^]2[ÃftS RPhd| _^]2[_^][Vt$~tT$BH0VW@Tt}tt4QR,|$ut _3^ÅyGxG;}WG_^Ë 4PVhR_^;Lt$D$PL$ QD$PFL$$QPRHyD$j`_^Ã|$u|$u;Fu _^P`1L$39|$~ESX VVL$ G;|$|[_^Ë@ PhR _^V LZWuLQVPY _^}3Ʌ~f=Zf9Xh~\nx(6Hlvf )-/ +10o 9Kw?:H$L&CB=<A45('6&<LZ0F^x2FZr 0@Pbx 2Lb~6zl^L2 jZ@. tV8*Not a buffer!updatehashlibshasha1snewhexdigestnewhexdigestpyodbc.CnxnInfoConnection object requiredAttempt to use a closed connection.connection string too longSQLSetConnectAttr(SQL_ATTR_LOGIN_TIMEOUT)A Unicode connection string was supplied but the driver does not have a Unicode connect functionSQLDriverConnectSQLAllocHandleSQLSetConnnectAttr(SQL_ATTR_AUTOCOMMIT)SQLSetConnnectAttr(SQL_ATTR_ACCESS_MODE)cnxn.new cnxn=%p hdbc=%d cnxn.clear cnxn=%p hdbc=%d ktuV%'xyRr')*\'W0FJw'MTQXIYq&'p"labcde'f!hg ij#k%$oKU1 sZ(] '[, ^v2_3-mn4.H`/'Invalid getinfo value: %dSQLGetInfocommitrollback%s: cnxn=%p hdbc=%d SQLEndTranCannot delete the autocommit attribute.SQLSetConnectAttrSQLGetInfoCannot delete the timeout attribute.Cannot set a negative timeout.SQLSetConnectAttriOcursorcloseexecutecommitrollbackgetinfoadd_output_converterclear_output_converters__enter____exit__searchescapeautocommitThe ODBC search pattern escape character, as returned by SQLGetInfo(SQL_SEARCH_PATTERN_ESCAPE). These are driver specific.pyodbc.ConnectionReturns True if the connection is in autocommit mode; False otherwise.timeoutThe timeout in seconds, zero means no timeout.Invalid cursor object.Attempt to use a closed cursor.Attempt to use a closed cursor.The cursor's connection has been closed.No results. Previous SQL was not a query.ODBC data type %d is not supported. Cannot read column %s.The cursor's connection was closed.The cursor's connection was closed.SQLDescribeColCol %d: type=%d colsize=%d (sOOiiiO)The cursor's connection was closed.The cursor's connection was closed.SQLDescribeColThe cursor's connection was closed.SQLColAttributeParams must be in a list, tuple, or RowSQLExecuteSQLExecDirectThe cursor's connection was closed.SQLExecDirectWSQLParamDataSQLParamDataSQLParamData() --> %d SQLPutDataSQLPutDataSQLPutData [%d] (%d) %s SQLPutDataSQLPutData [%d] (%d) %s SQLPutDataSQLPutDataSQLRowCountSQLRowCount: %d SQLNumResultColsSQLNumResultCols: %d The cursor's connection was closed.SQLRowCountexecute() takes at least 1 argument (0 given)The first argument to execute must be a string or unicode query.OOThe first argument to execute must be a string or unicode query.The second parameter to executemany must be a sequence.The second parameter to executemany must not be empty.The cursor's connection was closed.SQLFetch|ltablecatalogschematableType|ssssSQLTablesSQLNumResultColstablecatalogschemacolumn|ssssSQLColumnsSQLNumResultColstablecatalogschemauniquequicks|ssOOSQLStatisticsSQLNumResultColstablecatalogschemanullables|ssOSQLSpecialColumnsSQLNumResultColstablecatalogschemas|ssSQLPrimaryKeysSQLNumResultColstablecatalogschemaforeignTableforeignCatalogforeignSchema|ssssssSQLForeignKeysSQLNumResultCols|iSQLGetTypeInfoSQLNumResultColsSQLNumResultColsSQLRowCountprocedurecatalogschema|sssSQLProcedureColumnsSQLNumResultColsprocedurecatalogschema|sssSQLProceduresSQLNumResultColsiSQLFetchScrollrowcountdescriptionarraysizeconnectionCannot delete the noscan attributeSQLSetStmtAttr(SQL_ATTR_NOSCAN)noscanNOSCAN statement attrcloseexecuteexecutemanysetinputsizessetoutputsizefetchonefetchallfetchmanynextsettablescolumnsstatisticsrowIdColumnsrowVerColumnsprimaryKeysforeignKeysgetTypeInfoproceduresprocedureColumnsskippyodbc.CursorSQLAllocHandleSQLSetStmtAttr(SQL_ATTR_QUERY_TIMEOUT)cursor.new cnxn=%p hdbc=%d cursor=%p hstmt=%d datetime.datetime_CAPIlowercase0A000400022223242542HYT00HYT01The driver did not supply an error!PZXZ`ZdZhZlZpZtZ|ZHY000(Os)argsHY000In RaiseError(%s)! [%s] %s (%ld) (%s); [%s] %s (%ld)datetime.datetime_CAPISQLGetData(O)SQLGetDataOSQLGetDataSQLGetDataSQLGetDataSQLGetDataSQLGetDataSQLGetDataODBC SQL type %d is not yet supported. column-index=%zd type=%dHY106SQL_UNKNOWN_TYPESQL_CHARSQL_VARCHARSQL_LONGVARCHARSQL_NUMERICSQL_DECIMALSQL_INTEGERSQL_SMALLINTSQL_FLOATSQL_REALSQL_DOUBLESQL_DATETIMESQL_WCHARSQL_WVARCHARSQL_WLONGVARCHARSQL_TYPE_DATESQL_TYPE_TIMESQL_TYPE_TIMESTAMPSQL_SS_TIME2SQL_SS_XMLSQL_BINARYSQL_VARBINARYSQL_LONGVARBINARYunknownSQL_C_CHARSQL_C_WCHARSQL_C_LONGSQL_C_SHORTSQL_C_FLOATSQL_C_DOUBLESQL_C_NUMERICSQL_C_DEFAULTSQL_C_DATESQL_C_TIMESQL_C_TIMESTAMPSQL_C_TYPE_DATESQL_C_TYPE_TIMESQL_C_TYPE_TIMESTAMPSQL_C_INTERVAL_YEARSQL_C_INTERVAL_MONTHSQL_C_INTERVAL_DAYSQL_C_INTERVAL_HOURSQL_C_INTERVAL_MINUTESQL_C_INTERVAL_SECONDSQL_C_INTERVAL_YEAR_TO_MONTHSQL_C_INTERVAL_DAY_TO_HOURSQL_C_INTERVAL_DAY_TO_MINUTESQL_C_INTERVAL_DAY_TO_SECONDSQL_C_INTERVAL_HOUR_TO_MINUTESQL_C_INTERVAL_HOUR_TO_SECONDSQL_C_INTERVAL_MINUTE_TO_SECONDSQL_C_BINARYSQL_C_BITSQL_C_SBIGINTSQL_C_UBIGINTSQL_C_TINYINTSQL_C_SLONGSQL_C_SSHORTSQL_C_STINYINTSQL_C_ULONGSQL_C_USHORTSQL_C_UTINYINTSQL_C_GUIDunknownas_tupleInvalid parameter type. param-index=%zd param-type=%sHY105BIND: param=%d ValueType=%d (%s) ParameterType=%d (%s) ColumnSize=%d DecimalDigits=%d BufferLength=%d *pcb=%d The cursor's connection was closed.SQLBindParameterSQLPrepareSQLNumParamsSQLPrepare(%s) SQLNumParamsThe cursor's connection was closed.The SQL contains %d parameter markers, but %d parameters were suppliedpyodbc.NullParamdatetime.datetime_CAPI$@%02x Errorpyodbc.ErrorException raised in case a method or database API was used which is not supported by the database, e.g. requesting a .rollback() on a connection that does not support transaction or has transactions turned off.pyodbc.NotSupportedErrorNotSupportedErrorpyodbc.ProgrammingErrorProgrammingErrorException raised for programming errors, e.g. table not found or already exists, syntax error in the SQL statement, wrong number of parameters specified, etc.Exception raised when the database encounters an internal error, e.g. the cursor is not valid anymore, the transaction is out of sync, etc.pyodbc.InternalErrorInternalErrorIntegrityErrorpyodbc.OperationalErrorOperationalErrorException raised when the relational integrity of the database is affected, e.g. a foreign key check fails.pyodbc.IntegrityErrorpyodbc.DataErrorException raised for errors that are related to the database's operation and not necessarily under the control of the programmer, e.g. an unexpected disconnect occurs, the data source name is not found, a transaction could not be processed, a memory allocation error occurred during processing, etc.DataErrorException raised for errors that are due to problems with the processed data like division by zero, numeric value out of range, etc.Exception raised for errors that are related to the database.pyodbc.DatabaseErrorDatabaseErrorException raised for errors that are related to the database interface rather than the database itself.pyodbc.InterfaceErrorInterfaceErrorException raised for important warnings like data truncations while inserting, etc.pyodbc.WarningWarningException that is the base class of all other error exceptions. You can use this to catch all errors with one single 'except' statement.localelocaleconvdecimal_pointdatetimedatetime.datetime_CAPIdecimalUnable to import decimalDecimalUnable to import decimal.Decimal.poolingUnable to set SQL_ATTR_CONNECTION_POOLING attribute.Can't initialize module pyodbc. SQLAllocEnv failed.Unable to set SQL_ATTR_ODBC_VERSION attribute.useruidpasswordpwdhostserverfunction takes at most 1 non-keyword argumentargument 1 must be a string or unicode objectDictionary items passed to connect must be stringsautocommitansiunicode_resultstimeoutreadonlyno connection information was passedSQLDataSourcesOTimeFromTicks requires a number.SOFTWARE\ODBC\ODBCINST.INI\ODBC DriversUnable to access the driver list in the registry. error=%ldRegEnumKeyEx failed with error %ld connectTimeFromTicksDateFromTicksTimestampFromTicksdataSourcesdriversSQL_UNKNOWN_TYPESQL_CHARSQL_VARCHARSQL_LONGVARCHARSQL_WCHARSQL_WVARCHARSQL_WLONGVARCHARSQL_DECIMALSQL_NUMERICSQL_SMALLINTSQL_INTEGERSQL_REALSQL_FLOATSQL_DOUBLESQL_BITSQL_TINYINTSQL_BIGINTSQL_BINARYSQL_VARBINARYSQL_LONGVARBINARYSQL_TYPE_DATESQL_TYPE_TIMESQL_TYPE_TIMESTAMPSQL_SS_TIME2SQL_SS_XMLSQL_INTERVAL_MONTHSQL_INTERVAL_YEARSQL_INTERVAL_YEAR_TO_MONTHSQL_INTERVAL_DAYSQL_INTERVAL_HOURSQL_INTERVAL_MINUTESQL_INTERVAL_SECONDSQL_INTERVAL_DAY_TO_HOURSQL_INTERVAL_DAY_TO_MINUTESQL_INTERVAL_DAY_TO_SECONDSQL_INTERVAL_HOUR_TO_MINUTESQL_INTERVAL_HOUR_TO_SECONDSQL_INTERVAL_MINUTE_TO_SECONDSQL_GUIDSQL_NULLABLESQL_NO_NULLSSQL_NULLABLE_UNKNOWNSQL_SCOPE_CURROWSQL_SCOPE_TRANSACTIONSQL_SCOPE_SESSIONSQL_PC_UNKNOWNSQL_PC_NOT_PSEUDOSQL_PC_PSEUDOSQL_ACCESSIBLE_PROCEDURESSQL_ACCESSIBLE_TABLESSQL_ACTIVE_ENVIRONMENTSSQL_AGGREGATE_FUNCTIONSSQL_ALTER_DOMAINSQL_ALTER_TABLESQL_ASYNC_MODESQL_BATCH_ROW_COUNTSQL_BATCH_SUPPORTSQL_BOOKMARK_PERSISTENCESQL_CATALOG_LOCATIONSQL_CATALOG_NAMESQL_CATALOG_NAME_SEPARATORSQL_CATALOG_TERMSQL_CATALOG_USAGESQL_COLLATION_SEQSQL_COLUMN_ALIASSQL_CONCAT_NULL_BEHAVIORSQL_CONVERT_FUNCTIONSSQL_CONVERT_VARCHARSQL_CORRELATION_NAMESQL_CREATE_ASSERTIONSQL_CREATE_CHARACTER_SETSQL_CREATE_COLLATIONSQL_CREATE_DOMAINSQL_CREATE_SCHEMASQL_CREATE_TABLESQL_CREATE_TRANSLATIONSQL_CREATE_VIEWSQL_CURSOR_COMMIT_BEHAVIORSQL_CURSOR_ROLLBACK_BEHAVIORSQL_DATABASE_NAMESQL_DATA_SOURCE_NAMESQL_DATA_SOURCE_READ_ONLYSQL_DATETIME_LITERALSSQL_DBMS_NAMESQL_DBMS_VERSQL_DDL_INDEXSQL_DEFAULT_TXN_ISOLATIONSQL_DESCRIBE_PARAMETERSQL_DM_VERSQL_DRIVER_HDESCSQL_DRIVER_HENVSQL_DRIVER_HLIBSQL_DRIVER_HSTMTSQL_DRIVER_NAMESQL_DRIVER_ODBC_VERSQL_DRIVER_VERSQL_DROP_ASSERTIONSQL_DROP_CHARACTER_SETSQL_DROP_COLLATIONSQL_DROP_DOMAINSQL_DROP_SCHEMASQL_DROP_TABLESQL_DROP_TRANSLATIONSQL_DROP_VIEWSQL_DYNAMIC_CURSOR_ATTRIBUTES1SQL_DYNAMIC_CURSOR_ATTRIBUTES2SQL_EXPRESSIONS_IN_ORDERBYSQL_FILE_USAGESQL_FORWARD_ONLY_CURSOR_ATTRIBUTES1SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES2SQL_GETDATA_EXTENSIONSSQL_GROUP_BYSQL_IDENTIFIER_CASESQL_IDENTIFIER_QUOTE_CHARSQL_INDEX_KEYWORDSSQL_INFO_SCHEMA_VIEWSSQL_INSERT_STATEMENTSQL_INTEGRITYSQL_KEYSET_CURSOR_ATTRIBUTES1SQL_KEYSET_CURSOR_ATTRIBUTES2SQL_KEYWORDSSQL_LIKE_ESCAPE_CLAUSESQL_MAX_ASYNC_CONCURRENT_STATEMENTSSQL_MAX_BINARY_LITERAL_LENSQL_MAX_CATALOG_NAME_LENSQL_MAX_CHAR_LITERAL_LENSQL_MAX_COLUMNS_IN_GROUP_BYSQL_MAX_COLUMNS_IN_INDEXSQL_MAX_COLUMNS_IN_ORDER_BYSQL_MAX_COLUMNS_IN_SELECTSQL_MAX_COLUMNS_IN_TABLESQL_MAX_COLUMN_NAME_LENSQL_MAX_CONCURRENT_ACTIVITIESSQL_MAX_CURSOR_NAME_LENSQL_MAX_DRIVER_CONNECTIONSSQL_MAX_IDENTIFIER_LENSQL_MAX_INDEX_SIZESQL_MAX_PROCEDURE_NAME_LENSQL_MAX_ROW_SIZESQL_MAX_ROW_SIZE_INCLUDES_LONGSQL_MAX_SCHEMA_NAME_LENSQL_MAX_STATEMENT_LENSQL_MAX_TABLES_IN_SELECTSQL_MAX_TABLE_NAME_LENSQL_MAX_USER_NAME_LENSQL_MULTIPLE_ACTIVE_TXNSQL_MULT_RESULT_SETSSQL_NEED_LONG_DATA_LENSQL_NON_NULLABLE_COLUMNSSQL_NULL_COLLATIONSQL_NUMERIC_FUNCTIONSSQL_ODBC_INTERFACE_CONFORMANCESQL_ODBC_VERSQL_OJ_CAPABILITIESSQL_ORDER_BY_COLUMNS_IN_SELECTSQL_PARAM_ARRAY_ROW_COUNTSSQL_PARAM_ARRAY_SELECTSSQL_PARAM_TYPE_UNKNOWNSQL_PARAM_INPUTSQL_PARAM_INPUT_OUTPUTSQL_PARAM_OUTPUTSQL_RETURN_VALUESQL_RESULT_COLSQL_PROCEDURESSQL_PROCEDURE_TERMSQL_QUOTED_IDENTIFIER_CASESQL_ROW_UPDATESSQL_SCHEMA_TERMSQL_SCHEMA_USAGESQL_SCROLL_OPTIONSSQL_SEARCH_PATTERN_ESCAPESQL_SERVER_NAMESQL_SPECIAL_CHARACTERSSQL_SQL92_DATETIME_FUNCTIONSSQL_SQL92_FOREIGN_KEY_DELETE_RULESQL_SQL92_FOREIGN_KEY_UPDATE_RULESQL_SQL92_GRANTSQL_SQL92_NUMERIC_VALUE_FUNCTIONSSQL_SQL92_PREDICATESSQL_SQL92_RELATIONAL_JOIN_OPERATORSSQL_SQL92_REVOKESQL_SQL92_ROW_VALUE_CONSTRUCTORSQL_SQL92_STRING_FUNCTIONSSQL_SQL92_VALUE_EXPRESSIONSSQL_SQL_CONFORMANCESQL_STANDARD_CLI_CONFORMANCESQL_STATIC_CURSOR_ATTRIBUTES1SQL_STATIC_CURSOR_ATTRIBUTES2SQL_STRING_FUNCTIONSSQL_SUBQUERIESSQL_SYSTEM_FUNCTIONSSQL_TABLE_TERMSQL_TIMEDATE_ADD_INTERVALSSQL_TIMEDATE_DIFF_INTERVALSSQL_TIMEDATE_FUNCTIONSSQL_TXN_CAPABLESQL_TXN_ISOLATION_OPTIONSQL_UNIONSQL_USER_NAMESQL_XOPEN_CLI_YEAR  ,<HXlx[$\4]HfXhdfxekghijlm0nLohpq(8L\xtuV%'xyR8rP'd)*\'W0FJ0Hd|0Hdw|'L 4DMXh| @\TlQX  8PI`Yq&'p"$l@a\bxcde8'Pfd!hg ij#k0%H$`oxKU1 sZ$@Xp(] '0[D,Xt ^8Ptv4T2l_|3-mn4.H `,/<'__doc__pyodbc3.0.6-beta02versionthreadsafety2.0apilevelqmarkparamstylepoolinglowercaseConnectionCursorRowDateTimeTimestampDATETIMESTRINGNUMBERROWIDBINARYBinaryBinaryNullUNICODE_SIZESQLWCHAR_SIZEtuple index out of rangeRow assignment index out of range()row index out of range index=%d len=%drow indices must be integers, not %.200scursor_descriptionpyodbc.RowCannot convert from Unicode %zd to SQLWCHAR. Value is too large.Unicode requiredCannot convert from SQLWCHAR %zd to Unicode. Value is too large.sqlwchar=%ld pch=%p len=%ld owns=%d %02x %c Z@[HpZy^*>@ˡޡ4tNhT$">Xh~\nx(6Hlvf )-/ +10o 9Kw?:H$L&CB=<A45('6&<LZ0F^x2FZr 0@Pbx 2Lb~6zl^L2 jZ@. tV8*ODBC32.dll0RegCloseKeyQRegEnumValueA`RegOpenKeyExAADVAPI32.dllPyErr_SetStringPyExc_TypeErrorPyBuffer_TypeDPyImport_ImportModulePyString_FromStringPyDict_NewPyObject_CallMethodObjArgs_PyObject_CallMethod_SizeTPyEval_RestoreThreadPyEval_SaveThreadPyObject_InitPyObject_MallocPyDict_SetItem}PyDict_GetItemPyType_IsSubtypebPySequence_Size_Py_NoneStructPyObject_FreeRPyInt_FromLongPyLong_FromUnsignedLongWPyInt_GetMaxPyString_FromStringAndSize_Py_ZeroStruct_Py_TrueStructr_PyArg_ParseTuple_SizeTPyObject_IsTruePyExc_ValueErrorPyErr_OccurredLPyInt_AsLongPyErr_NoMemoryPyTuple_GetItem PyObject_GetAttrString.PyUnicode_TypePyBool_TypePyLong_TypeXPyInt_TypePyFloat_TypePyString_TypePyDict_SetItemString_Py_BuildValue_SizeTPyTuple_Neww_PyByteArray_empty_string&PyByteArray_TypePyTuple_SizeWPySequence_GetItem`PyList_AppendfPyList_Newq_PyArg_ParseTupleAndKeywords_SizeT>PyCapsule_ImportPyErr_SetObjectKPyInstance_TypePyEval_CallObjectWithKeywordsPyString_FromFormatVPyTuple_SetItemzPyString_ConcatAndDelPyString_FromFormat$PyByteArray_ResizePyUnicodeUCS2_ResizePyUnicodeUCS2_AsUnicodePyUnicodeUCS2_FromUnicode"PyByteArray_FromStringAndSize_PyString_Resize_PyObject_CallFunction_SizeTzPyLong_FromLongLongPyLong_FromUnsignedLongLongPyFloat_FromDoublepPyLong_AsLongLongPyFloat_AsDoublePyByteArray_AsString%PyByteArray_Size_PyObject_NewPyType_Ready_PyUnicodeUCS2_ToUppercasePyString_Size~PyDict_GetItemStringPyErr_ClearPyExc_RuntimeError@Py_FatalErrornPyLong_AsLongPyNumber_LongPyErr_FormatPyNumber_CheckPyModule_AddObjectPyErr_NewExceptionPyModule_AddIntConstantPyModule_AddStringConstantVPy_InitModule4PyDict_Next%PyObject_StrPyDict_SizePyUnicodeUCS2_FromObjectPyExc_ExceptionPyObject_GenericGetAttrPyNumber_AsSsize_tPyObject_RichCompareBoolPyExc_IndexError PyObject_GenericSetAttrPyObject_ReprPyObject_RichCompare_Py_NotImplementedStructnPySlice_GetIndicesExpPySlice_TypePyUnicodeUCS2_FromWideCharPyUnicodeUCS2_GetMaxpython27.dllstrchrfatoimemcpyfreemallocE_strlwrreallocmemmovememsettoupperprintf!_localtime64MSVCR100.dllA_stricmp4_malloc_crt_encoded_null_initterm_initterm_e_amsg_exit1__CppXcptFilterS__clean_type_info_names_internal_unlock[__dllonexit#_lock_onexit!_except_handler4_common_crt_debugger_hookEncodePointerDecodePointerInterlockedExchangeSleepInterlockedCompareExchangeIsProcessorFeaturePresentQueryPerformanceCounterGetTickCountGetCurrentThreadIdGetCurrentProcessIdyGetSystemTimeAsFileTimeTerminateProcessGetCurrentProcessUnhandledExceptionFilterSetUnhandledExceptionFilterIsDebuggerPresentKERNEL32.dll Orhlp@}pyodbc.pydinitpyodbcConnection objects manage connections to the database. Each manages a single ODBC HDBC.clear_output_converters() --> None Remove all output converter functions.Close the connection now (rather than whenever __del__ is called). The connection will be unusable from this point forward and a ProgrammingError will be raised if any operation is attempted with the connection. The same applies to all cursor objects trying to use the connection. Note that closing a connection without committing the changes first will cause an implicit rollback to be performed.Return a new Cursor object using the connection.execute(sql, [params]) --> Cursor Create a new Cursor object, call its execute method, and return it. See Cursor.execute for more details. This is a convenience method that is not part of the DB API. Since a new Cursor is allocated by each call, this should not be used if more than one SQL statement needs to be executed.Commit any pending transaction to the database.Causes the the database to roll back to the start of any pending transaction.getinfo(type) --> str | int | bool Calls SQLGetInfo, passing `type`, and returns the result formatted as a Python object.add_output_converter(sqltype, func) --> None Register an output converter function that will be called whenever a value with the given SQL type is read from the database. sqltype The integer SQL type value to convert, which can be one of the defined standard constants (e.g. pyodbc.SQL_VARCHAR) or a database-specific value (e.g. -151 for the SQL Server 2008 geometry data type). func The converter function which will be called with a single parameter, the value, and should return the converted value. If the value is NULL, the parameter will be None. Otherwise it will be a Python string.__enter__() -> self.__exit__(*excinfo) -> None. Closes the connection. x @ȺԺpܺ!( "0"$@4лp @8Close the cursor now (rather than whenever __del__ is called). The cursor will be unusable from this point forward; a ProgrammingError exception will be raised if any operation is attempted with the cursor.C.execute(sql, [params]) --> Cursor Prepare and execute a database query or command. Parameters may be provided as a sequence (as specified by the DB API) or simply passed in one after another (non-standard): cursor.execute(sql, (param1, param2)) or cursor.execute(sql, param1, param2) HPX`C.tables(table=None, catalog=None, schema=None, tableType=None) --> self Executes SQLTables and creates a results set of tables defined in the data source. The table, catalog, and schema interpret the '_' and '%' characters as wildcards. The escape character is driver specific, so use `Connection.searchescape`. Each row fetched has the following columns: 0) table_cat: The catalog name. 1) table_schem: The schema name. 2) table_name: The table name. 3) table_type: One of 'TABLE', 'VIEW', SYSTEM TABLE', 'GLOBAL TEMPORARY' 'LOCAL TEMPORARY', 'ALIAS', 'SYNONYM', or a data source-specific type name.C.columns(table=None, catalog=None, schema=None, column=None) Creates a results set of column names in specified tables by executing the ODBC SQLColumns function. Each row fetched has the following columns: 0) table_cat 1) table_schem 2) table_name 3) column_name 4) data_type 5) type_name 6) column_size 7) buffer_length 8) decimal_digits 9) num_prec_radix 10) nullable 11) remarks 12) column_def 13) sql_data_type 14) sql_datetime_sub 15) char_octet_length 16) ordinal_position 17) is_nullableC.statistics(catalog=None, schema=None, unique=False, quick=True) --> self Creates a results set of statistics about a single table and the indexes associated with the table by executing SQLStatistics. unique If True, only unique indexes are retured. Otherwise all indexes are returned. quick If True, CARDINALITY and PAGES are returned only if they are readily available from the server Each row fetched has the following columns: 0) table_cat 1) table_schem 2) table_name 3) non_unique 4) index_qualifier 5) index_name 6) type 7) ordinal_position 8) column_name 9) asc_or_desc 10) cardinality 11) pages 12) filter_conditionC.rowIdColumns(table, catalog=None, schema=None, nullable=True) --> Executes SQLSpecialColumns with SQL_BEST_ROWID which creates a result set of columns that uniquely identify a row Each row fetched has the following columns: 0) scope 1) column_name 2) data_type 3) type_name 4) column_size 5) buffer_length 6) decimal_digits 7) pseudo_columnC.rowIdColumns(table, catalog=None, schema=None, nullable=True) --> self Executes SQLSpecialColumns with SQL_ROWVER which creates a result set of columns that are automatically updated when any value in the row is updated. Each row fetched has the following columns: 0) scope 1) column_name 2) data_type 3) type_name 4) column_size 5) buffer_length 6) decimal_digits 7) pseudo_column08@HC.primaryKeys(table, catalog=None, schema=None) --> self Creates a results set of column names that make up the primary key for a table by executing the SQLPrimaryKeys function. Each row fetched has the following columns: 0) table_cat 1) table_schem 2) table_name 3) column_name 4) key_seq 5) pk_nameC.foreignKeys(table=None, catalog=None, schema=None, foreignTable=None, foreignCatalog=None, foreignSchema=None) --> self Executes the SQLForeignKeys function and creates a results set of column names that are foreign keys in the specified table (columns in the specified table that refer to primary keys in other tables) or foreign keys in other tables that refer to the primary key in the specified table. Each row fetched has the following columns: 0) pktable_cat 1) pktable_schem 2) pktable_name 3) pkcolumn_name 4) fktable_cat 5) fktable_schem 6) fktable_name 7) fkcolumn_name 8) key_seq 9) update_rule 10) delete_rule 11) fk_name 12) pk_name 13) deferrabilityC.getTypeInfo(sqlType=None) --> self Executes SQLGetTypeInfo a creates a result set with information about the specified data type or all data types supported by the ODBC driver if not specified. Each row fetched has the following columns: 0) type_name 1) data_type 2) column_size 3) literal_prefix 4) literal_suffix 5) create_params 6) nullable 7) case_sensitive 8) searchable 9) unsigned_attribute 10) fixed_prec_scale 11) auto_unique_value 12) local_type_name 13) minimum_scale 14) maximum_scale 15) sql_data_type 16) sql_datetime_sub 17) num_prec_radix 18) interval_precisionC.procedureColumns(procedure=None, catalog=None, schema=None) --> self Executes SQLProcedureColumns and creates a result set of information about stored procedure columns and results. 0) procedure_cat 1) procedure_schem 2) procedure_name 3) column_name 4) column_type 5) data_type 6) type_name 7) column_size 8) buffer_length 9) decimal_digits 10) num_prec_radix 11) nullable 12) remarks 13) column_def 14) sql_data_type 15) sql_datetime_sub 16) char_octet_length 17) ordinal_position 18) is_nullableC.procedures(procedure=None, catalog=None, schema=None) --> self Executes SQLProcedures and creates a result set of information about the procedures in the data source. Each row fetched has the following columns: 0) procedure_cat 1) procedure_schem 2) procedure_name 3) num_input_params 4) num_output_params 5) num_result_sets 6) remarks 7) procedure_typeskip(count) --> None Skips the next `count` records by calling SQLFetchScroll with SQL_FETCH_NEXT. For convenience, skip(0) is accepted and will do nothing.This read-only attribute specifies the number of rows the last DML statement (INSERT, UPDATE, DELETE) affected. This is set to -1 for SELECT statements.This read-only attribute is a sequence of 7-item sequences. Each of these sequences contains information describing one result column: (name, type_code, display_size, internal_size, precision, scale, null_ok). All values except name, type_code, and internal_size are None. The type_code entry will be the type object used to create values for that column (e.g. `str` or `datetime.datetime`). This attribute will be None for operations that do not return rows or if the cursor has not had an operation invoked via the execute() method yet. The type_code can be interpreted by comparing it to the Type Objects defined in the DB API and defined the pyodbc module: Date, Time, Timestamp, Binary, STRING, BINARY, NUMBER, and DATETIME.This read/write attribute specifies the number of rows to fetch at a time with fetchmany(). It defaults to 1 meaning to fetch a single row at a time.This read-only attribute return a reference to the Connection object on which the cursor was created. The attribute simplifies writing polymorph code in multi-connection environments.,,18$1D(4P05NOexecutemany(sql, seq_of_params) --> Cursor | count | None Prepare a database query or command and then execute it against all parameter sequences found in the sequence seq_of_params. Only the result of the final execution is returned. See `execute` for a description of parameter passing the return value.nextset() --> True | None Jumps to the next resultset if the last sql has multiple resultset.Returns True if there is a next resultset otherwise None.Ignored.fetchone() --> Row | None Fetch the next row of a query result set, returning a single Row instance, or None when no more data is available. A ProgrammingError exception is raised if the previous call to execute() did not produce any result set or no call was issued yet.fetchmany(size=cursor.arraysize) --> list of Rows Fetch the next set of rows of a query result, returning a list of Row instances. An empty list is returned when no more rows are available. The number of rows to fetch per call is specified by the parameter. If it is not given, the cursor's arraysize determines the number of rows to be fetched. The method should try to fetch as many rows as indicated by the size parameter. If this is not possible due to the specified number of rows not being available, fewer rows may be returned. A ProgrammingError exception is raised if the previous call to execute() did not produce any result set or no call was issued yet.fetchmany() --> list of Rows Fetch all remaining rows of a query result, returning them as a list of Rows. An empty list is returned if there are no more rows. A ProgrammingError exception is raised if the previous call to execute() did not produce any result set or no call was issued yet.*576NP8NP8;`8<x9=<  I7(>0@x8pA DDP#TD$dDX&pPF'|G* L.J,Mx0Cursor objects represent a database cursor, which is used to manage the context of a fetch operation. Cursors created from the same connection are not isolated, i.e., any changes done to the database by a cursor are immediately visible by the other cursors. Cursors created from different connections are isolated. Cursors implement the iterator protocol, so results can be iterated: cursor.execute(sql) for row in cursor: print row[0]4P+> ;0;@=5T6 A database module for accessing databases via ODBC. This module conforms to the DB API 2.0 specification while providing non-standard convenience features. Only standard Python data types are used so additional DLLs are not required. Static Variables: version The module version string. Official builds will have a version in the format `major.minor.revision`, such as 2.1.7. Beta versions will have -beta appended, such as 2.1.8-beta03. (This would be a build before the official 2.1.8 release.) Some special test builds will have a test name (the git branch name) prepended, such as fixissue90-2.1.8-beta03. apilevel The string constant '2.0' indicating this module supports DB API level 2.0. lowercase A Boolean that controls whether column names in result rows are lowercased. This can be changed any time and affects queries executed after the change. The default is False. This can be useful when database columns have inconsistent capitalization. pooling A Boolean indicating whether connection pooling is enabled. This is a global (HENV) setting, so it can only be modified before the first connection is made. The default is True, which enables ODBC connection pooling. threadsafety The integer 1, indicating that threads may share the module but not connections. Note that connections and cursors may be used by different threads, just not at the same time. qmark The string constant 'qmark' to indicate parameters are identified using question marks..connect(str, autocommit=False, ansi=False, timeout=0, **kwargs) --> Connection Accepts an ODBC connection string and returns a new Connection object. The connection string will be passed to SQLDriverConnect, so a DSN connection can be created using: cnxn = pyodbc.connect('DSN=DataSourceName;UID=user;PWD=password') To connect without requiring a DSN, specify the driver and connection information: DRIVER={SQL Server};SERVER=localhost;DATABASE=testdb;UID=user;PWD=password Note the use of braces when a value contains spaces. Refer to SQLDriverConnect documentation or the documentation of your ODBC driver for details. The connection string can be passed as the string `str`, as a list of keywords, or a combination of the two. Any keywords except autocommit, ansi, and timeout (see below) are simply added to the connection string. connect('server=localhost;user=me') connect(server='localhost', user='me') connect('server=localhost', user='me') The DB API recommends the keywords 'user', 'password', and 'host', but these are not valid ODBC keywords, so these will be converted to 'uid', 'pwd', and 'server'. Special Keywords The following specal keywords are processed by pyodbc and are not added to the connection string. (If you must use these in your connection string, pass them as a string, not as keywords.) autocommit If False or zero, the default, transactions are created automatically as defined in the DB API 2. If True or non-zero, the connection is put into ODBC autocommit mode and statements are committed automatically. ansi By default, pyodbc first attempts to connect using the Unicode version of SQLDriverConnectW. If the driver returns IM001 indicating it does not support the Unicode version, the ANSI version is tried. Any other SQLSTATE is turned into an exception. Setting ansi to true skips the Unicode attempt and only connects using the ANSI version. This is useful for drivers that return the wrong SQLSTATE (or if pyodbc is out of date and should support other SQLSTATEs). timeout An integer login timeout in seconds, used to set the SQL_ATTR_LOGIN_TIMEOUT attribute of the connection. The default is 0 which means the database's default timeout, if any, is used. TimeFromTicks(ticks) --> datetime.time Returns a time object initialized from the given ticks value (number of seconds since the epoch; see the documentation of the standard Python time module for details).DateFromTicks(ticks) --> datetime.date Returns a date object initialized from the given ticks value (number of seconds since the epoch; see the documentation of the standard Python time module for details).TimestampFromTicks(ticks) --> datetime.datetime Returns a datetime object initialized from the given ticks value (number of seconds since the epoch; see the documentation of the standard Python time module for detailsdataSources() -> { DSN : Description } Returns a dictionary mapping available DSNs to their descriptions.drivers() -> [ driver, ... ] Returns a list of installed drivers`HPQR~xS@ShpZZhZZZZZZ,ZZZZ@ZZPZZpTZZ@The Cursor.description sequence from the Cursor that created this row.,URow objects are sequence objects that hold query results. They are similar to tuples in that they cannot be resized and new attributes cannot be added, but individual elements can be replaced. This allows data to be "fixed up" after being fetched. (For example, datetimes may be replaced by those with time zones attached.) row[0] = row[0].replace(tzinfo=timezone) print row[0] Additionally, individual values can be optionally be accessed or replaced by name. Non-alphanumeric characters are replaced with an underscore. cursor.execute("select customer_id, [Name With Spaces] from tmp") row = cursor.fetchone() print row.customer_id, row.Name_With_Spaces If using this non-standard feature, it is often convenient to specifiy the name using the SQL 'as' keyword: cursor.execute("select count(*) as total from tmp") row = cursor.fetchone() print row.total@hUU`VГUN@D0 HX`Z PAPADDINGXXPADDINGPADDINGXXPADDINGPADDINGXXPADDINGPADDINGXXPADDINGPADDINGXXPADi0p0w0~00000000011!1-12171<1Q1\1c11111111112&2]2m284c4k444555(5-545C5J5Q5w55555555 6n6u6|66667)7>7X77777U888l999::L::::;;;;;; >8>?>F>X>g>>>>?2?P??????? 4000'0A0Y00<1111111D2J2c2j2s2222222233$3+3N3S3Z3p3u3|333333334 444'434>4F4N4V4d4x4|44444444444555646m6666617H7N7b778 8*889/9N9`9e9}999:*:::::::;;;;%;5;<;\;r;;;<@>G>M>p>>>>>>> ?0?4?p?w?~??????0`0C0K0f00000 141:1V111@2N2k22222333a33334 4M4m444 5G5b5555 66"6'6.6B6G6N6a6f6m66666667&757:7A7W7\7c7x7}77777777788"83888?8^88888 99;9[9m999 ::":J:h:w:::<;C;H;O;b;p;u;|;;;;;;;;;;;<<"<)<<> >>#>*><>B>I>a>l>>>>>?K?k??@!0&0@0]00001t1z11111262^2222(3M3R3d3~33334V4 55#5@5m5555{66666+7K7778"8P8l8888<9R9h9999k:::::::3;_;;;< >>%>8>?>L>>>>>>> ???$?+?=?B?I?[?a?h?~???????P0000.030:0M0S0Z0p0w0~000000011-1`11111122S2Y2a2222222233e3v33333333 4m4t44455D5P5~556,6a6666667F7b7m7~77#8J88C9P9s9y9999F:::N;_;g;;;<< <<<%=T=o=====>$>+>W>>>>>>>>>???Z?u?|????` 0(0C0J0g00000011?1h1111111&2C2Z2a2222233333&44444444444446!6;6L6]6666667,7p77777778 8F8X8_8s8888888889 9999"9(9.949:9@9F9L9R9X9^9d9j9p9t9x9|999999999999999999999:::::;; ;;;;$;*;0;6;<;B;H;N;T;Z;`;f;l;r;x;~;;;;;;;;;;;;;;;;;;;;;;;;<<< <<<<< <$<(<,<0<4<8<<<@>?'?o??p[0000j1\2}23"3`3s3x3333544444A5G5V5\5d5o5u5z5H66 7h777778%8;8j8888'9b999999:.:A:T:Y:::::;;< >>!>'>.>7>j>p>{>>>>>>>??3?P?w????|'0.0C0P0W0^0p0000001k1z111111112F2222222222222223333>3T3_3u33333333344%4;4F4e4r4444444G5L5R5X5^5d5j5p5v5|55555555555666;6@6I6P6X6]6e6j6r6x6~66666666666666667 77 7)777@7N7V7a7g7o7w7}7777777777777z899:::::::::;!;2;;;;;<??0000q0000!1(1/111111122%2Y223333444:4]4i444444444555 5:5D5X5555555 6j6r6y666666"7R7|777777788"8*8F8`888888?9L9o99999:::":(:.:4:::@:F:L:R:X:^:d:j:p:v:|::::::::::::::::::::::;;B;R;n;<<<'>,>1>8>E>V>s>>>>?`??????????00'0d0i000H1M1_1}11112 22!2>2222222222(303<3B3H3N3T3d3t3z3333333333333333333444%4*4:4?4E4K4a4h4p444444444333$3(3,666666666666666777tP:X:`:h:p:x:::::::::::::::::;;;; ;(;0;8;@;H;P;X;`;h;p;x;;;;;;;;;;;;;;;;;<<<< <(<0<8<@>>> >(>0>8>@>H>P>X>`>h>p>x>>>>>>>>>>>>>>>>>???? ?(?0?8?@?H?P?X?`?h?p?x?????????????????@0000 0(00080@0H0P0X0`0h0p0x0000343t3x3333333p 088<8D8H8L8T8X8\8d8h8l8t8x8|8888888888888888888889999999D9P9999;<<< <000083<3@3D3H3D6H6L6P6777`:d:h:l:p:t:>>>0h0l0p056666(6,6<6T6X6\6`6@=D=L=P=T=\=`=d=l=p=t=|=========================>> >>>> >$>,>0>4><>@>D>L>P>T>\>`>d>l>p>t>|>@(d0p00000001,1777777P0444<4@4D4L4P4T4\4`4d4l4p4t4|44444444444444444444444444555 55555 5$5(5,5054585<5@5D5H5L5P5T5X5\5`5d5h5t5|555555999999999: