How to change name of attaching SQL database in pyodbc - Python

Asked Sep 10 '19 at 21:36

Active Sep 10 '19 at 21:36

Viewed 283 times

I am trying to attach a database through python pyodbc and then save to dataframe. I found and a solution here How to open a SQL Server .mdf file with Python (pandas)

But how can I change the name of the attaching database? So when I am attaching the database based on the code

r'AttachDbFileName=C:\Users\Gord\Desktop\zzz.mdf;'

am I also able to set the name of the database?

Thanks a lot!

asked Sep 10 '19 at 21:36

webmourek

You cannot attach a SQL Server data file. You have to connect to a SQL Server instance (and a database in it) using pyodbc and a odbc driver for SQL Server. – Neeraj Agarwal Sep 10 '19 at 21:55
Have you tried just specifying the database name as `DATABASE=somename;` in the connection string? – Gord Thompson Sep 11 '19 at 10:55
Thanks a lot @Gord Thompson. – webmourek Sep 17 '19 at 09:14

0 Answers0