DB Checkpoint connection to Advantage tables

´Hi there,



I have a small problem regarding the DB Checkpoint connection string (TC 8).



I want the same DB Checkpoint to work parallely for multiple DB's on multiple VMWare ?



Below is the code sample i am trying to run for multiple DB's:

----------------------------------------------------------------------------------------



sub ConStringExample(Chkpnt)

 

  ' Specifies a DB Table element

  Set DBTab = DBTables.Check_Info

'    ' Specifies a connection string

    

  DBtab.ConnectionString = "Provider=SQLOLEDB.1;" + _

  "Data Source=23.34.234.34;" + _

  "Initial Catalog= &Chkpnt;"

 

  DBTab.Check

End sub

 

 

sub abc()

call  ConStringExample(ODB_Test_2013) 

end sub

------------------------------------------------------------------------------------------



Above I am trying to paramterize the DB name by passing the parameter to the subroutine 'ConStringExample'



'Check_Info' is my Checkpint name.

I am not able to run this subroutine. As it fails to accept the variable in 'Initial Catalog' -field of Connectionstring.





Can anyone guide me on this ... I have tried to parameterize the Checkpoint Value but that also doesnt work.



The question is Can I Parameterize ConnectionString contents??





Regards,

Uj





[Sorry if m posing at wrong location :( .]