Hi there, I want make a script with gui, that connects to a database, runs a query and returns the results. I want to use textboxes to create the connectionstring.
My problem is, If i run it, without gui, it works perfectly, but when I want to use textboxes, it returns an error, but only for the User ID.
Help?
This works fine:$scon.ConnectionString = "Data Source=localhost;Initial Catalog=adventure;Connection Timeout=0;User ID=sa;Password=****;"
This isn't:
$instance = $txtbox_instance.Text
$catalog = $txtbox_dta.Text
$usr = $txtbox_name.Text
$pass = $txtbox_pass.Text
$tempstring = "Data Source=$instance;Initial Catalog=$catalog;Connection Timeout=0;User ID=$usr;Password=$pass;"