Insert variables for Server info

[=?Utf-8?B?TWlrZVM=?=]

Can anyone tell me how to insert variables for server info in a SQL
connection statement.

For example, in the following statement:
("Server=KIN-SSQL02;" & "Database=FTQ;" & "User ID=abc;" & "Password=xyz;")

I tried using the following variables, but it doesn't work.
'("Server='varServer';" & "Database='varDatabase';" & "User
ID='varUserName';" & "Password='varPassword';")

In debug mode, I can hover over the variables and it shows the correct
information but I still get an error.

Thanks in advance,

Mike

[Jack Jackson]

On Mon, 1 Oct 2007 10:11:06 -0700, MikeS
<Mi***@discussions.microsoft.comwrote:

>Can anyone tell me how to insert variables for server info in a SQL
connection statement.

For example, in the following statement:
("Server=KIN-SSQL02;" & "Database=FTQ;" & "User ID=abc;" & "Password=xyz;")

I tried using the following variables, but it doesn't work.
'("Server='varServer';" & "Database='varDatabase';" & "User
ID='varUserName';" & "Password='varPassword';")

In debug mode, I can hover over the variables and it shows the correct
information but I still get an error.

Anything in a text string is just text. There is no way to embed a
variable name in a text string and have the variable name evaluated.

I think the clearest way is to use String.Format:

String.Format("Server={0};Database={1};User ID={2};Password={3}", _
New Object() {varServer, varDatabase, varUserName, varPassword})

You can also use StringBuilder, or just concatenate strings:
"Server=" + varServer + ";Database=" + varDatabase ...

[rowe_newsgroups]

On Oct 1, 1:11 pm, MikeS <[e-mail]:

Can anyone tell me how to insert variables for server info in a SQL
connection statement.

For example, in the following statement:
("Server=KIN-SSQL02;" & "Database=FTQ;" & "User ID=abc;" & "Password=xyz;")

I tried using the following variables, but it doesn't work.
'("Server='varServer';" & "Database='varDatabase';" & "User
ID='varUserName';" & "Password='varPassword';")

In debug mode, I can hover over the variables and it shows the correct
information but I still get an error.

Thanks in advance,

Mike

I suspect your trouble is in your string concatenation. Try:

Dim connectString As String =
String.Format("Server={0};Database={1};User ID={2};Password={3};",
varServer, varDatabase, varUserName, varPassword)

Thanks,

Seth Rowe

[=?Utf-8?B?TWlrZVM=?=]

Actually that didn't work but I made a couple of changes that did work.

("Server=" & varServer & ";" & "Database=" & varDatabase & ";" & "User
ID=" & varUserName & ";" & "Password=" & varPassword & ";")

This way I can get the values from the registry and not "hard code" it in
the program.

Thanks for your input.

Mike

"rowe_newsgroups" wrote:

On Oct 1, 1:11 pm, MikeS <[e-mail]:

Can anyone tell me how to insert variables for server info in a SQL
connection statement.

For example, in the following statement:
("Server=KIN-SSQL02;" & "Database=FTQ;" & "User ID=abc;" & "Password=xyz;")

I tried using the following variables, but it doesn't work.
'("Server='varServer';" & "Database='varDatabase';" & "User
ID='varUserName';" & "Password='varPassword';")

In debug mode, I can hover over the variables and it shows the correct
information but I still get an error.

Thanks in advance,

Mike

I suspect your trouble is in your string concatenation. Try:

Dim connectString As String =
String.Format("Server={0};Database={1};User ID={2};Password={3};",
varServer, varDatabase, varUserName, varPassword)

Thanks,

Seth Rowe

[Jack Jackson]

On Mon, 01 Oct 2007 11:11:22 -0700, rowe_newsgroups
<ro********@yahoo.comwrote:

>On Oct 1, 1:11 pm, MikeS <[e-mail]:

>Can anyone tell me how to insert variables for server info in a SQL
connection statement.

For example, in the following statement:
("Server=KIN-SSQL02;" & "Database=FTQ;" & "User ID=abc;" & "Password=xyz;")

I tried using the following variables, but it doesn't work.
'("Server='varServer';" & "Database='varDatabase';" & "User
ID='varUserName';" & "Password='varPassword';")

In debug mode, I can hover over the variables and it shows the correct
information but I still get an error.

Thanks in advance,

Mike

I suspect your trouble is in your string concatenation. Try:

Dim connectString As String =
String.Format("Server={0};Database={1};User ID={2};Password={3};",
varServer, varDatabase, varUserName, varPassword)

String.Format takes a maximum of 3 separate replacement arguments. For
more you have to pass an array.

[rowe_newsgroups]

String.Format takes a maximum of 3 separate replacement arguments. For

more you have to pass an array.

Umm... not quite. It takes 3 separate named arguments before you pass
the values as a ParamArray. Which acts just the same as the "normal"
String.Format with 3 or less arguments.

For example:

////////////////////
Module Module1

Sub Main()

Dim s As String = String.Format("{0} {1} {2} {3} {4} {5}",
"one", "two", "three", "four", "five", "six")
Console.WriteLine(s)

Console.Read()

End Sub

End Module
///////////////////

That passes six arguments in the exact same format as if it were used
with 3 or less arguments - there is no need to declare a separate
array of strings and pass it in.

Thanks,

Seth Rowe

[Jack Jackson]

On Tue, 02 Oct 2007 11:35:33 -0700, rowe_newsgroups
<ro********@yahoo.comwrote:

>String.Format takes a maximum of 3 separate replacement arguments. For
more you have to pass an array.

Umm... not quite. It takes 3 separate named arguments before you pass
the values as a ParamArray. Which acts just the same as the "normal"
String.Format with 3 or less arguments.

For example:

////////////////////
Module Module1

Sub Main()

Dim s As String = String.Format("{0} {1} {2} {3} {4} {5}",
"one", "two", "three", "four", "five", "six")
Console.WriteLine(s)

Console.Read()

End Sub

End Module
///////////////////

That passes six arguments in the exact same format as if it were used
with 3 or less arguments - there is no need to declare a separate
array of strings and pass it in.

I see that the code you posted works, but I don't understand why. Can
you explain? What is ParmArray? I Googled for it and didn't find any
interesting results.

[Jack Jackson]

On Wed, 03 Oct 2007 03:25:39 -0700, rowe_newsgroups
<ro********@yahoo.comwrote:

>http://msdn2.microsoft.com/en-us/lib...9h(VS.80).aspx

Thank you very much. That is very helpful.

[Jack Jackson]

On Wed, 03 Oct 2007 09:46:51 -0700, Jack Jackson
<ja********@pebbleridge.comwrote:

>On Wed, 03 Oct 2007 03:25:39 -0700, rowe_newsgroups
<ro********@yahoo.comwrote:

>>http://msdn2.microsoft.com/en-us/lib...9h(VS.80).aspx

Thank you very much. That is very helpful.

Any idea why String.Format has three overloads for one, two and three
replacement arguments? It doesn't seem like those serve any real
purpose with the ParamArray overload.

[rowe_newsgroups]

Any idea why String.Format has three overloads for one, two and three

replacement arguments? It doesn't seem like those serve any real
purpose with the ParamArray overload.

Fortunately for me, I recalled seeing a question similar to this in
the C# newsgroup:

http://groups.google.com/group/micro...0e63e96f8a089f

Basically, it's either for readability or compatibility with
other .Net languages.

Thanks,

Seth Rowe