Sample code to connect DB using parameter values

nithin · Oct-14-2018, 09:42 PM

Need a sample program to connect SQL SERVER DB using parameter file

1) looking for sample code for connecting to DB using parameter file

**Larz60+** · Oct-14-2018, 10:45 PM

which DBMS?

nithin · (This post was last modified: Oct-15-2018, 01:44 AM by nithin.)

SQL SERVER, Sorry for late response

These are the parameters i want to call from a file into the program.

sourceDBDriver
sourceDBBserver
sourceDatabase
userid
password

and i am connecting this way

connect_String = 'Driver={%s}.....................
conn = pyodbc.connect(connect_string)

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	[ERROR] ParamValidationError: Parameter validation failed: Invalid type for parameter	gdbengo	3	17,380	Dec-26-2022, 08:48 AM Last Post: ibreeden
	autocomplete working code sample not working...	aviper4u	0	2,070	Oct-24-2020, 03:04 AM Last Post: aviper4u
	Syntax error in python code sample	ErnestTBass	5	4,306	Aug-14-2020, 07:14 PM Last Post: deanhystad
	How to pass multiple values from one sample to nc variable?	Baloch	0	2,429	Jun-01-2020, 09:27 PM Last Post: Baloch
	Can anyone Please help on fixing this python code to connect and save things on sqlit	Roscoes	2	3,594	Mar-06-2018, 04:48 AM Last Post: Roscoes
	Unable to connect oracle database using python code	mayuresh	2	18,159	Jan-27-2018, 11:57 AM Last Post: mayuresh
	SoX Sound Exchange sample code to Rec & Play audio file	Fran_3	3	7,726	Sep-11-2017, 09:13 AM Last Post: Larz60+

Sample code to connect DB using parameter values

User Panel Messages

Announcements