'Does SQLAlchemy support Pervasive PSQL? connection string for it?
I googled and found this sqlalchemy-pervasive dialect. I pipped it, but I have no idea how to use it.
What is connection string to pass to create_engine(.....) for sqlalchemy to connect to pervasive psql? is there any other third party driver or dialect?
Solution 1:[1]
After I did a:
pip install sqlalchemy-pervasive
This worked for me:
server='localhost'
database='TEST6'
params = urllib.parse.quote_plus(f'DRIVER=Pervasive ODBC Interface;SERVERNAME={server};DBQ={database}')
engine = create_engine("pervasive:///?odbc_connect=%s" % params)
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
Solution | Source |
---|---|
Solution 1 | brant oliphant |