Hi
I'm having problems setting up a connection string variable. I've created a connection in the connection manager. Set the svrname & dbname, checked that it works, then in the connection properties set the connectionstring expression to be the my connectionstring variable. This doesn't want to work though.
The connectionstring is "Data Source=DevSvr;Initial Catalog=DevDb;Provider=SQLNCLI.1;Integrated Security=SSPI;"
The error i receive is connection "Data Source=DevSvr;Initial Catalog=DevDb;Provider=SQLNCLI.1;Integrated Security=SSPI;" is not found.
Any help would be appreciated. Are there any tutorials as to set connectionstrings as variables as I can't seem to find any.
Cheers
Lbob
(I inadvertently put this in the Business Intelligence forum as well)