hi!
when start my project the wincc v6.0 make a dinamic odbc connection to SqlServer.

name of this connection is : "CC_Tc3_mtc2_08_03_06_14_00_45"
name of the project is: "Tc3_mtc2"

i make a vb script for manipulate a personal data in this user databases.

Dim baza
baza="CC_Tc3_mtc2_08_03_06_14_00_45"

'***************************************************
'***************************************************

Sub populare_tabela

Dim objConnection
Dim strConnectionString
Dim strSQL
Dim objCommand
Dim i

'definire string conexiune
'strConnectionString = "Provider=MSDASQL;DSN=CC_Tc3_mtc2_08_03_13_13_08_48;UID=;PWD=;"
strConnectionString = "Provider=MSDASQL;DSN="&baza&";UID=;PWD=;"

etc...

Connection is work.. but when duplicate this project to another pc the name of connection is change like this "CC_Tc3_mtc2_08_03_06_17_10_22".

How is posible to read the name of connection dinamic from vbs ?

Thank's to all!

select [name] from sys.databases where [name] LIKE 'CC_' + @projectname + '%' and LEN([name]) = LEN(@projectname) + 21

dunno why you don'thave that @DatasourceNameRT inner tag

select name from master.dbo.sysdatabases where name like 'CC_%' and name not like '%R'

Thank's