|
| ODBC |
UserPreferences |
| serious-code.net | RecentChanges | ±â¼úÀÚ·á | ¸µÅ© | TitleIndex | ºí·Î±× |
| ¼Ó¼º | ŸÀÔ | °¡´ÉÇÑ °ª | ÀÇ¹Ì |
|---|---|---|---|
| SQL_ATTR_CONNECTION_POOLING | UINT | SQL_CP_OFF SQL_CP_ONE_PER_DRIVER SQL_CP_ONE_PER_HENV | Ä¿³Ø¼Ç Ç®¸µ on/off |
| SQL_ATTR_CP_MATCH | UINT | SQL_CP_STRICT_MATCH SQL_CP_RELAXED_MATCH | Ä¿³Ø¼Ç Ç®¸µ ¼³Á¤ |
| SQL_ATTR_ODBC_VERSION | UINT | SQL_OV_ODBC3 SQL_OV_ODBC2 | µå¶óÀ̹ö ¼³Á¤ |
| SQL_ATTR_OUTPUT_NTS | UINT | SQL_TRUE SQL_FALSE | ¹®ÀÚ¿ Ãë±Þ ¹æ¹ý ¼³Á¤ |
| ¼Ó¼º | ŸÀÔ | °¡´ÉÇÑ °ª | ÀÇ¹Ì | ¼³Á¤ °¡´É ½ÃÁ¡ |
|---|---|---|---|---|
| SQL_ATTR_ACCESS_MODE | UINT | SQL_MODE_READ_ONLY SQL_MODE_READ_WRITE | Àбâ, ¾²±â | Either |
| SQL_ATTR_ASYNC_ENABLE | UINT | SQL_ASYNC_ENABLE_OFF SQL_ASYNC_ENABLE_ON | ºñµ¿±â ¸ðµå | Either |
| SQL_ATTR_AUTOCOMMIT | UINT | SQL_AUTOCOMMIT_OFF SQL_AUTOCOMMIT_ON | ÀÚµ¿ Ä¿¹Ô | Either |
| SQL_ATTR_CONNECTION_DEAD | UINT | SQL_CD_TRUE SQL_CD_FALSE | Ä¿³Ø¼Ç ALIVE ¿©ºÎ | After |
| SQL_ATTR_CONNECTION_TIMEOUT | UINT | ÃÊ | Äõ¸® ÈÄ ±â´Ù¸± ½Ã°£, 0 == INFINITE | Either |
| SQL_ATTR_CURRENT_CATALOG | STRING | µ¥ÀÌÅͺ£À̽º À̸§ | ÇöÀç ÀÛ¾÷ ÁßÀÎ µ¥ÀÌÅͺ£À̽º | Either |
| SQL_ATTR_LOGIN_TIMEOUT | UINT | ÃÊ | ·Î±×ÀÎ ¼º°ø/½ÇÆÐ¶§±îÁö ±â´Ù¸± ½Ã°£, 0 == INFINITE | Before |
| SQL_ATTR_METADATA_ID | UINT | SQL_TRUE SQL_FALSE | ´ë¼Ò¹®ÀÚ ±¸º°. À̿ܿ¡µµ ¹º°¡ ÀÖ´Ù. | Either |
| SQL_ATTR_ODBC_CURSORS | UINT | SQL_CUR_USE_IF_NEEDED SQL_CUR_USE_ODBC SQL_CUR_USE_DRIVER | Ä¿¼ Á¾·ù ¼³Á¤ | Before |
| SQL_ATTR_PACKET_SIZE | UINT | ¹ÙÀÌÆ® Å©±â | ³×Æ®¿öÅ©¸¦ ÅëÇØ ¿À°¡´Â ÆÐŶ Å©±â | Before |
| SQL_ATTR_QUIET_MODE | UINT | 32ºñÆ® À©µµ¿ì ÇÚµé | NULLÀÌ¸é ´ëÈâ Ç¥½ÃÇÏÁö ¾Ê´Â´Ù. | Either |
| SQL_ATTR_TRACE | UINT | SQL_OPT_TRACE_OFF SQL_OPT_TRACE_ON | Æ®·¹À̽º ¿©ºÎ | Either |
| SQL_ATTR_TRACEFILE | STRING | ÆÄÀÏ À̸§ | Æ®·¹À̽º ÆÄÀÏ À̸§ | Either |
| SQL_ATTR_TRANSLATE_LIB | STRING | ÆÄÀÏ À̸§ | ¾Æ ¸ô¶ó | After |
| SQL_ATTR_TRANSLATE_OPTION | UINT | 32ºñÆ® Ç÷¡±× | ¾Æ ¸ô¶ó | After |
| SQL_ATTR_TXN_ISOLATION | UINT | 32ºñÆ® ºñÆ® ¸¶½ºÅ©. SQL_TXN_ISOLATION_OPTIONS Âü°í | Æ®·£Àè¼Ç ¶ô ·¹º§ | Either |
| ¼Ó¼º | ŸÀÔ | °¡´ÉÇÑ °ª | ÀÇ¹Ì |
|---|---|---|---|
| SQL_ATTR_APP_PARAM_DESC | UINT | APD¿¡ ´ëÇÑ ÇÚµé, SQL_NULL_DESC | APD°¡ ¹¹Áö? |
| SQL_ATTR_APP_ROW_DESC | UINT | ARD¿¡ ´ëÇÑ ÇÚµé, SQL_NULL_DESC | ARD°¡ ¹¹Áö? |
| SQL_ATTR_ASYNC_ENABLE | UINT | SQL_ASYNC_ENABLE_OFF SQL_ASYNC_ENABLE_ON | ºñµ¿±â ó¸® ¼³Á¤ |
| SQL_ATTR_CONCURRENCY | UINT | SQL_CONCUR_READ_ONLY SQL_CONCUR_LOCK SQL_CONCUR_ROWVER SQL_CONCUR_VALUES | ¶ô ¼³Á¤ |
| SQL_ATTR_CURSOR_SCROLLABLE | UINT | SQL_NONSCROLLABLE SQL_SCROLLABLE | Ä¿¼ ½ºÅ©·Ñ ¼³Á¤ |
| SQL_ATTR_CURSOR_SENSITIVITY | UINT | SQL_UNSPECIFIED SQL_INSENSITIVE SQL_SENSITIVE | °á°ú¸¦ ´Ù¸¥ Ä¿¼¿Í °øÀ¯Çϴ°¡? |
| SQL_ATTR_CURSOR_TYPE | UINT | SQL_CURSOR_FORWARD_ONLY SQL_CURSOR_STATIC SQL_CURSOR_KEYSET_DRIVEN SQL_CURSOR_DYNAMIC | Ä¿¼ Á¾·ù ¼³Á¤ |
| SQL_ATTR_ENABLE_AUTO_IPD | UINT | SQL_FALSE SQL_TRUE | ? |
| SQL_ATTR_FETCH_BOOKMARK_PTR | UINT | Æ÷ÀÎÅÍ | ÀÌÁø ºÏ¸¶Å©¿¡ ´ëÇÑ °ªÀ̶ó´Âµ¥, ÀÌ°Ç ¶Ç ¹¹Áö? |
| SQL_ATTR_IMP_PARAM_DESC | UINT | IPD¿¡ ´ëÇÑ ÇÚµé | IPD°¡ ¹¹Áö? |
| SQL_ATTR_IMP_ROW_DESC | UINT | IRD¿¡ ´ëÇÑ ÇÚµé | IRD°¡ ¹¹Áö? |
| SQL_ATTR_KEYSET_SIZE | UINT | ÇàÀÇ ¼ö | Ű¼Â ±â¹Ý Ä¿¼¿¡¼ ´Ù·ê ÇàÀÇ ¼ö |
| SQL_ATTR_MAX_LENGTH | UINT | ¹ÙÀÌÆ® ±æÀÌ | °á°ú¼Â ¾ÈÀÇ ¹®ÀÚ¿ ȤÀº ¹ÙÀ̳ʸ® Ä÷³ÀÇ ÃÖ´ë ±æÀÌ |
| SQL_ATTR_MAX_ROWS | UINT | ÇàÀÇ ¼ö | °á°ú¼ÂÀÇ ÃÖ´ë Çà ¼ö |
| SQL_ATTR_METADATA_ID | UINT | SQL_TRUE SQL_FALSE | ´ë¼Ò¹®ÀÚ ±¸º° ¿©ºÎ. À̿ܿ¡µµ ¹º°¡ ÀÖ´Ù. |
| SQL_ATTR_NOSCAN | UINT | SQL_NOSCAN_OFF SQL_NOSCAN_ON | À̽ºÄÉÀÌÇÁ ¹®ÀÚ °Ë»ö ¿©ºÎ |
| SQL_ATTR_PARAM_BIND_OFFSET_PTR | UINT* | Æ÷ÀÎÅÍ ¿É¼Â º¯¼ö¿¡ ´ëÇÑ Æ÷ÀÎÅÍ | µ¿Àû ÆÄ¶ó¹ÌÅÍ ¹ÙÀεù ½Ã¿¡ ´õÇÏ´Â °ªÀ̶ó´Âµ¥ ¹ºÁö ¸ð¸£°Ú´Ù. |
| SQL_ATTR_PARAM_BIND_TYPE | UINT | SQL_PARAM_BIND_BY_COLUMN or ±¸Á¶Ã¼ÀÇ Å©±â | |
| SQL_ATTR_PARAM_OPERATION_PTR | USINT* | SQL_PARAM_PROCEED, SQL_PARAM_IGNORE °ªÀ¸·Î ÀÌ·ç¾îÁø ¹è¿¿¡ ´ëÇÑ Æ÷ÀÎÅÍ | |
| SQL_ATTR_PARAM_STATUS_PTR | USINT* | ¹è¿ÀÇ Æ÷ÀÎÅÍ | Äõ¸® ½ÇÇà °á°ú¸¦ ¹Þ¾Æ¿À±â À§ÇÑ ¹è¿ |
| SQL_ATTR_PARAMS_PROCESSED_PTR | UINT* | ¹è¿ÀÇ Æ÷ÀÎÅÍ | ¸® ½ÇÇà °á°ú¸¦ ¹Þ¾Æ¿À±â À§ÇÑ ¹è¿ |
| SQL_ATTR_PARAMSET_SIZE | UINT | ÇÑ ÆÄ¶ó¹ÌÅÍ¿¡ µé¾îÀÖ´Â °ªÀÇ ¼ýÀÚ | ¹è¿À» ¹ÙÀεùÇϱâ À§ÇØ ¼³Á¤ÇÏ´Â °ª |
| SQL_ATTR_QUERY_TIMEOUT | UINT | ÃÊ | Äõ¸®¸¦ ¼öÇàÇÏ°í °á°ú¼ÂÀ» ±â´Ù¸± ½Ã°£, 0 == INFINITE |
| SQL_ATTR_RETRIEVE_DATA | UINT | SQL_RD_ON SQL_RD_OFF | Ä¿¼°¡ ¿òÁ÷ÀÌ¸é µ¥ÀÌÅ͸¦ ¹Ù·Î °¡Á®¿À´ÂÁö ¿©ºÎ |
| SQL_ATTR_ROW_ARRAY_SIZE | UINT | ÇàÀÇ ¼ö | °á°ú¼ÂÀ» ÆäÄ¡ÇÒ ¶§¸¶´Ù °¡Á®¿Ã ÇàÀÇ ¼ö |
| SQL_ATTR_ROW_BIND_OFFSET_PTR | UINT* | ? | ? |
| SQL_ATTR_ROW_BIND_TYPE | UINT | ? | ? |
| SQL_ATTR_ROW_NUMBER | UINT | Çà ¹øÈ£ | ÇöÀç ÇàÀÌ Àüü °á°ú¼Â¿¡¼ Â÷ÁöÇÏ´Â ¹øÈ£ |
| SQL_ATTR_ROW_OPERATION_PTR | USINT* | ? | ? |
| SQL_ATTR_ROW_STATUS_PTR | USINT* | ||
| SQL_ATTR_ROWS_FETCHED_PTR | UINT* | Çà °¹¼ö¸¦ Áý¾î³ÖÀ» º¯¼öÀÇ Æ÷ÀÎÅÍ | °á°ú¼ÂÀ» °¡Á®¿Ã ¶§¸¶´Ù ¾ÈÀÇ Çà ¼ýÀÚ¸¦ Áý¾î³ÖÀ» º¯¼ö ¼³Á¤ |
| SQL_ATTR_SIMULATE_CURSOR | UINT | SQL_SC_NON_UNIQUE SQL_SC_TRY_UNIQUE | Positioned update and delete statements? |
| SQL_ATTR_USE_BOOKMARKS | UINT | SQL_UB_OFF SQL_UB_VARIABLE | ºÏ¸¶Å© »ç¿ë ¿©ºÎ |
SELECT ID, BLOB_COLUMN, INT_COLUMN FROM SomeTable -- ERROR SELECT ID, INT_COLUMN, BLOB_COLUMN FROM SomeTable -- OKÀÚ¼¼ÇÑ »çÇ×Àº
connection-string ::= empty-string[;] | attribute[;] | attribute; connection-string
empty-string ::=
attribute ::= attribute-keyword=attribute-value | DRIVER=[{]attribute-value[}]
attribute-keyword ::= DSN | UID | PWD
| driver-defined-attribute-keyword
attribute-value ::= character-string
driver-defined-attribute-keyword ::= identifier
SQL Server DRIVER=SQL Server;SERVER=myserver;DATABASE=testdb;Trusted_Connection=Yes DRIVER=SQL Server;SERVER=myserver;DATABASE=testdb;UID=testuser;PWD=testpwdFile DSN
FILEDSN=C:\sample.dsn
DRIVER = SQL Server UID = Larry DATABASE = MyDB
// Statement Çڵ鿡´Ù°¡ »ç¿ëÇÒ Ä¿¼ÀÇ Å¸ÀÔ°ú Çѹø¿¡ °¡Á®¿Ã ÇàÀÇ °¹¼ö¸¦ ¼³Á¤ÇÑ´Ù. SQLSetStmtAttr(hStmt, SQL_ATTR_ROW_ARRAY_SIZE, (SQLPOINTER)1, 0); SQLSetStmtAttr(hStmt, SQL_ATTR_CURSOR_SCROLLABLE, (SQLPOINTER)SQL_SCROLLABLE, 0); ... // SQLFetchScroll ÇÔ¼ö¸¦ ÅëÇØ °á°ú¼ÂÀ» °¡Á®¿Â´Ù. SQLFetchScroll(hStmt, SQL_FETCH_NEXT, 0); SQLFetchScroll(hStmt, SQL_FETCH_PRIOR, 0);
SQLSetEnvAttr(
hEnv,
SQL_ATTR_CONNECTION_POOLING,
ULongToPtr(SQL_CP_ONE_PER_HENV or SQL_CP_ONE_PER_DRIVER),
SQL_IS_UINTEGER
);