Connection Reuse

• liferily

  SSC Journeyman

  Points: 82

  More actions

  June 5, 2003 at 2:52 am

  #105667

  I want to repeatedly reuse a connection, but cannot get it work, any ideas?

  ---------THIS CODE WORKS --------------

  set LogConn = CreateObject("ADODB.Connection")

  LogConn.Open "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=master;Data Source=(local)"

  LogSQL = "INSERT INTO MIGRATIONLOG (...) VALUES (...)"

  logConn.Execute(LogSQL)

  LogConn.Close

  set LogConn = nothing

  -------------THIS CODE DOES NOT WORK ------------

  set pkg = DTSGlobalVariables.Parent

  set LogConn = pkg.Connections("master")

  LogSQL = "INSERT INTO MIGRATIONLOG (...) VALUES (...)"

  LogConn.Execute(LogSQL) - FAILS HERE

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  June 9, 2003 at 1:34 pm

  #460458

  Variable not in scope or not opened?

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  Connect with me on LinkedIn