I am currently working on a python application which runs fine on 32 bit machine. Now I have to move to 64 bit . The problem which I am currently facing is the data from the database is not fetched properly here but If I run the same query on 32 bit machine it works. I am using pyodbc. When I fetch data I get -1 as my row count. I have installed IBM I series access odbc driver. I have installed that in C:\windows\SysWow64\odbcad32.exe but there is no luck. Can anyone explain me why I am getting as -1 in rowcount or what could be a possible reason for this. Thanks in advance.
pyodbc rowcount return in negative
1.1k Views Asked by Nitin Niraj At
1
There are 1 best solutions below
Related Questions in PYTHON
- new thread blocks main thread
- Extracting viewCount & SubscriberCount from YouTube API V3 for a given channel, where channelID does not equal userID
- Display images on Django Template Site
- Difference between list() and dict() with generators
- How can I serialize a numpy array while preserving matrix dimensions?
- Protractor did not run properly when using browser.wait, msg: "Wait timed out after XXXms"
- Why is my program adding int as string (4+7 = 47)?
- store numpy array in mysql
- how to omit the less frequent words from a dictionary in python?
- Update a text file with ( new words+ \n ) after the words is appended into a list
- python how to write list of lists to file
- Removing URL features from tokens in NLTK
- Optimizing for Social Leaderboards
- Python : Get size of string in bytes
- What is the code of the sorted function?
Related Questions in 64-BIT
- (x64 Nasm) Writeline function on Linux
- How to return a 16 bit value as 64 bit?
- iOS: app doesn't pass the upload for the architecture
- Can't open mkl_intel_s_dll.lib in 64bit Visual Studio environment
- Intel x64 instructions CMPSB/CMPSW/CMPSD/CMPSQ
- Zlib decompression method warning using ios 64bit Architecture
- Assembly x64: Using MULPD instruction with integer
- VirtualBox: VERR_VMX_MSR_VMXON_DISABLED
- 64bit bitmask and javascript
- Delphi xe2 Error compiling ASM code with x64 compiler. Unsupported language feature: 'ASM'
- Cordova 3.8.0 Build Causes Errors in Iphone Apps locking up at Splash Screen
- DirectX libs in x64 program
- Is there any reason to still use int as opposed to long on a 64 bit machine?
- In 64bit R, what should my memory.limit() be set to?
- NASM issue on OSX 64-bit
Related Questions in IBM-MIDRANGE
- How can i use Java to call an existing RPG screen program?
- SQL access to RPG OPM database files
- PHP rollback on IBMi db2 doesn't work
- DB2 Concatenate rows
- How to configure IBM i Netserver share so that a new IFS file has its ccsid attribute set to a specified ccsid different from Netserver ccsid
- pyodbc rowcount return in negative
- Using a custom comparator for std::map on IBM i-Series
- IBM i (as400) CIM and ethernet interfaces
- Hikari connections and active AS400 jobs
- Syntax error in odbc.ini
- Create a IBM i Java Toolkit RecordFormat from an IBM i File
- CL: Path name contains embedded nulls (CPD018A)
- AS/400 End User - run keystrokes automatically
- Get Column Description from iSeries v7r1 export to Excel or Access
- Deploy IBM Client Access V7r1 Silently
Related Questions in PYODBC
- Manually installing pyodbc on Windows with firewall
- Connect to Azure SQL database via pyodbc
- Connecting to Oracle ODBC via Pyodbc (32-bit vs. 64-bit)
- Trouble connecting to SQL server with python
- Connecting to ODBC using pyODBC
- pyodbc rowcount return in negative
- What happens if you don't close a pyodbc connection?
- Using list of rows whether I have 1 row or N many
- Pyodbc & SQL Server-TypeError: not all arguments converted during string formatting
- Unable to connect to MSSQL from Python
- Python - pyodbc call stored procedure with parameter name
- pyodbc: How to prevent Communication link failure, ConnectionWrite, and ConnectionRead errors?
- Pyodbc installation error on Ubuntu 16.04 with Sql Server installed
- How to configure the Database setting Django-MSSQL using django-pyodbc (ubuntu 16.04)?
- Passing through credentials to PyODBC from Flask-LDAP
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
As far as I know the -1 can occur if the number of rows is unknown. Sometimes its just because of performance reason - the number of rows is not known when the first row is returned, so it is not an error. More about this in podbc documentation here