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


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:


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

asked 09 Oct '14, 16:06

Goutham's gravatar image

accept rate: 0%

edited 09 Oct '14, 16:10

I figured this out. The following worked:

eng=sql.create_engine(url,connect_args={'dbf': "D:\\database_file_path.db", 
permanent link

answered 10 Oct '14, 12:11

Goutham's gravatar image

accept rate: 0%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 09 Oct '14, 16:06

question was seen: 3,591 times

last updated: 10 Oct '14, 12:11