Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Dec 20, 2008 07:38 PM by AndersVLule
Feb 13, 2007 08:16 AM|LINK
Can you please confirm that I now need all of these files in my App_Code folder:
Feb 13, 2007 08:36 AM|LINK
Feb 13, 2007 09:02 AM|LINK
Sorry James, not sure how to do this - can you explain. I also need to be clear about what files to copy to the production server.
Feb 13, 2007 09:58 AM|LINK
The key file here is the .DLL. This has all the code for the SessionExpressionBuilders in it compiled and ready to go.
When you deploy to production, you just need to deploy that .DLL in the Bin folder!
Feb 13, 2007 12:29 PM|LINK
OK, I think I have the dll's in the right place and working but I couldn't follow your instructions. I am working with a solution that just contains the web site I am developing, no projects, so I think your instruction don't work?
Feb 13, 2007 02:00 PM|LINK
Then proceed as before!
Feb 13, 2007 02:30 PM|LINK
OK, thanks, done all of that but I now get a compilation error in my code wherever I use the SessionConnectionStringsExpressionBuilder:
Error 10 Name 'SessionConnectionStringsExpressionBuilder' is not declared. C:\Documents and Settings\Cliff\My Documents\My Webs\DataLabDotNet\Default.aspx 98 17 C:\...\DataLabDotNet\
Feb 13, 2007 02:46 PM|LINK
OK, I think I got it!
The calls now need to be of the form:
Feb 13, 2007 02:59 PM|LINK
You need to build your ConnectionStringSetting as per your original code, and then pass that in... e.g.
Dim objClientConnection As New ConnectionStringSettings
objClientConnection.Name = "ClientDBConnection"
objClientConnection.ConnectionString = "xxxxxxxxx" ' substitute whatever you would have entered into Session("ClientDBConnectionString")
objClientConnection.ProviderName = "System.Data.SqlClient"
Alternatively, you could do this...
SessionExpressionBuilders.SessionConnectionStringsExpressionBuilder.AddSettings("ClientDBConnection", "xxxxxxxxx", "System.Data.SqlClient")
' substitute xxxxxx for whatever you would have entered into Session("ClientDBConnectionString")
' or even
' as I believe the SQL client is the default!
Feb 13, 2007 03:27 PM|LINK
works fine now because I have the connection string held in the session variable.
I promise I will leave you in peace soon - you have been amazingly patient!