General information
Title:
Design time connections
Environment versions
Network:
Windows 2008 Server
I created a Sql Server project so I could play with writing CLR functions. During the project set-up I was required to chose a data source that is stored in the project. All fine and good. Functions written, deployed, and working.
Now I want to change the "hard-wired" connection so I can deploy my functions to another database on the same server. I have gone to the properties tab on the project and it won't let me change the connection string. The problem is when I select the server instance and the new database target it cannot connect. Odd thing is I can see the new database I want in the server explorer in the IDE. I tried changing it in the xxx.csproj.user file of the project ( the XML ) and it basically ignored it and kept using the old connection string. I have looked in every file in the project and cannot find any other place I reference the connect string. Where else might it be stored?
Both the old and new database exist on the server and I have full permissions. The server instance also allows remote connections and has the CLR option turned on.
Any ideas and while I am at it how do I allow the connection string to be changed at runtime and still be allowed to use the context connection attribute?
Thanks,
MW
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only