I have a connection string
="/f c:\test\test2\test2\package.dtsx /set \package.variables[User::varfil].Value;" & Parameters!varempid.Value
but its not returning any results. I need a valid connection string.
View Complete Post
but its not returning any results.
I have designed a few pages which use LINQ datasources and Gridviews to maintain data.
I have built a data layer which happily uses System.Web.Configuration.WebConfigurationManager.ConnectionStrings("myConnectionString").ConnectionString
However, the LINQ data source controls use Settings.designer.vb MySettings class definition which is auto generated and doesn't except the above Connection string.
I have an SSAS database (Analysis Services 2005) which connects to Oracle for the data. I have the userid and passwordsaved in the connection string.
If I deploy the cube from Visual Studio I DON't have to manually edit the Data Source in the server to input the userid and password. The information is retained.
If I do a build and then deploy .asdatabase file using Deployment Wizard (Microsoft.AnalysisServices.Deployment.exe), the connection information dissappears. I have "Remove Passwords" = False in Project configuration.ÃÂ So when you build the project there will be a file with extension .assecurityinformation which holds the encrypted security info. Somehow
deployment wizard doesn't look at this file.
After the build I execute this command
Microsoft.AnalysisServices.Deployment.exeÃÂ .\Project.asdatabase /s:.\Deployment.log
I tried interactively and silent mode. Either way I cannot deploy the project with the userid and password in it.
I have three connection strings for my web application (ASP.Net) as MVC2 provides by default.Bar the locations and the names, the syntax is identical, but in the second connection string, it keeps returning "Keyword not supported: 'data source'." EVEN THOUGH IT'S IDENTICAL. D:
Please help! I've tried changing the Syntax to include a "Metadata" tag, still didn't work!
I'm using CE 4.0 in a Silverlight app and my connection string is:
Data Source=C:\MyApp\MyApp.Web\App_Data\MyAppDB.sdf;Password=***********;Persist Security Info=True
I don't want a hard coded file path in the connection string. Is it possible to make this configurable, or determine directory its located in at runtime?