Passing parameters to SQL Server using pandas

[Ilangos]

Hi parthi,

Thank you for the inputs.

Finally, found the solution for it. Have mentioned the solution for the folks who might face similar problem in future.

Problem statement: Connecting to IBM DB2 having OLE DB provider: IBM DB2 for I IBMDA400 OLE DB provider

driver='{iSeries Access ODBC Driver}' # Install this driver by contacting your local IT team
system='xx.x.xx.xx'
uid='Robot'
pwd='xxxxxxxx'

import pyodbc
import pandas as pd


ole_conn = pyodbc.connect(driver=driver,system=system,uid=uid,pwd=pwd)
ole_query= "your desired query"
ole_data = pd.read_sql_query(ole_query,con=ole_conn)
ole_data.head(5)