Hi,
I get below errormeassage when SELECTING a LONGTEXT field in ASP. When
changing the field back to VARCHAR everything goes fine.
Error message ...
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[TCX][MyODBC]Can't create/write to file '\\sql7_0.ism' (Errcode: 2)
/dgh002m.asp, line 296
Hope somebody have some ideas.
The tracelog from ODBC driver is attached below. The related coloum is
"kdghniv2.Knv2beskr"
Thanks and best regards
Peter
ODBC trace log ...
| | >mysql_option
| | | enter: option: 0
| | <mysql_option
| | info: MyODBC Version 2.50.22 option_flag: 4 client_flag: 64
| <get_client_flag
| >mysql_real_connect
| | enter: host: db: dbdgh001 user: pwr
| | info: Server name: '.'. Named Pipe: MySQL
| | >_mymalloc
| | | enter: Size: 8192
| | | exit: ptr: 1b63648
| | <_mymalloc
| | packet: Memory: 1b63648 Bytes: 10 51 46 50 50 46 50 50 0 2
| | info: mysql protocol version 10, server=10
| | >my_multi_malloc
| | | >_mymalloc
| | | | enter: Size: 56
| | | | exit: ptr: 1b70e28
| | | <_mymalloc
| | <my_multi_malloc
| | info: Server version = '3.22.22' capabilites: 44
| | info: user: pwr
| | >_mymalloc
| | | enter: Size: 9
| | | exit: ptr: 1b71138
| | <_mymalloc
| | exit: Mysql handler: 14b5364
| <mysql_real_connect
| >_mymalloc
| | enter: Size: 11
| | exit: ptr: 1b71188
| <_mymalloc
| >_mymalloc
| | enter: Size: 9
| | exit: ptr: 1b711d8
| <_mymalloc
| >_mymalloc
| | enter: Size: 1
| | exit: ptr: 1b71228
| <_mymalloc
| >_mymalloc
| | enter: Size: 4
| | exit: ptr: 1b71278
| <_mymalloc
| >_mymalloc
| | enter: Size: 1
| | exit: ptr: 1b712c8
| <_mymalloc
<SQLDriverConnect
>SQLError
| enter: szErrorMsg: 15720a0
<SQLError
>SQLGetFunctions
| enter: fFunction: 0
<SQLGetFunctions
>SQLGetInfo
| enter: fInfoType: 23
<SQLGetInfo
>SQLGetInfo
| enter: fInfoType: 24
<SQLGetInfo
>SQLGetInfo
| enter: fInfoType: 79
<SQLGetInfo
>SQLGetInfo
| enter: fInfoType: 83
<SQLGetInfo
>SQLGetInfo
| enter: fInfoType: 78
<SQLGetInfo
>SQLGetInfo
| enter: fInfoType: 81
<SQLGetInfo
>SQLGetInfo
| enter: fInfoType: 72
<SQLGetInfo
>SQLGetInfo
| enter: fInfoType: 82
<SQLGetInfo
>SQLGetInfo
| enter: fInfoType: 44
<SQLGetInfo
>SQLGetInfo
| enter: fInfoType: 43
<SQLGetInfo
>SQLGetInfo
| enter: fInfoType: 79
<SQLGetInfo
>SQLGetInfo
| enter: fInfoType: 8
<SQLGetInfo
>SQLGetInfo
| enter: fInfoType: 80
<SQLGetInfo
>SQLGetInfo
| enter: fInfoType: 78
<SQLGetInfo
>SQLGetInfo
| enter: fInfoType: 79
<SQLGetInfo
>SQLGetInfo
| enter: fInfoType: 8
<SQLGetInfo
>SQLGetInfo
| enter: fInfoType: 80
<SQLGetInfo
>SQLGetInfo
| enter: fInfoType: 78
<SQLGetInfo
>SQLGetInfo
| enter: fInfoType: 79
<SQLGetInfo
>SQLGetInfo
| enter: fInfoType: 8
<SQLGetInfo
>SQLGetInfo
| enter: fInfoType: 80
<SQLGetInfo
>SQLGetInfo
| enter: fInfoType: 78
<SQLGetInfo
>SQLGetInfo
| enter: fInfoType: 8
<SQLGetInfo
>SQLGetInfo
| enter: fInfoType: 80
<SQLGetInfo
>SQLGetInfo
| enter: fInfoType: 111
<SQLGetInfo
>SQLGetInfo
| enter: fInfoType: 16
<SQLGetInfo
>SQLGetInfo
| enter: fInfoType: 23
<SQLGetInfo
>SQLGetInfo
| enter: fInfoType: 24
<SQLGetInfo
>SQLGetInfo
| enter: fInfoType: 46
<SQLGetInfo
>SQLSetConnectOption
| enter: Option: 1 Param: 0
<SQLSetConnectOption
>set_stmt_option
| enter: Option: 1 Param: 0
<set_stmt_option
>SQLSetConnectOption
| enter: Option: 0 Param: 0
<SQLSetConnectOption
>set_stmt_option
| enter: Option: 0 Param: 0
| info: Option value is ignored
<set_stmt_option
>SQLGetInfo
| enter: fInfoType: 6
<SQLGetInfo
>SQLGetInfo
| enter: fInfoType: 6
<SQLGetInfo
>SQLGetInfo
| enter: fInfoType: 6
<SQLGetInfo
>SQLGetInfo
| enter: fInfoType: 79
<SQLGetInfo
>SQLGetInfo
| enter: fInfoType: 1
<SQLGetInfo
>SQLGetConnectOption
| enter: Option: 109 Param: 25357156
<SQLGetConnectOption
>SQLGetInfo
| enter: fInfoType: 26
<SQLGetInfo
>SQLAllocStmt
| >init_dynamic_array
| | >my_malloc
| | | my: Size: 960 MyFlags: 16
| | | exit: ptr: 1b65678
| | <my_malloc
| <init_dynamic_array
<SQLAllocStmt
>SQLGetInfo
| enter: fInfoType: 36
<SQLGetInfo
>SQLGetInfo
| enter: fInfoType: 36
<SQLGetInfo
>SQLGetStmtOption
<SQLGetStmtOption
>get_stmt_options
| enter: Option: 6
| info: This may be wrong: Change your application to use ODBC Manger
cursors or add 128 or 256 to your Option flag!
<get_stmt_options
>SQLGetStmtOption
<SQLGetStmtOption
>get_stmt_options
| enter: Option: 7
<get_stmt_options
>SQLGetConnectOption
| enter: Option: 108 Param: 25358276
<SQLGetConnectOption
>SQLSetStmtOption
<SQLSetStmtOption
>set_stmt_option
| enter: Option: 0 Param: 30
| info: Option value is ignored
<set_stmt_option
>SQLSetStmtOption
<SQLSetStmtOption
>set_stmt_option
| enter: Option: 7 Param: 1
| info: Option value is ignored
<set_stmt_option
>SQLExecDirect
| >my_SQLPrepare
| | >_mymalloc
| | | enter: Size: 705
| | | exit: ptr: 1b65a88
| | <_mymalloc
| | enter: Query: SELECT kdghniv2.Knv2bet AS EXPR3, kdghniv2.Knv2sogtxt AS
EXPR2, kdghniv2.Knv2nv1bet AS EXPR16, kdghniv2.Knv2nv3bet AS EXPR4,
kdghniv2.Knv2bskfil AS EXPR5, kdghniv2.Knv2overskr AS EXPR7,
kdghniv2.Knv2beskr AS EXPR6, kdghkat.Kkatbet AS EXPR1, kdghkat.Kkatkub AS
EXPR17, kdghkat.Kkatstartdato AS EXPR10, kdghkat.Kkatforlob AS EXPR11,
kdghkat.Kkatdltmax AS EXPR12, kdghkat.Kkatdltrsv AS EXPR13, kdghkub.Kkubnavn
AS EXPR15, kdghkat.Kkatnv2 AS EXPR16 FROM (kdghniv2 LEFT JOIN kdghkat ON
kdghniv2.Knv2bet = kdghkat.Kkatnv2) LEFT JOIN kdghkub ON kdghkat.Kkatkub =
kdghkub.Kkubbet WHERE ((kdghniv2.Knv2nv1bet='kstyp1')) HAVING EXPR2 LIKE
'%%' OR EXPR6 LIKE '%%' ORDER BY kdghkat.Kkatnv2, kdghkat.Kkatstartdato ASC
| | exit: Parameter count: 0
| <my_SQLPrepare
<SQLExecDirect
>SQLExecute
| enter: stmt: 14b5dd8
| >SQLFreeStmt
| | enter: stmt: 14b5dd8 option: 1000
| | >mysql_free_result
| | | enter: mysql_res: 0
| | <mysql_free_result
| <SQLFreeStmt
<SQLExecute
>do_query
| >mysql_real_query
| | enter: handle: 14b5364
| | query: Query = "SELECT kdghniv2.Knv2bet AS EXPR3, kdghniv2.Knv2sogtxt AS
EXPR2, kdghniv2.Knv2nv1bet AS EXPR16, kdghniv2.Knv2nv3bet AS EXPR4,
kdghniv2.Knv2bskfil AS EXPR5, kdghniv2.Knv2overskr AS EXPR7,
kdghniv2.Knv2beskr AS EXPR6, kdghkat.Kkatbet AS EXPR1, kdghkat.Kkatkub AS
EXPR17, kdghkat.Kkatstartdato AS EXPR10, kdghkat.Kkatforlob AS EXPR11,
kdghkat.Kkatdltmax AS EXPR12, kdghkat.Kkatdltrsv AS EXPR13, kdghkub.Kkubnavn
AS EXPR15, kdghkat.Kkatnv2 AS EXPR16 FROM (kdghniv2 LEFT JOIN kdghkat ON
kdghniv2.Knv2bet = kdghkat.Kkatnv2) LEFT JOIN kdghkub ON kdghkat.Kkatkub =
kdghkub.Kkubbet WHERE ((kdghniv2.Knv2nv1bet='kstyp1')) HAVING EXPR2 LIKE
'%%' OR EXPR6 LIKE '%%' ORDER BY kdghkat.Kkatnv2, kdghkat.Kkatstartdato ASC"
| | error: Got error: 1 (Can't create/write to file '\\sql7_0.ism' (Errcode:
2))
| <mysql_real_query
| error: Message: Can't create/write to file '\\sql7_0.ism' (Errcode: 2)
| >translate_error
| <translate_error
<do_query
>SQLError
| enter: szErrorMsg: 15720a0
| error: Message: Can't create/write to file '\\sql7_0.ism' (Errcode: 2)
<SQLError
>SQLError
| enter: szErrorMsg: 15720a0
<SQLError
>SQLError
| enter: szErrorMsg: 15720a0
<SQLError
>SQLFreeStmt
| enter: stmt: 14b5dd8 option: 0
| >mysql_free_result
| | enter: mysql_res: 0
| <mysql_free_result
<SQLFreeStmt
>SQLFreeStmt
| enter: stmt: 14b5dd8 option: 0
| >mysql_free_result
| | enter: mysql_res: 0
| <mysql_free_result
<SQLFreeStmt
>SQLFreeStmt
| enter: stmt: 14b5dd8 option: 1
| >mysql_free_result
| | enter: mysql_res: 0
| <mysql_free_result
| >_myfree
| | enter: ptr: 1b65a88
| <_myfree
| >my_free
| | my: ptr: 1b65678
| <my_free
<SQLFreeStmt
>SQLDisconnect
| >mysql_close
| | >free_old_query
| | <free_old_query
| | >end_server
| | | info: Named pipe: 2924l
| | | >_myfree
| | | | enter: ptr: 1b63648
| | | <_myfree
| | | >free_old_query
| | | <free_old_query
| | <end_server
| | >_myfree
| | | enter: ptr: 1b70e28
| | <_myfree
| | >_myfree
| | | enter: ptr: 1b71138
| | <_myfree
| | >_myfree
| | | enter: ptr: 0
| | <_myfree
| | >_myfree
| | | enter: ptr: 0
| | <_myfree
| | >_myfree
| | | enter: ptr: 0
| | <_myfree
| | >_myfree
| | | enter: ptr: 0
| | <_myfree
| | >_myfree
| | | enter: ptr: 0
| | <_myfree
| | >_myfree
| | | enter: ptr: 0
| | <_myfree
| | >_myfree
| | | enter: ptr: 0
| | <_myfree
| <mysql_close
| >_myfree
| | enter: ptr: 1b71188
| <_myfree
| >_myfree
| | enter: ptr: 1b711d8
| <_myfree
| >_myfree
| | enter: ptr: 1b71228
| <_myfree
| >_myfree
| | enter: ptr: 1b71278
| <_myfree
| >_myfree
| | enter: ptr: 1b712c8
| <_myfree
<SQLDisconnect
>SQLFreeConnect
| >_myfree
| | enter: ptr: 0
| <_myfree
| >_myfree
| | enter: ptr: 0
| <_myfree
| >_myfree
| | enter: ptr: 0
| <_myfree
| >_myfree
| | enter: ptr: 0
| <_myfree
| >_myfree
| | enter: ptr: 0
| <_myfree
<SQLFreeConnect
