Thread [DBI:ODBC] DBI SQL Connectionstring mit Application Name (1 answers)
Opened by Gustl at 2020-06-23 11:27

Gustl
 2020-06-23 20:19
#192393 #192393
User since
2011-01-27
441 Artikel
BenutzerIn
[Homepage]
user image
Habe nun unter http://docs.activestate.com/activeperl/5.26/perl/l... folgendes gefunden:

MS SQL Server supports 2 additional connection attributes which you can use to set application name and the workstation name:

APP specifies the application name recorded in the program_name column in master.dbo.sysprocesses.

WSID sets the workstation name recorded in the hostname column in master.dbo.sysprocesses.

Code: (dl )
1
2
my $h = DBI->connect('dbi:ODBC:DSN=mydsn;APP=appname;WSID=wsname',
'dbuser', 'dbpass');

View full thread [DBI:ODBC] DBI SQL Connectionstring mit Application Name