Python Forum
Passing parameters to SQL Server using pandas
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Passing parameters to SQL Server using pandas
#6
Your subject says SQL Server

Did you try with ibm_db module ?

pip install ibm_db
import ibm_db
conn = ibm_db.connect("DATABASE=name;HOSTNAME=host;PORT=60000;PROTOCOL=TCPIP;UID=username; PWD=password;", "", "")
cursor = conn.cursor()
cursor.execute("SELECT * FROM yourtable")
for cr in cursor.fetchall():
    print(cr)
Reply


Messages In This Thread
RE: Passing parameters to SQL Server using pandas - by parthi1705 - May-31-2019, 04:28 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Python Alteryx QS-Passing pandas dataframe column inside SQL query where condition sanky1990 0 786 Dec-04-2023, 09:48 PM
Last Post: sanky1990
  Passing parameters with arrays and array definitions michael_lwt 1 987 Jul-07-2022, 09:45 PM
Last Post: Larz60+
  How to take the tar backup files form remote server to local server sivareddy 0 1,952 Jul-14-2021, 01:32 PM
Last Post: sivareddy
  Fastest Method for Querying SQL Server with Python Pandas BuJayBelvin 7 7,054 Aug-02-2020, 06:21 PM
Last Post: jefsummers
  Passing parameters from C# to Python[for using in gensim] in Visual Studio 2017 ZoghbyAya 0 3,899 May-21-2018, 08:49 PM
Last Post: ZoghbyAya

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020