![]() I'm guessing that while you try to use SERVER=local, you don't actually have local mapped to the guest VM. ![]() Access Parallels Windows localhost from Mac might be helpful with that. I assume you're trying to connect to MS SQL Server, though your question has contradictory information - parts of it refer to MSSQL, while other parts mention MySQL.įirst you need to establish network connectivity with the guest. I've turned off the firewall from windows, but still nothing.Ĭonnection = (host='10.211.55.3',Īnd now I find myself with the following error: ProgrammingError: 1045 (28000): Access denied for user (using password: NO) I have also tried the following in terms of adjusting the connection string: SERVER=10.211.55.3 OperationalError: (pyodbc.OperationalError) ('HYT00', ' Login timeout expired (0) (SQLDriverConnect)') New_race_data = pd.read_sql_query(sql_get_data, db) Params = 'DRIVER= ' 'SERVER=local ' 'DATABASE=Totepro 'ĭb = create_engine('mssql+pyodbc:///?odbc_connect=%s' % params) I've tried the following code: import pyodbc I'm writing a python script on Jupyter notebook on my Mac OS, and I'm trying to connect to a local DB that is located on my Parallels Windows operating system that is running from my external hard drive.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |