DATABASE - Revision history

Gordon.dye: /* DSN */

2023-07-31T02:29:59Z

DSN

← Older revision		Revision as of 02:29, 31 July 2023
Line 12:		Line 12:
	EXECUTE 'CONFIG DATABASE CLS_Data DSN="MyData" , PASSWORDD= <encrypted-password>'		EXECUTE 'CONFIG DATABASE CLS_Data DSN="MyData" , PASSWORDD= <encrypted-password>'

	[[Encrypt$\|Encrypted passwords]] are expressed as hexadecimal values.		''[[Encrypt$\|Encrypted passwords]]'' are expressed as hexadecimal values. BR will ''[[UnHex$\|Unhex]]'' the value and then ''[[Decrypt$\|Decrypt]]'' it before presenting it to SQL Server.

	===CONNECTSTRING (DSN Less)===		===CONNECTSTRING (DSN Less)===

Gordon.dye: /* DSN */

2023-07-31T02:19:36Z

DSN

← Older revision		Revision as of 02:19, 31 July 2023
Line 11:		Line 11:
	Example:		Example:
	EXECUTE 'CONFIG DATABASE CLS_Data DSN="MyData" , PASSWORDD= <encrypted-password>'		EXECUTE 'CONFIG DATABASE CLS_Data DSN="MyData" , PASSWORDD= <encrypted-password>'

			[[Encrypt$\|Encrypted passwords]] are expressed as hexadecimal values.

	===CONNECTSTRING (DSN Less)===		===CONNECTSTRING (DSN Less)===

Gordon.dye: /* CONNECTSTRING (DSN Less) */

2023-07-31T02:11:32Z

CONNECTSTRING (DSN Less)

← Older revision		Revision as of 02:11, 31 July 2023
Line 30:		Line 30:

	"password" is the [SQL Server Password].		"password" is the [SQL Server Password].


	Using a SQL Server with Windows Authentication:		Using a SQL Server with Windows Authentication:

Gordon.dye: /* CONNECTSTRING (DSN Less) */

2023-07-31T02:09:56Z

CONNECTSTRING (DSN Less)

← Older revision		Revision as of 02:09, 31 July 2023
Line 31:		Line 31:
	"password" is the [SQL Server Password].		"password" is the [SQL Server Password].

	Using a SQL Server /w Windows Authentication:		Using a SQL Server with Windows Authentication:
	CONFIG database db-ref connectstring="DRIVER=SQL Server;Initial Catalog=database;Persist Security Info=True;MultipleBC_TableResultSets=True; Database=database;SERVER=server" User=~~username~~ Password=BR_PASSWORD		CONFIG database db-ref connectstring="DRIVER=SQL Server;Initial Catalog=database;Persist Security Info=True;MultipleBC_TableResultSets=True; Database=database;SERVER=server" User=LOGIN_NAME Password=BR_PASSWORD

	Notice that the connection string, placed within quotes, is separate from the '''User=''' and '''Password=''' parameters. If the additional parameters are specified, BR will augment the connection string with '''UID=''' and '''PWD=''' parameters. Do not confuse connection string valid parameters with BR augmentation parameters.		Notice that the connection string, placed within quotes, is separate from the '''User=''' and '''Password=''' parameters. If the additional parameters are specified, BR will augment the connection string with '''UID=''' and '''PWD=''' parameters. Do not confuse connection string valid parameters with BR augmentation parameters.

Gordon.dye: /* ODBC-MANAGER */

2023-07-31T01:30:56Z

ODBC-MANAGER

← Older revision		Revision as of 01:30, 31 July 2023
Line 55:		Line 55:

	The following is a sample program that will use the ODBC-MANAGER to identify the proper connection string.		The following is a sample program that will use the ODBC-MANAGER to identify the proper connection string.
	* Note: This will not work in Client Server		* Note: This will not work in Client Server because the operation is performed on the server and this process depends on the user's settings.

	00010 PRINT Newpage		00010 PRINT Newpage

Gordon.dye: /* CONNECTSTRING (DSN Less) */

2023-07-31T01:25:25Z

CONNECTSTRING (DSN Less)

← Older revision		Revision as of 01:25, 31 July 2023
Line 14:		Line 14:
	===CONNECTSTRING (DSN Less)===		===CONNECTSTRING (DSN Less)===
	Syntax:		Syntax:
	CONFIG DATABASE <db-ref> CONNECTSTRING="<Driver>={Microsoft Access Driver (*.mdb)} DBQ=C:\inetpub\wwwroot\BegASP\Chapter.14\Contact.mdb"		CONFIG DATABASE <db-ref> CONNECTSTRING="<Driver>={Microsoft Access Driver (*.mdb)} DBQ=C:\inetpub\wwwroot\BegASP\Chapter.14\Contact.mdb" [, USER= <department> \| LOGIN_NAME \| ? ] [, PASSWORD= <dept-password> \| BR_PASSWORD \| ? \| PASSWORDD=<encrypted-password> ]

	'''Sample Connection Strings:'''		'''Sample Connection Strings:'''
Line 22:		Line 22:

	"db-ref" is the database reference.		"db-ref" is the database reference.
	"server" is the SQL Server [FQDN] or IP Address
	"database" is the [SQL Server Database]		"server" is the SQL Server [FQDN] or IP Address.
	"username" is the [SQL Server User Name]
	"password" is the [SQL Server Password]		"database" is the [SQL Server Database].

			"username" is the [SQL Server User Name].

			"password" is the [SQL Server Password].

	Using a SQL Server /w Windows Authentication:		Using a SQL Server /w Windows Authentication:
	CONFIG database db-ref connectstring="DRIVER=SQL Server;Initial Catalog=database;Persist Security Info=True;MultipleBC_TableResultSets=True; Database=database;SERVER=server" ~~Login_Name~~=username Password=BR_PASSWORD		CONFIG database db-ref connectstring="DRIVER=SQL Server;Initial Catalog=database;Persist Security Info=True;MultipleBC_TableResultSets=True; Database=database;SERVER=server" User=username Password=BR_PASSWORD

	Notice that the connection string, placed within quotes, is separate from the '''~~Login_Name~~=''' and '''Password=''' parameters. If the additional parameters are specified, BR will augment the connection string with '''UID=''' and '''PWD=''' parameters. Do not confuse connection string valid parameters with BR augmentation parameters.		Notice that the connection string, placed within quotes, is separate from the '''User=''' and '''Password=''' parameters. If the additional parameters are specified, BR will augment the connection string with '''UID=''' and '''PWD=''' parameters. Do not confuse connection string valid parameters with BR augmentation parameters.

	"db-ref" is the database reference.		"db-ref" is the database reference.

	"server" is the SQL Server [FQDN] or IP Address		"server" is the SQL Server [FQDN] or IP Address.

	"database" is the [SQL Server Database]		"database" is the [SQL Server Database].

	"username" is the [SQL Server User Name]		"username" is the [SQL Server User Name].

	BR_PASSWORD will use the users Active Directory password to connect to the SQL Server.		BR_PASSWORD will use the users Active Directory password to connect to the SQL Server.

	"SQL Server" is one of several choices for SQL Server, another choice would be SQL Server Native Client 11.0		"SQL Server" is one of several choices for SQL Server, another choice would be SQL Server Native Client 11.0.

	===ODBC-MANAGER===		===ODBC-MANAGER===

Gordon.dye: /* DSN */

2023-07-31T01:17:49Z

DSN

← Older revision		Revision as of 01:17, 31 July 2023
Line 6:		Line 6:
	===DSN===		===DSN===
	Syntax:		Syntax:
	CONFIG DATABASE <db-ref> DSN=<dsn-ref> [, USER= <department> \| LOGIN_NAME \| ? ] [, {PASSWORD= <dept-password> \| BR_PASSWORD \| ? } \| ~~PASSWORD~~=<encrypted-password> ]		CONFIG DATABASE <db-ref> DSN=<dsn-ref> [, USER= <department> \| LOGIN_NAME \| ? ] [, PASSWORD= <dept-password> \| BR_PASSWORD \| ? \| PASSWORDD=<encrypted-password> ]
	The ? indicates prompt		The ? indicates prompt

	Example:		Example:
	EXECUTE 'CONFIG DATABASE CLS_Data DSN="MyData"'		EXECUTE 'CONFIG DATABASE CLS_Data DSN="MyData" , PASSWORDD= <encrypted-password>'

	===CONNECTSTRING (DSN Less)===		===CONNECTSTRING (DSN Less)===

Gordon.dye: /* CONNECTSTRING (DSN Less) */

2023-07-31T01:09:41Z

CONNECTSTRING (DSN Less)

← Older revision		Revision as of 01:09, 31 July 2023
Line 28:		Line 28:

	Using a SQL Server /w Windows Authentication:		Using a SQL Server /w Windows Authentication:
	CONFIG database db-ref connectstring="DRIVER=SQL Server;Initial Catalog=database;Persist Security Info=True;MultipleBC_TableResultSets=True; Database=database;SERVER=server~~;Login Name~~=username;Password=BR_PASSWORD"		CONFIG database db-ref connectstring="DRIVER=SQL Server;Initial Catalog=database;Persist Security Info=True;MultipleBC_TableResultSets=True; Database=database;SERVER=server" Login_Name=username Password=BR_PASSWORD

			Notice that the connection string, placed within quotes, is separate from the '''Login_Name=''' and '''Password=''' parameters. If the additional parameters are specified, BR will augment the connection string with '''UID=''' and '''PWD=''' parameters. Do not confuse connection string valid parameters with BR augmentation parameters.

	"db-ref" is the database reference.		"db-ref" is the database reference.

GomezL: /* ODBC-MANAGER */

2017-01-23T20:20:23Z

ODBC-MANAGER

← Older revision		Revision as of 20:20, 23 January 2017
Line 49:		Line 49:

	The following is a sample program that will use the ODBC-MANAGER to identify the proper connection string.		The following is a sample program that will use the ODBC-MANAGER to identify the proper connection string.
	* Note: This will not work in Client Server *		* Note: This will not work in Client Server

	00010 PRINT Newpage		00010 PRINT Newpage
	00011 IF Env$("br_model")="CLIENT_SERVER" THEN PRINT "Warning, you cannot connect to ODBC-MANAGER in Client Server Mode"		00011 IF Env$("br_model")="CLIENT_SERVER" THEN PRINT "Warning, you cannot connect to ODBC-MANAGER in Client Server Mode"
	00020 EXECUTE "~~config database~~ Test_DB ODBC-MANAGER" ERROR CONNECT_ERROR		00020 EXECUTE "Config Database Test_DB ODBC-MANAGER" ERROR CONNECT_ERROR
	00030 PRINT "Connection String is:" !:		00030 PRINT "Connection String is:" !:
	PRINT Env$("STATUS.DATABASE.[TEST_DB].CONNECTSTRING")		PRINT Env$("STATUS.DATABASE.[TEST_DB].CONNECTSTRING")
	00099 STOP		00099 STOP
	00100 CONNECT_ERROR: !		00100 CONNECT_ERROR: !
	00110 PRINT "Error Connecting - Err:";Err;" Line:";Line;" Syserr:";Syserr$		00110 PRINT "Error Connecting - Err:";Err;" Line:";Line;" Syserr:";Syserr$


	[[Category:All Parameters]]		[[Category:All Parameters]]

GomezL: /* ODBC-MANAGER */

2017-01-23T20:19:25Z

ODBC-MANAGER

← Older revision		Revision as of 20:19, 23 January 2017
Line 47:		Line 47:

	Using ODBC Manager as the parameter will allow the end user to select the desired data source.		Using ODBC Manager as the parameter will allow the end user to select the desired data source.

			The following is a sample program that will use the ODBC-MANAGER to identify the proper connection string.
			* Note: This will not work in Client Server *

			00010 PRINT Newpage
			00011 IF Env$("br_model")="CLIENT_SERVER" THEN PRINT "Warning, you cannot connect to ODBC-MANAGER in Client Server Mode"
			00020 EXECUTE "config database Test_DB ODBC-MANAGER" ERROR CONNECT_ERROR
			00030 PRINT "Connection String is:" !:
			PRINT Env$("STATUS.DATABASE.[TEST_DB].CONNECTSTRING")
			00099 STOP
			00100 CONNECT_ERROR: !
			00110 PRINT "Error Connecting - Err:";Err;" Line:";Line;" Syserr:";Syserr$


	[[Category:All Parameters]]		[[Category:All Parameters]]