tags:

views:

261

answers:

1
Q: 

Powershell Script not accepting $ (Dollar) sign

I am trying to open a SQL data connection using powershell script and my password contains a $ sign:

$cn = new-object system.data.SqlClient.SqlConnection("Data Source=DBNAME;Initial Catalog=Catagory;User ID=User;Password=pass$word;")

When I try to open a connection it says Login failed.

+9  A: 

Did you try escapting it by using - backtick (`) as an escape character for the dollar sign ($).

Also, did you try enclosing the statement in single-quotes instead of the double-quotes you are using now?

Shankar Ramachandran  2009-10-23 18:23:40
Works perfectly with single quotes ! Thanks !
Murtaza RC  2009-10-23 19:39:44

related questions

How do I access the non-IPM_SUBTREE Public Folder Tree with WMI?
How do I create a custom type in PowerShell for my scripts to use?
iTunes warning message on quit due to scripting
Creating batch jobs in PowerShell
Troubleshooting a NullReference exception in a service
Windows Powershell book - any good experiences?
Windows 2003 Scheduled Task Cmdlet (v 1.0)
How to get started with PowerShell?
get file version in powershell
Set up PowerShell Script for Automatic Execution
Accessing .NET components from Powershell
PowerShell - How do I pass string parameters correctly?
execute shortcuts like programs in powershell
How do I compare two arrays of DataRow objects in PowerShell?
PowerShell App.Config
PowerShell - how do I do a string replacement in a function?
PowerShell FINDSTR eqivalent?
How do I make Powershell run a batch file and then stay open?
quoting System.DirectoryServices.ResultPropertyCollection
Powershell's Invoke-Expression missing param
How do you impersonate an Active Directory user in Powershell?
Why don't my powershell scripts run?
Can I copy files to a Network Place from a script or the command line?
How do you use PowerShell?
What are your favorite Powershell Cmdlets?