1 year ago

#320551

test-img

T_Ner

Can't connect Sqlalchemy with pymssql to SQL Server 2000

Using pymssql.connect it worked

import pymssql

conn = pymssql.connect("192.168.1.12", "sa", "123456789", "aa")
cursor = conn.cursor()
cursor.execute('SELECT * FROM Table2')
print( "all persons" )
print( cursor.fetchall() )

However, I want to use SQLAlchemy with pymssql and it does not work

import pandas as pd
import sqlalchemy
from sqlalchemy import create_engine

engine = create_engine("mssql+pymssql://sa:123456789@192.168.1.12/aa")
df = pd.read_sql_table('Table2', engine)
df

OperationalError: (pymssql._pymssql.OperationalError) (195, b"'schema_name' is not a recognized function name.DB-Lib error message 20018, severity 15:\nGeneral SQL Server error: Check messages from the SQL Server\n") [SQL: SELECT schema_name()] (Background on this error at: https://sqlalche.me/e/14/e3q8)

How can I connect this?

sql

sql-server

sqlalchemy

sql-server-2000

pymssql

0 Answers

Your Answer

Accepted video resources