Sqlalchemy connect to server without specifying database

Question

Is it possible to connect to the MSSQL server using sqlalchemy and then create the database?

I am using the following:

sqlalchemy.create_engine("mssql+pyodbc://sa: pwd@localhost /")

But I get an error message:

Detail DBAPIError: (Error) ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnect)') None None

I would like to connect to the server, then create a database and work with it.

Answer 1

Try:

 import urllib connection_string = "DRIVER={SQL Server};SERVER=localhost;UID=sa;PWD=pwd" connection_string = urllib.quote_plus(connection_string) connection_string = "mssql+pyodbc:///?odbc_connect=%s" % connection_string engine = sqlalchemy.create_engine(connection_string) connection = engine.connect() connection.execute("create database test") connection.close() 

Part of the code is taken from this.

Hope this helps.