Dim GBPCConnectionString
set conn = server.createobject("ADODB.Connection")
conn.connectionstring = "Provider=SQLOLEDV;Data source=machinename\sqlexpress; initial catalog=GBPC; user id=Test; password=XXX"
GBPCConnectionString = conn.connectionstring


' refer to http://forums.whirlpool.net.au/forum-replies-archive.cfm/1049167.html for more background