search

danishabdullah / pyodbc

Automatically exported from code.google.com/p/pyodbc
Other
0 stars 0 forks source link

Blob on Progress Database #244

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago 
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.

Original issue reported on code.google.com by stero...@gmail.com on 9 Mar 2012 at 10:44

Attachments:

GoogleCodeExporter commented 8 years ago

Original comment by mkleehammer on 29 Sep 2012 at 5:00

GoogleCodeExporter commented 8 years ago 
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.

Original comment by sendhil....@gmail.com on 18 Mar 2013 at 11:50

GoogleCodeExporter commented 8 years ago 
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?

Original comment by stero...@gmail.com on 19 Mar 2013 at 7:46