不想使用 ODBC檬姥，之前網(wǎng)上搜到的全是 jconn4.jar俏拱，但是無法連接埃篓，后來發(fā)現(xiàn)另外兩個(gè)包可以，記錄一下
import jaydebeapi
DB_HOST = "127.0.0.1"
DB_PORT = "5000"
DB_NAME = "test"
DB_USER = "username"
DB_PASS = "password"
try:
# 方式一
conn1 = jaydebeapi.connect(
"com.sybase.jdbc3.jdbc.SybDriver",
f"jdbc:sybase:Tds:{DB_HOST}:{DB_PORT}/{DB_NAME}",
[DB_USER, DB_PASS],
"jconn3d.jar", # 相對路徑/絕對路徑
)
# 方式二
conn2 = jaydebeapi.connect(
"net.sourceforge.jtds.jdbc.Driver",
f"jdbc:jtds:sybase://{DB_HOST}:{DB_PORT}/{DB_NAME}",
[DB_USER, DB_PASS],
"jtds-1.3.1.jar", # 相對路徑/絕對路徑
)
print("Successfully connected to the database")
except Exception as e:
print("Error connecting to the database", e)
