[DBI:ODBC] DBI SQL Connectionstring mit Application Name (solved) (Fragen zu Perl-Modulen) - Perl-Community.de

Start · Board · Anwendungen/Programme/Skripte in Perl · Fragen zu Perl-Modulen

2023-12-08 23:12:04
Europe/Berlin
Login (Register)
- Preferences
- Statistics
Jemand zu Hause?
0 users online

[thread]20990[/thread]

submit to reddit

[DBI:ODBC] DBI SQL Connectionstring mit Application Name [solved]

[solved]

Tags: DBI Connectionstring Application Name Similar Threads

Readers: 10

Articles: hide open all | hide show old branches

+2 replies
Gustl

2020-06-23 11:27
User since
2011-01-27
440 articles
BenutzerIn
Hallo zusammen,

ich habe folgenden Connectionstring:
Code: (dl )

DBI:ODBC:Driver={SQL Server Native Client 11.0};Server=139.XXX.XXX.XXX,6201;Trusted_Connection=yes
Es wird mit einer SQL Datenbank erfolgreich verbunden.

Der Connectionsstring in zb .net:
Code: (dl )

Data Source=139.XXX.XXX.XXX,6201;Initial Catalog=DB;Integrated Security=SSPI; Application Name=MyAppName
Nun möchte ich auch in Perl der SQL Datenbank den Application Name mitgeben.
Code: (dl )

DBI:ODBC:Driver={SQL Server Native Client 11.0};Server=139.XXX.XXX.XXX,6201;Trusted_Connection=yes;Application Name=MyAppName
Application Name=MyAppName funktioneirt aber im Connectionstring nicht.

Weis wer rat?
- Gustl
  
  2020-06-23 20:19
  User since
  2011-01-27
  440 articles
  BenutzerIn
  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 all threads created 2020-06-23 11:27.