Operation error

[Joemuchiri2]

OperationalError Traceback (most recent call last)
c:\Users\Admin\OneDrive\LP1\Untitled-1.ipynb Cell 3 line 1
----> 1 connection = pyodbc.connect(connection_string)
3 query="Select * from dbo.LP2_Telco_churn_first_3000"
4 data=pd.read_sql(query,connection)

OperationalError: ('08001', '[08001] [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. (17) (SQLDriverConnect); [08001] [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). (53)')

I'm getting this error how should I handle it

[coderacheal]

@Joemuchiri2, please check your .env file and make sure that you have set the correct environment variables like server name, database name, login, etc. I have tried it and it works. Alternatively, please make sure your internet is strong, and that is not the problem

To cross-check

• Please check the credentials in your .env file.
• Put your values in the quotation.
• Also, make sure the connection string is complete. Try to use the same variable names as the ones in the notebook. You can change them once you have been able to access the data

[Joemuchiri2]

InterfaceError Traceback (most recent call last)
c:\Users\Admin\OneDrive\LP1\Untitled-1.ipynb Cell 3 line 1
----> 1 connection = pyodbc.connect(connection_string)
3 query="Select * From dbo.LP1_startup_funding2020"
4 data=pd.read_sql(query,connection)

InterfaceError: ('28000', "[28000] [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'LP1_learner'. (18456) (SQLDriverConnect); [28000] [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'LP1_learner'. (18456)")

Now I'm getting this error