Close concatenated odbc string connection with variable

[dbcoh316]

Hello!

I am unable to figure out how to close the end of my DB string connection, in conjunction with a variable to change the database name.


'Code start
If DATABASE = "EDGEDEV" THEN
var_server = "VISUALERP\DEV"
ELSE
var_server = "VISUALERP"
END IF


SET objConnection = CreateObject("ADODB.Connection")
objConnection.Open "Provider=SQLOLEDB;User ID=USERNAME;Password=PASSWORD!;DATABASE="&DATABASE&";SERVER=" & var_server & "

'Code End

The trouble is at the end after the SERVER = my variable then it needs to be closed with a quotation mark but i'm getting some vbscript error about some unterminated string constant.

How do I close my connection?

Thank you in advance!

-David

 

[mikrom]

try this:

DATABASE = "EDGEDEV"

If DATABASE = "EDGEDEV" THEN
var_server = "VISUALERP\DEV"
ELSE
var_server = "VISUALERP"
END IF

conn_str = "Provider=SQLOLEDB;User ID=USERNAME;Password=PASSWORD!;DATABASE="&DATABASE&";SERVER=""" & var_server & """"

wscript.echo conn_str

'SET objConnection = CreateObject("ADODB.Connection")
'objConnection.Open conn_str

Output:

Provider=SQLOLEDB;User ID=USERNAME;Password=PASSWORD!;DATABASE=EDGEDEV;SERVER="VISUALERP\DEV"

 

[xwb]

If it doesn't connect, try adding \\ in front of the server name.