My favorites | Sign in
Project Home Downloads Wiki
READ-ONLY: This project has been archived. For more information see this post.
Search
for
  Advanced search   Search tips   Subscriptions
Issue 244: Blob on Progress Database
1 person starred this issue and may be notified of changes. Back to list
Status:  New
Owner:  ----


 
Reported by stero...@gmail.com, Mar 9, 2012
pyodbc 3.0.3 on Mandriva Linux 2010.1 (x86_64).

Trying to read a big blob from Progress database, pyodbc returns none.

I identified the problem on "getdata.cpp" in function "GetDataString". Here there is a "for (int iDbg = 0; iDbg < 10; iDbg++)", but for Progress we must read until SqlGetData returns "SQL_NO_TOTAL".
I modified the cicle in this way (see attachment) and it works, but I'm not sure that this is correct for other DBMS.

Can you fix this problem? Thanks.

getdata.cpp
23.1 KB   View   Download
Sep 29, 2012
Project Member #1 mkleehammer
(No comment was entered for this change.)
Labels: Driver-progress
Mar 18, 2013
#2 sendhil....@gmail.com
What driver do you use to connect to the Progress/4D database?  i.e., I am looking for the exact driver name to use to connect to a 4D/Progress DB.
Mar 19, 2013
#3 stero...@gmail.com
This is my odbc.ini configuration:
<<
[pyProgressTest]
QEWSD=2455975
Driver=/user/ivdlc11.1/odbc/lib/pgoe26.so
DatabaseName=iv
PortNumber=11016
HostName=localhost
LogonID=sysprogress
Password=sysprogress
APILevel=1
ConnectFunctions=YYN
CPTimeout=60
DriverODBCVer=03.60
FileUsage=0
SQLLevel=0
UsageCount=1
ArraySize=200
DefaultLongDataBuffLen=16384
DefaultIsolationLevel=READ COMMITTED
StaticCursorLongColBuffLen=16384
>>

Is it sufficient for you?

Powered by Google Project Hosting