Python Forum
how do I successfully use PDO with my ODBC for MSSQL?
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
how do I successfully use PDO with my ODBC for MSSQL?
#4
I personally use something like the following:

import pymysql

conn =  pymysql.connect(host=dbhost, port=3306,user=username,password=dbpassword,db='database',autocommit=True,local_infile=1)
cursor = conn.cursor()
cursor.execute(Query)
conn.close()
You should be able to do something similar with MSSQL using a DSN

conn = pyodbc.connect(r'DSN=mynewdsn;UID=user;PWD=password')
yea; here is a good example

https://docs.microsoft.com/en-us/sql/con...erver-2017
Reply


Messages In This Thread
RE: how do I successfully use PDO with my ODBC for MSSQL? - by Maverick494 - Jun-26-2018, 04:44 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Pulling data from mssql to PG DB hartman60 1 629 Jan-31-2025, 12:26 PM
Last Post: hartman60
  python connect to mssql wailoonho 7 6,569 Dec-07-2023, 02:06 AM
Last Post: wailoonho
Sad Can anyone help me successfully run this code? TheMouseAvenger 26 9,083 Sep-22-2023, 02:51 PM
Last Post: snippsat
  MSSQL query not working in Python kat35601 0 1,590 Apr-12-2022, 06:44 PM
Last Post: kat35601
  from MSSQL to excel kat35601 1 2,572 Apr-11-2022, 06:19 PM
Last Post: buran
  ssues with importing data from ODBC Slavek_d 1 2,152 Feb-01-2022, 09:57 AM
Last Post: ibreeden
  ODBC iPhone to PC KipCarter 0 1,991 Feb-19-2020, 11:53 AM
Last Post: KipCarter
  accessing Sybase (ASE and/or Anywhere) via ODBC... on Linux zatlas1 0 3,684 Jan-31-2019, 06:48 PM
Last Post: zatlas1
  [split] How to insert JSON into MSSQL gehrenfeld 3 4,275 Jan-27-2019, 06:20 PM
Last Post: micseydel
  How to insert JSON into MSSQL raysefo 2 5,016 Jan-27-2019, 06:17 PM
Last Post: micseydel

Forum Jump:

User Panel Messages

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