Quote problem

[stockboy]

In this script I make a connection to an oracle databank (DEV1).

$ado = ObjCreate( "ADODB.Connection" )

With $ado

.ConnectionString =("Provider='OraOLEDB.Oracle';Data Source='DEV1';User Id='x';Password='x';")

.Open

EndWith

I want to replace this DEV1 to a variable.

Something like this (but it's not working - problem with the quotes I guess):

$var =[name databank]

$ado = ObjCreate( "ADODB.Connection" )

With $ado

.ConnectionString =("Provider='OraOLEDB.Oracle';Data Source=$var;User Id='x';Password='x';")

.Open

EndWith

Anybody?

TNX

[exodius]

Use an Ampersand (&) to concatenate your variables into strings.

$var =[name databank]
$ado = ObjCreate( "ADODB.Connection" )
With $ado
.ConnectionString =("Provider='OraOLEDB.Oracle';Data Source=" & $var & ";User Id='x';Password='x';")
.Open
EndWith

[stockboy]

It's quite simple but I couldn't find it...

TNX a lot!

[exodius]

No prob, it's just one of those things.