[unixODBC-support] truncated memo fields

tom wright tom at maladmin.com
Wed Nov 16 12:32:02 GMT 2005


Hi Martin, Thanks for your response, I'll try and answer as many of
your questions as I can. The client application is R
(www.r-project.org) using the RODBC package
(http://probability.ca/cran/src/contrib/Descriptions/RODBC.html) I dont
really know how the app is retrieving the memo field nor do I know what
SQL type it is using although I think it may be a large character
field. The data retrieved is a series of numeric values seperated by
'\r' values I then process these into the componant numbers. This works
for me when I retrieve a similar although shorter field of 1536 numbers
but when I try to get the larger field of 10240 numbers the application
reports that only 6921 are returned. The increased buffer size is the
odbc Microsoft Access Driver (*.mdb) MaxBufferSize.
I have attached the file you requested.
Many thanks for your time on this.
Tom

> On 16-Nov-2005 tom wright wrote:
> > Hi folks, 
> > I'm turning to you in desperation.
> 
> Why? Have you tried support at easysoft.com yet?
> 
> > I'm using OOB to connect a linux (debian AMD64 with unixODBC)
> > application to a MSAccess database (MDAC 2.8 sp1)
> > The access database contains some very large memo fields (92160
> > characters). Everytime I try to select a single one of these fields it
> > appears that the field is being truncated. When I select just the field
> > I get approximatly the first 61893 characters, if I try to use LEFT in
> > my sql statement it gets truncated even more (aprox 261 characters).
> > I'm a little stuck as to what I can do here, I've tried increasing the
> > buffer size on the windows side of the ODBC connection, is it possible
> > (nessecary) to do this on the linux side?
> > Any tips will be very useful
> > Thanks
> > Tom
> 
> o What is your client application?
> o How are you retrieving the memo field? (using bound columns? SQLGetData?
>   or you don't know what the app is doing)
> o what SQL type are you retrieving the memo field as?
> o how are you determining the data is truncated
> o what buffer size did you increase on the windows side?
> 
> If you have some app/program you can run from the command line:
> 
> 1. in the current working dir create the file odbc.ini and in it put:
> 
> {Settings}
> Logging = 0xffffff
> 
>   those are curly brackets.
> 
> 2. WITHOUT changing dir, run you program (i.e. you may need to put the fill
>    path in to it)
> 
> 3. you should get a file /tmp/esoobclient.log_<PID> where <PID> is the process
>    ID. Mail that to me and I'll take a look.
> 
> Martin
> --
> Martin J. Evans
> Easysoft Ltd, UK
> Development
-------------- next part --------------
Logging Started with ffffff at Wed Nov 16 07:30:43 2005

	Returned handle = 0x19f2d50
-SQLAllocHandle(1,(nil),0x19f2d50)=0
SQLSetEnvAttr(0x19f2d50,200,0x2,0)
-SQLSetEnvAttr()=SQL_SUCCESS
SQLGetEnvAttr(0x19f2d50,200,0x7fbfff8a2c,0,(nil))
-SQLGetEnvAttr()=SQL_SUCCESS
SQLAllocConnect(0x19f2d50,0x1a16c50)
SQLAllocHandle(2, 0x19f2d50, 0x1a16c50)
	Returned handle = 0xd3f400
-SQLAllocHandle(2,0x19f2d50,0xd3f400)=0
-SQLAllocConnect(...)=0 (handle=0xd3f400)
	^choose_ini_source((nil),(nil),0x7fbfff81c0,1024,0x7fbfff8de8,0,NULL)
	Skipping 0
	checking for ./odbc.ini
	./odbc.ini found
	-^choose_ini_source()=0
SQLDriverConnect(0xd3f400,(nil),DSN=mspatients,-3,0x7fbfffbd10,8096,0x7fbfffb90e,0)
	/home/tom
	Parsing connection string
	^retrieve_oob_flags(0xf55bf0,0xd3f400)
	^choose_ini_source(0x19166b0,0x2a9985cef5,0x7fbfff7040,1024,0x7fbfff74bc,0,mspatients)
	Skipping 0
	checking for ./odbc.ini
	./odbc.ini found
	file_defines_dsn(mspatients,./odbc.ini)
	-file_defines_dsn()=0
	checking for ./.odbc.ini
	./.odbc.ini found
	file_defines_dsn(mspatients,./.odbc.ini)
	-file_defines_dsn()=0
	checking for /home/tom/odbc.ini
	/home/tom/odbc.ini found
	file_defines_dsn(mspatients,/home/tom/odbc.ini)
	-file_defines_dsn()=0
	checking for /home/tom/.odbc.ini
	/home/tom/.odbc.ini found
	file_defines_dsn(mspatients,/home/tom/.odbc.ini)
	-file_defines_dsn()=0
	skipping 5 (2,2)
	skipping 6 (2,2)
	checking for /etc/odbc.ini
	/etc/odbc.ini found
	file_defines_dsn(mspatients,/etc/odbc.ini)
	/etc/odbc.ini defines mspatients
	-file_defines_dsn()=1
	-^choose_ini_source()=0
		With DSN "mspatients"
		MaxBookMarkSize = 32
		Flags = 0
	-^retrieve_oob_flags()
	^get_attrs_from_constr(0xd3f400,0x7fbfff8dd8,0x7fbfff8dc0,0xf55bf0)
		METADATABLOCKFETCH initially defaulted to on
		MAPEXECDIRECT initially defaulted to on
		DEFAULTPARAMSIZE initially defaulted to on
		GETINFOPASSTHRU defaulted to off
	-^get_attrs_from_constr()=0 (found=0x8)
	Translated connection string =
	DSN=mspatients;
	Not enough attributes for connection or SQL_DRIVER_PROMPT
	Looking at DSN="mspatients" for other attributes
	^get_connect_attrs_from_dsn(0xd3f400,0x7fbfff8dd8,0x7fbfff8dc0,0xf55bf0)
		Using DSN=\mspatients\
		Merging attributes from DSN
	^choose_ini_source(0x19166b0,0x2a9985cef5,0x7fbfff7030,1024,0x7fbfff74ac,0,mspatients)
	Skipping 0
	checking for ./odbc.ini
	./odbc.ini found
	file_defines_dsn(mspatients,./odbc.ini)
	-file_defines_dsn()=0
	checking for ./.odbc.ini
	./.odbc.ini found
	file_defines_dsn(mspatients,./.odbc.ini)
	-file_defines_dsn()=0
	checking for /home/tom/odbc.ini
	/home/tom/odbc.ini found
	file_defines_dsn(mspatients,/home/tom/odbc.ini)
	-file_defines_dsn()=0
	checking for /home/tom/.odbc.ini
	/home/tom/.odbc.ini found
	file_defines_dsn(mspatients,/home/tom/.odbc.ini)
	-file_defines_dsn()=0
	skipping 5 (2,2)
	skipping 6 (2,2)
	checking for /etc/odbc.ini
	/etc/odbc.ini found
	file_defines_dsn(mspatients,/etc/odbc.ini)
	/etc/odbc.ini defines mspatients
	-file_defines_dsn()=1
	-^choose_ini_source()=0
		Setting config to /etc/odbc.ini
		Retrieving TARGETAUTH
		Retrieving LOGONAUTH
		Appending LOGONAUTH = rmsp77q
		Retrieving SERVER
		Retrieving PORT
		Retrieving TARGETDSN
		Appending TARGETDSN = mspatients
		Retrieving SERVERPORT
		Appending SERVERPORT = 142.20.115.202:8888
		Retrieving TARGETUSER
		Retrieving LOGONUSER
		Appending LOGONUSER = administrator
		Retrieving UNQUOTE_CATALOG_FNS
		Retrieving METADATA_ID_IDENTIFIERS
		Retrieving BLOCKFETCHSIZE
		Retrieving METADATABLOCKFETCH
		Retrieving DISGUISEWIDE
		Retrieving USEOOBDBAUTH
		Retrieving GETINFOPASSTHRU
		Retrieving MAPEXECDIRECT
		Retrieving DEFAULTPARAMSIZE
		Retrieving CONNECTATTEMPTS
	-^get_connect_attrs_from_dsn()=0 (found=80c88)
	Connection attributes now:
	DSN=mspatients;LOGONAUTH=rmsp77q;TARGETDSN=mspatients;SERVERPORT=142.20.115.202:8888;LOGONUSER=administrator;
	rpc_connect(0xd3f400,0x7fbfff8dc0)
		Starting with \142.20.115.202:8888\
		server/port pair 0
		Using Server=142.20.115.202 Port=8888
		RPCAllocHandle
		RPCInitialise
	oob_lookup_service(8888,<NULL>,0)
		no TCP service 8888 found
	-oob_lookup_service()=8888
		Server=142.20.115.202 Port=8888 ConnectTimeout=Not Set
		RPCSetTransportOpts
		RPCConnect 1 0
	^-rpc_connect()=SQL_SUCCESS
	server_get_info(SERVER_INFO_VERSION) : 2.0.6
	server_get_info(SERVER_INFO_NAME) : OOB
	server_get_info(SERVER_HAS_FAZE2) : 1
	server_set_attribute(SERVER_ATTR_USE_FAZE2)=0
	Authenticating with administrator xxxx
	authenticated
	Allocating remote ENV
	Remote ENV allocated
	Setting remote (SEnvH=0x9fd240) ODBC version to 2
	Setting remote (SEnvh=0x9fd240) OUTPUT_NTS to 1
	Allocating remote DBC
	Remote DBC allocated
	^send_cached_connect_attrs(0xd3f400)
		Cached connection attribute mask: 0
-^	send_cached_connect_attrs()=0
	Using remote connection string:
	DSN=mspatients;
	Remote SQLDriverConnect returned 1
	Out Connect String: \DSN=mspatients\
-SQLDriverConnect()=1
SQLError((nil),0xd3f400,(nil),0x7fbfff8fd0,0x7fbfff8ebc,0x7fbfff8fe0,513,0x7fbfff8eba)
	No existing SQLError sequence
SQLGetDiagField(2,0xd3f400,0,2,0xd3fa14,0,(nil))
	Looking at local errors
	header field - client records ignored
	Error not found on client
	Returned (remote integer field) 1
		local: 0 remote: 1
	(client) returning DIAG_NUMBER: 1
-SQLGetDiagField()=0
	1 errors returned
SQLGetDiagRec(2,0xd3f400,1,0x7fbfff8fd0,0x7fbfff8ebc,0x7fbfff8fe0,513,0x7fbfff8eba)
	0 records on client according to header
	record 1 NOT found on client
	Now looking for error record 1 on server
-SQLGetDiagRec()=0
	01000 0"[Easysoft ODBC (Server)]Warning: You are running OOB Server Multi-threaded to the MS Access ODBC driver which is not thread-safe. Switch OOB Server to MultiProcess"
-SQLError()=0
SQLError((nil),0xd3f400,(nil),0x7fbfff8fd0,0x7fbfff8ebc,0x7fbfff8fe0,513,0x7fbfff8eba)
-SQLError()=SQL_NO_DATA_FOUND
SQLGetFunctions(0xd3f400,1,0x7fbfff8bee)
SQL_API_A_FUNCTION
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,2,0x7fbfff8bee)
SQL_API_A_FUNCTION
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,3e9,0x7fbfff8bee)
SQL_API_A_FUNCTION
	SQLALLOCHANDLE  Supported
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,3,0x7fbfff8bee)
SQL_API_A_FUNCTION
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,49,0x7fbfff8bee)
SQL_API_A_FUNCTION
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,4,0x7fbfff8bee)
SQL_API_A_FUNCTION
	SQLBINDCOL  Supported
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,48,0x7fbfff8bee)
SQL_API_A_FUNCTION
	SQLBINDPARAMETER  Supported
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,37,0x7fbfff8bee)
SQL_API_A_FUNCTION
	SQLBROWSECONNECT NOT Supported
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,18,0x7fbfff8bee)
SQL_API_A_FUNCTION
	SQLBULKOPERATIONS  Supported
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,5,0x7fbfff8bee)
SQL_API_A_FUNCTION
	SQLCANCEL  Supported
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,3eb,0x7fbfff8bee)
SQL_API_A_FUNCTION
	SQLCLOSECURSOR  Supported
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,6,0x7fbfff8bee)
SQL_API_A_FUNCTION
	SQLCOLATTRIBUTE  Supported
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,6,0x7fbfff8bee)
SQL_API_A_FUNCTION
	SQLCOLATTRIBUTE  Supported
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,38,0x7fbfff8bee)
SQL_API_A_FUNCTION
	SQLCOLUMNPRIVILEGES NOT Supported
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,28,0x7fbfff8bee)
SQL_API_A_FUNCTION
	SQLCOLUMNS  Supported
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,7,0x7fbfff8bee)
SQL_API_A_FUNCTION
	SQLCONNECT  Supported
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,3ec,0x7fbfff8bee)
SQL_API_A_FUNCTION
	SQLCOPYDESC  Supported
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,39,0x7fbfff8bee)
SQL_API_A_FUNCTION
	SQLDATASOURCES  Supported
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,8,0x7fbfff8bee)
SQL_API_A_FUNCTION
	SQLDESCRIBECOL  Supported
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,3a,0x7fbfff8bee)
SQL_API_A_FUNCTION
	SQLDESCRIBEPARAM NOT Supported
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,9,0x7fbfff8bee)
SQL_API_A_FUNCTION
	SQLDISCONNECT  Supported
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,29,0x7fbfff8bee)
SQL_API_A_FUNCTION
	SQLDRIVERCONNECT  Supported
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,47,0x7fbfff8bee)
SQL_API_A_FUNCTION
	SQLDRIVERS  Supported
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,3ed,0x7fbfff8bee)
SQL_API_A_FUNCTION
	SQLENDTRAN  Supported
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,a,0x7fbfff8bee)
SQL_API_A_FUNCTION
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,b,0x7fbfff8bee)
SQL_API_A_FUNCTION
	SQLEXECDIRECT  Supported
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,c,0x7fbfff8bee)
SQL_API_A_FUNCTION
	SQLEXECUTE  Supported
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,3b,0x7fbfff8bee)
SQL_API_A_FUNCTION
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,d,0x7fbfff8bee)
SQL_API_A_FUNCTION
	SQLFETCH  Supported
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,3fd,0x7fbfff8bee)
SQL_API_A_FUNCTION
	SQLFETCHSCROLL  Supported
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,3c,0x7fbfff8bee)
SQL_API_A_FUNCTION
	SQLFOREIGNKEYS NOT Supported
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,f,0x7fbfff8bee)
SQL_API_A_FUNCTION
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,3ee,0x7fbfff8bee)
SQL_API_A_FUNCTION
	SQLFREEHANDLE  Supported
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,10,0x7fbfff8bee)
SQL_API_A_FUNCTION
	SQLFREESTMT  Supported
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,e,0x7fbfff8bee)
SQL_API_A_FUNCTION
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,3ef,0x7fbfff8bee)
SQL_API_A_FUNCTION
	SQLGETCONNECTATTR  Supported
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,2a,0x7fbfff8bee)
SQL_API_A_FUNCTION
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,11,0x7fbfff8bee)
SQL_API_A_FUNCTION
	SQLGETCURSORNAME  Supported
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,2b,0x7fbfff8bee)
SQL_API_A_FUNCTION
	SQLGETDATA  Supported
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,3f0,0x7fbfff8bee)
SQL_API_A_FUNCTION
	SQLGETDESCFIELD  Supported
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,3f1,0x7fbfff8bee)
SQL_API_A_FUNCTION
	SQLGETDESCREC  Supported
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,3f2,0x7fbfff8bee)
SQL_API_A_FUNCTION
	SQLGETDIAGFIELD  Supported
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,3f4,0x7fbfff8bee)
SQL_API_A_FUNCTION
	SQLGETENVATTR  Supported
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,2c,0x7fbfff8bee)
SQL_API_A_FUNCTION
	SQLGETFUNCTIONS  Supported
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,2d,0x7fbfff8bee)
SQL_API_A_FUNCTION
	SQLGETINFO  Supported
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,3f6,0x7fbfff8bee)
SQL_API_A_FUNCTION
	SQLGETSTMTATTR  Supported
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,2e,0x7fbfff8bee)
SQL_API_A_FUNCTION
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,2f,0x7fbfff8bee)
SQL_API_A_FUNCTION
	SQLGETTYPEINFO  Supported
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,3d,0x7fbfff8bee)
SQL_API_A_FUNCTION
	SQLMORERESULTS  Supported
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,3e,0x7fbfff8bee)
SQL_API_A_FUNCTION
	SQLNATIVESQL  Supported
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,3f,0x7fbfff8bee)
SQL_API_A_FUNCTION
	SQLNUMPARAMS  Supported
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,12,0x7fbfff8bee)
SQL_API_A_FUNCTION
	SQLNUMRESULTCOLS  Supported
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,30,0x7fbfff8bee)
SQL_API_A_FUNCTION
	SQLPARAMDATA  Supported
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,40,0x7fbfff8bee)
SQL_API_A_FUNCTION
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,13,0x7fbfff8bee)
SQL_API_A_FUNCTION
	SQLPREPARE  Supported
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,41,0x7fbfff8bee)
SQL_API_A_FUNCTION
	SQLPRIMARYKEYS NOT Supported
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,42,0x7fbfff8bee)
SQL_API_A_FUNCTION
	SQLPROCEDURECOLUMNS  Supported
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,43,0x7fbfff8bee)
SQL_API_A_FUNCTION
	SQLPROCEDURES  Supported
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,31,0x7fbfff8bee)
SQL_API_A_FUNCTION
	SQLPUTDATA  Supported
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,14,0x7fbfff8bee)
SQL_API_A_FUNCTION
	SQLROWCOUNT  Supported
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,3f8,0x7fbfff8bee)
SQL_API_A_FUNCTION
	SQLSETCONNECTATTR  Supported
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,32,0x7fbfff8bee)
SQL_API_A_FUNCTION
	SQLSETCONNECTOPTION  Supported
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,15,0x7fbfff8bee)
SQL_API_A_FUNCTION
	SQLSETCURSORNAME  Supported
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,3f9,0x7fbfff8bee)
SQL_API_A_FUNCTION
	SQLSETDESCFIELD  Supported
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,3fa,0x7fbfff8bee)
SQL_API_A_FUNCTION
	SQLSETDESCREC  Supported
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,3fb,0x7fbfff8bee)
SQL_API_A_FUNCTION
	SQLSETENVATTR  Supported
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,44,0x7fbfff8bee)
SQL_API_A_FUNCTION
	SQLSETPOS  Supported
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,45,0x7fbfff8bee)
SQL_API_A_FUNCTION
	SQLSETSCROLLOPTIONS  Supported
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,3fc,0x7fbfff8bee)
SQL_API_A_FUNCTION
	SQLSETSTMTATTR  Supported
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,33,0x7fbfff8bee)
SQL_API_A_FUNCTION
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,34,0x7fbfff8bee)
SQL_API_A_FUNCTION
	SQLSPECIALCOLUMNS  Supported
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,35,0x7fbfff8bee)
SQL_API_A_FUNCTION
	SQLSTATISTICS  Supported
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,46,0x7fbfff8bee)
SQL_API_A_FUNCTION
	SQLTABLEPRIVILEGES NOT Supported
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,36,0x7fbfff8bee)
SQL_API_A_FUNCTION
	SQLTABLES  Supported
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,17,0x7fbfff8bee)
SQL_API_A_FUNCTION
-SQLGetFunctions()=0
SQLGetFunctions(0xd3f400,3f3,0x7fbfff8bee)
SQL_API_A_FUNCTION
	SQLGETDIAGREC  Supported
-SQLGetFunctions()=0
SQLGetInfo(0xd3f400,77[SQL_DRIVER_ODBC_VER],0x7fbfff8bf0,20,(nil))
-SQLGetInfo(...)=SQL_SUCCESS (03.00)
SQLGetInfo(0xd3f400,10000[SQL_XOPEN_CLI_YEAR],0x7fbfff8bf0,5,(nil))
-SQLGetInfo(...)=0 [4]	1995
SQLGetDiagRec(2,0xd3f400,1,0x7fbfff8980,0x7fbfff897c,0x7fbfff8990,512,0x7fbfff8978)
	0 records on client according to header
	record 1 NOT found on client
	Now looking for error record 1 on server
-SQLGetDiagRec()=100
SQLAllocStmt(0xd3f400,0x9224c0)
SQLAllocHandle(3, 0xd3f400, 0x9224c0)
	Returned handle = 0x12e8480
-SQLAllocHandle(3,0xd3f400,0x12e8480)=0
-SQLAllocStmt(...)=0 (handle=0x12e8480)
SQLGetStmtAttr(0x12e8480,10010[APP_ROW_DESC],0x7fbfffd618,8,(nil))
-SQLGetStmtAttr()=SQL_SUCCESS (0X0x12f1880)
SQLGetStmtAttr(0x12e8480,10011[APP_PARAM_DESC],0x7fbfffd618,8,(nil))
-SQLGetStmtAttr()=SQL_SUCCESS (0X0x1a967a0)
SQLGetStmtAttr(0x12e8480,10012[IMP_ROW_DESC],0x7fbfffd618,8,(nil))
-SQLGetStmtAttr()=SQL_SUCCESS (0X0x1377900)
SQLGetStmtAttr(0x12e8480,10013[IMP_PARAM_DESC],0x7fbfffd618,8,(nil))
-SQLGetStmtAttr()=SQL_SUCCESS (0X0x920d50)
SQLExecDirect(0x12e8480,0x5db070,4294967293)
SELECT Samplerate,Sampleswave,Prestimbaseline,Numberaveraged,Data FROM [Patient Information] WHERE [Record#]=138
** 48 **
^cache_param_descriptions(0x12e8480)
	remote sql_num_params()=0 (return parameters=0)
-^cache_param_descriptions()=SQL_SUCCESS
^put_bound_parameters(0x12e8480,0xd3f400,1)
	remote sql_num_params()=0 (return parameters=0)
-^put_bound_parameters()=SQL_SUCCESS (nparams <= 0)
^oob_new_result_set(0x12e8480,0,0)
-^oobc_new_result_set()=0 (f=0x1)
^fetch_bound_parameters(0x12e8480,0xd3f400)
-^fetch_bound_parameters=SQL_SUCCESS (no bound parameters)
-SQLExecDirect(...)=0
SQLNumResultCols(0x12e8480,0x9224c8)
-SQLNumResultCols()=0 (value=5)
SQLNumResultCols(0x12e8480,0xc8d000)
-SQLNumResultCols()=0 (value=5)
SQLRowCount(0x12e8480,0xc8cffc)
-SQLRowCount(RowCount=4294967295)=0
SQLDescribeCol(0x12e8480,1,0x13eba70,256,0x13ebb70,0x13ebb72,0x13ebb74,0x13ebb78,0x13ebb7a)
	Column:1 Name:Samplerate Type:5 Size:5 DD:0 N:1
-SQLDescribeCol()=0
SQLBindCol(0x12e8480,1,-15,0x13ebb98,256,0x13ebb9c)
	^oobc_expand_desc_recs(0x12f1880,1)
	Expanding (nil), n_descrec=0, expanding to 2
	^-oobc_expand_desc_recs()=0x15d84f0
	^oobc_expand_desc_recs(0x1377900,1)
	Expanding (nil), n_descrec=0, expanding to 2
	^-oobc_expand_desc_recs()=0xcf7750
-SQLBindCol()=0
SQLDescribeCol(0x12e8480,2,0x13ebba0,256,0x13ebca0,0x13ebca2,0x13ebca4,0x13ebca8,0x13ebcaa)
	Column:2 Name:Sampleswave Type:5 Size:5 DD:0 N:1
-SQLDescribeCol()=0
SQLBindCol(0x12e8480,2,-15,0x13ebcc8,256,0x13ebccc)
	^oobc_expand_desc_recs(0x12f1880,2)
	Expanding 0x15d83f0, n_descrec=2, expanding to 3
	^-oobc_expand_desc_recs()=0x1577530
	^oobc_expand_desc_recs(0x1377900,2)
	Expanding 0xcf7650, n_descrec=2, expanding to 3
	^-oobc_expand_desc_recs()=0xb2e320
-SQLBindCol()=0
SQLDescribeCol(0x12e8480,3,0x13ebcd0,256,0x13ebdd0,0x13ebdd2,0x13ebdd4,0x13ebdd8,0x13ebdda)
	Column:3 Name:Prestimbaseline Type:5 Size:5 DD:0 N:1
-SQLDescribeCol()=0
SQLBindCol(0x12e8480,3,-15,0x13ebdf8,256,0x13ebdfc)
	^oobc_expand_desc_recs(0x12f1880,3)
	Expanding 0x1577330, n_descrec=3, expanding to 4
	^-oobc_expand_desc_recs()=0xac9070
	^oobc_expand_desc_recs(0x1377900,3)
	Expanding 0xb2e120, n_descrec=3, expanding to 4
	^-oobc_expand_desc_recs()=0x138ae10
-SQLBindCol()=0
SQLDescribeCol(0x12e8480,4,0x13ebe00,256,0x13ebf00,0x13ebf02,0x13ebf04,0x13ebf08,0x13ebf0a)
	Column:4 Name:Numberaveraged Type:5 Size:5 DD:0 N:1
-SQLDescribeCol()=0
SQLBindCol(0x12e8480,4,-15,0x13ebf28,256,0x13ebf2c)
	^oobc_expand_desc_recs(0x12f1880,4)
	Expanding 0xac8d70, n_descrec=4, expanding to 5
	^-oobc_expand_desc_recs()=0xac9170
	^oobc_expand_desc_recs(0x1377900,4)
	Expanding 0x138ab10, n_descrec=4, expanding to 5
	^-oobc_expand_desc_recs()=0x138af10
-SQLBindCol()=0
SQLDescribeCol(0x12e8480,5,0x13ebf30,256,0x13ec030,0x13ec032,0x13ec034,0x13ec038,0x13ec03a)
	Column:5 Name:Data Type:-1 Size:2147483647 DD:0 N:1
-SQLDescribeCol()=0
SQLBindCol(0x12e8480,5,1,0x1f371d0,65535,0x13ec05c)
	^oobc_expand_desc_recs(0x12f1880,5)
	Expanding 0xac8d70, n_descrec=5, expanding to 6
	^-oobc_expand_desc_recs()=0xac9270
	^oobc_expand_desc_recs(0x1377900,5)
	Expanding 0x138ab10, n_descrec=5, expanding to 6
	^-oobc_expand_desc_recs()=0x138b010
-SQLBindCol()=0
SQLFetch(0x12e8480)
^retrieve_server_diags(3,0x12e8480,3,0x9fd260)
	1 diags found in server
	^post_error(0x12e8668,8,1,0,(nil),0xd3f908,180388626437,545460846592,0x2a992bf97f,0x7fbfffc8a0,0x7fbfffc4a0)
	-^post_error()
-^retrieve_server_diags()
	^fetch_bound_columns(0x12e8480,0xd3f400)
	^fetch_column_descriptions(0xd3f400,0x12e8480,0x7fbfffc8c6)
	-^fetch_column_descriptions()=SQL_SUCCESS (highest result set column = 5)
	Processing column 0 of 5
	Processing column 1 of 5
	^get_type_len(-15,256,0)
	SQL_C_SHORT
	-^get_type_len()=2
	Processing column 2 of 5
	^get_type_len(-15,256,0)
	SQL_C_SHORT
	-^get_type_len()=2
	Processing column 3 of 5
	^get_type_len(-15,256,0)
	SQL_C_SHORT
	-^get_type_len()=2
	Processing column 4 of 5
	^get_type_len(-15,256,0)
	SQL_C_SHORT
	-^get_type_len()=2
	Processing column 5 of 5
	^get_type_len(1,65535,0)
	SQL_C_CHAR
	-^get_type_len()=0
	variable length bound column
	using OctetLength:65535
	-^fetch_bound_columns(...)=0
-SQLFetch()=1
SQLGetDiagRec(3,0x12e8480,1,0x7fbfffc4a0,0x7fbfffc49c,0x7fbfffc4b0,512,0x7fbfffc498)
	1 records on client according to header
	Found error record 1 on client
-SQLGetDiagRec()=0
SQLGetDiagRec(3,0x12e8480,2,0x7fbfffc4a0,0x7fbfffc49c,0x7fbfffc4b0,512,0x7fbfffc498)
	1 records on client according to header
	record 2 NOT found on client
	Now looking for error record 1 on server
-SQLGetDiagRec()=100
SQLFetch(0x12e8480)
^fetch_bound_parameters(0x12e8480,0xd3f400)
-^fetch_bound_parameters=SQL_SUCCESS (no bound parameters)
-SQLFetch(...)=100
SQLDisconnect(0xd3f400)
	Have RPCHandle
	^disconnect_dbc(0xd3f400)
^free_stmt(0x12e8480)
^freeup_descriptors(0xd3f400,0x12e8480)
^oobc_release_desc_recs(0x1377900,0,1)
-^oobc_release_desc_recs()
^free_desc(0x1377900)
^-free_desc(...)=SQL_SUCCESS
^oobc_release_desc_recs(0x920d50,0,1)
-^oobc_release_desc_recs()
^free_desc(0x920d50)
^-free_desc(...)=SQL_SUCCESS
^oobc_release_desc_recs(0x12f1880,0,1)
-^oobc_release_desc_recs()
^free_desc(0x12f1880)
^-free_desc(...)=SQL_SUCCESS
^oobc_release_desc_recs(0x1a967a0,0,1)
-^oobc_release_desc_recs()
^free_desc(0x1a967a0)
^-free_desc(...)=SQL_SUCCESS
-^freeup_descriptors(...)=0
^-free_stmt(..)=SQL_SUCCESS
	-^disconnect_dbc()=0
	Freeing remote dbc 0x9fd250
	Freeing remote env 0x9fd240
-SQLDisconnect()=0
SQLFreeConnect(0xd3f400)
SQLFreeHandle(2,0xd3f400)
-SQLFreeHandle(...)=0
-SQLFreeConnect(...)=0
SQLFreeEnv(0x19f2d50)
SQLFreeHandle(1,0x19f2d50)
-SQLFreeHandle(...)=0
-SQLFreeEnv(...)=0


More information about the unixODBC-support mailing list