Cannot set Application Name in SQLOLEDB connection string

• vadba

  SSChampion

  Points: 11133

  More actions

  May 10, 2004 at 1:27 pm

  #76160

  I'm looking for a list of OLE DB connection string parameters for SQL Server 2000 (SQLOLEDB provider).

  I'm connecting to a SQL Server 2000 SP3a database from Powerbuilder 8 using OLE DB. I can't seem to get the application name to show up in sysprocesses.program_name. My connection string contains the following:

  PROVIDER='SQLOLEDB',Application Name='MyApp',

  DATASOURCE='MyServer',PROVIDERSTRING='database=MyDB'

  Anybody know the correct syntax/spelling for "Application Name=" ?

  ( An ADO example for VB would be ok )

  Thanks,

  Mike

• Jonathan Stokes

  SSCrazy Eights

  Points: 9861

  More actions

  May 10, 2004 at 1:53 pm

  #505869

  This site is great for getting ADO connection strings to multiple dbs.

   

  http://www.able-consulting.com/ADO_Conn.htm

   

  A better one for applpication name is contained in:

   

  http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q193/1/35.asp&NoWebContent=1

   

  Hope either helps.

  ---

  ------------------------------
  The Users are always right - when I'm not wrong!

• Phil.Nicholas

  SSCrazy

  Points: 2147

  More actions

  May 11, 2004 at 2:46 am

  #505928

  Sometimes applications force the appname to say Powerbuilder etc. and dont allow you to set this attribute, one way round this is to use a file dsn and set the app name in there.

  
  Phil Nicholas

• Jonathan Stokes

  SSCrazy Eights

  Points: 9861

  More actions

  May 12, 2004 at 3:27 am

  #506094

  Tried a few combinations and finally found it.

  Syntax is:

  App=application_name

  No spaces between the equal sign. I tried this in a vb package and ms access and both work.

  ---

  ------------------------------
  The Users are always right - when I'm not wrong!

• kyochum

  Grasshopper

  Points: 14

  More actions

  November 19, 2004 at 12:55 pm

  #530895

  I am trying this from an Access2003 adp without success.

  strConnect = "Provider=SQLOLEDB.10;Server=Server;Initial Catalog=MyDB;UID=Me;Pwd=Mine;App=MyCustomString;"

  Does the order matter in the connection string?  Any suggestions?

• Mark Copenhaver

  Grasshopper

  Points: 23

  More actions

  November 28, 2004 at 3:55 pm

  #531659

  Dunno if you've solved this yet, but I'm connecting from PowerBuilder 9 using OLEDB and the following connection string and I'm successfully setting the application name:

  Provider='SQLOLEDB',DataSource='myserver',Database='mydbname',PROVIDERSTRING='App=myappname',IntegratedSecurity='SSPI'