Using VBScript parameters in a connection string

Question

I'm using a vbs script to query SQL Servers.

And in the connection string, i'm trying transfer the following parameters: Server Name (PKNSQLEXP07\SQLINST7) and Port Number (2890).

Problem is, that i know that parameters in VBScript need to be outside the connection string, but i'm not sure how to accomplish that.

This is my connection string, without the parameters:

strConnection = "Driver={SQL Server};Server=PKNSQLEXP07\SQLINST7,2890;Database=master;Trusted_Connection=TRUE"

And this is with Parameters:

    ConnectionString = Wscript.Arguments(0)
TcpPort = Wscript.Arguments(1)

strConnection = "Driver={SQL Server};Database=master;Trusted_Connection=TRUE;Server=" & ConnectionString &,& TcpPort
objCN.Open strConnection

The parameters (ConnectionString and TcpPort) should be with a comma sign between them.

But i have no luck so far, with my current connection string with the parameters.

JNevill · Accepted Answer · 2019-01-14 15:09:56Z

1

You are concatenating together strings to make a big string. You have two types of strings.

Strings in variables that you DO NOT want to quote otherwise they will be treated like...
String Literals, which are just strings in quotes like "Hi, I'm a string".

You are very close with your attempt, but your comma is a String Literal, which means that thing needs to be in quotes:

strConnection = "Driver={SQL Server};Database=master;Trusted_Connection=TRUE;Server=" & ConnectionString & "," & TcpPort

As a debugging step you can use MsgBox strConnection to see the string that is derived from this concatenation before firing it off to the database. That should give you a lot of insight into what's going on in that line.

answered Jan 14, 2019 at 15:09

JNevill

50.6k4 gold badges46 silver badges71 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using VBScript parameters in a connection string

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related