Connection String for SQLAlchemy-SQLAny api

Former Member — Thu, 09 Oct 2014 16:06:32 GMT

I am trying to connect to SQLAnywhere using the SQLAlchemy-SQLAny dialect for python. Here is my connection string format:

url="sqlalchemy_sqlany://user:pwd@localhost/D:\\database_file_path.db?ServerName=MyServer"

Here I want to connect to SQLAnywhere using a service named "MyServer" setup in my computer. But I get the following error:

sqlalchemy.exc.OperationalError: (OperationalError) Specified database not found None None

Though I am able to connect using the raw sqlanydb python api as:

conn=sqlanydb.connect(UserID="user",Password="pwd",DatabaseFile="D:\\database_file_path.db",ServerName="MyServer")

I just want to use the same with SQLAlchemy. Any help would be much appreciated!

Re: Connection String for SQLAlchemy-SQLAny api

Former Member — Fri, 10 Oct 2014 12:11:50 GMT

I figured this out. The following worked:

eng=sql.create_engine(url,connect_args={'dbf': "D:\\\\database_file_path.db", 
'ServerName':'MyServer'} 
)