SAP SQL Anywhere

Question

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!

Answer 1

2	I figured this out. The following worked: `eng=sql.create_engine(url,connect_args={'dbf': "D:\\database_file_path.db", 'ServerName':'MyServer'} )` permanent link answered 10 Oct '14, 12:11 Goutham 46●1●1●6 accept rate: 0% flat view

Connection String for SQLAlchemy-SQLAny api