Unable to login to remote SQL Server database

Thread Rating:

Thread Modes

Unable to login to remote SQL Server database

sipriusPT
Programmer named Tim

Posts: 9

Threads: 4

Joined: Jul 2017

Reputation: 0

Dec-20-2019, 10:16 AM

So i was adding unnecessary quotes, the right statement is suppose to be in python 3:

SQLdbconnection = pyodbc.connect(r'DRIVER={ODBC Driver 17 for SQL Server};SERVER=host\service;DATABASE=database;UID=user;PWD=password')

I hope that this could help others, I have spend 2 days with this ....

Find

Messages In This Thread

RE: Unable to login to remote SQL Server database - by sipriusPT - Dec-20-2019, 10:16 AM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	Running script from remote to server	invisiblemind	4	945	Mar-28-2025, 07:57 AM Last Post: buran
	Connecting to Remote Server to read contents of a file	ChaitanyaSharma	1	3,610	May-03-2024, 07:23 AM Last Post: Pedroski55
	Triggering a ps1 script in remote windows server via http python request	jasveerjassi	1	1,157	Jan-26-2024, 07:02 PM Last Post: deanhystad
	Database connection problems [login, PyQt5, PySql]	gradlon93	5	2,351	Dec-15-2023, 05:08 PM Last Post: deanhystad
	pysql connection to cloud server database times out	Pedroski55	9	7,792	Oct-11-2021, 10:34 PM Last Post: Pedroski55
	How to take the tar backup files form remote server to local server	sivareddy	0	2,710	Jul-14-2021, 01:32 PM Last Post: sivareddy
	in a login interface when i try login with a user supposed to say test123 but nothing	NullAdmin	3	3,291	Feb-20-2021, 04:43 AM Last Post: bowlofred
	python3 emulate tail -f on remote server... support required	anna	0	2,459	Jul-01-2020, 06:42 AM Last Post: anna
	connect to remote database via python script	sunstar20	5	6,806	Apr-23-2018, 11:05 AM Last Post: Gribouillis
	Unable to connect oracle database using python code	mayuresh	2	18,411	Jan-27-2018, 11:57 AM Last Post: mayuresh

Users browsing this thread: 1 Guest(s)