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
- How to store a date/time in sqlite (or something similar to a date)
- Instagrapi recently showing HTTPError and UnknownError
- How to Retrieve Data from an MySQL Database and Display it in a GUI?
- How to create a regular expression to partition a string that terminates in either ": 45" or ",", without the ": "
- Python Geopandas unable to convert latitude longitude to points
- Influence of Unused FFN on Model Accuracy in PyTorch
- Seeking Python Libraries for Removing Extraneous Characters and Spaces in Text
- Writes to child subprocess.Popen.stdin don't work from within process group?
- Conda has two different python binarys (python and python3) with the same version for a single environment. Why?
- Problem with add new attribute in table with BOTO3 on python
- Can't install packages in python conda environment
- Setting diagonal of a matrix to zero
- List of numbers converted to list of strings to iterate over it. But receiving TypeError messages
- Basic Python Question: Shortening If Statements
- Python and regex, can't understand why some words are left out of the match
Related Questions in 64-BIT
- GDI - Why the printing StartPage() function works in 32 bit but raises an exception in 64 bit?
- GNU AS ASM to bytecode dump
- How do I use .lib to compile and link in c++ builder 11.3 windows 64bits platform?
- Windows 64-bit: Do overlapped MMF windows mean more RAM consumption (doubling the RAM where the file views overlap)?
- Invoke jar from C++ using JNI
- SQLBindCol for long integer value on 64Bit platform?
- Assembly segmentation fault in example code
- PowerShell switch block and values coded in 64 bits
- How can I get a 32-bit output with Python on a 64-bit system?
- Recompiled APK throws error "This release is not compliant with the Google Play 64-bit requirement"
- Porting code that wraps ODBC API to 64 bit questions
- ilink64 Error Fatal: Unable to open file 'VCL.VIRTUALIMAGELIST.O'
- Open and write file in nasm for Windows 64bit
- C display tansparent text on any background
- Problem with quicksort function on arrays of 64 bits integers in C
Related Questions in IBM-MIDRANGE
- Restoring a WRKLNK file
- DB2/400 SQL subqueries
- SQL - Select only records where field contains either a given string explicitly OR or a range of strings within which given string falls
- Using SQL to view AS400 Journal data - Entry_Data in particular
- IBM Rational - indentation available in Rational 9.6.0.6?
- How to get a list of programs that uses a particular command in AS400
- DB2: Query Memberfile of a Table with SQL
- Using the routine CSNBOWH on IBM I - MD5
- Doing an external webservice call from rpgle program
- Mandatory field even if not the first field
- Create command similar to WRKLIBPDM
- RPG - how do we return a parameter using C-style "Return <Value>" syntax
- Getting data from AS400/IBM i through ODBC to excel
- Unable to monitor message inside SELECT statement
- Error java.net.SocketException: Socket is closed when closing AS400 Secure RPC session
Related Questions in PYODBC
- Error connecting to SQL Server using pyodbc: Data source name not found and no default driver specified
- python3 working on terminal but not on cron job
- The SQL contains 0 parameter markers, but 5 parameters were supplied
- Can I catch azure synapse pipeline python pyodbc exceptions?
- Difficulty executing SQL Server stored procedure programmatically using Python and ODBC
- pyodbc.drivers() = []?
- How to store Pandas DataFrame with Int64 to MS Access table
- Python - Debug Module Loading Issues
- Issue with SQLAlchemy accessing Impala database via cloudera ODBC DSN
- Failed to authenticate the user '' in Active Directory (Authentication option is 'ActiveDirectoryIntegrated')
- Connecting from Azure Synapse Analytics Spark Pool to Azure MI
- PYODBC upsert to SQL poor performance
- Sqlcmd can connect to old SQL Server 2005, but connection string pyodbc with Driver 18 from Microsoft does not work
- Error when inserting and updating simultaneously in sql server via pyodbc
- Python PyODBC and SQL Server encoding issue
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 # Hahtags
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