on 10-24-2013 7:29 PM
I am switching a project from a normal SQL Database to Local Database that will be packaged and deployed with the project.. first I can't seem to figure out in the "Set data location" which connection type I should be using.. It is not the normal ADO. Something did seem to be created when I added the Database.. Looks like ProjectName.Database.DatabaseName.. Property says it is ADO.net(XML)... But when you open it to look for tables & stored procedures it just says "No Items Found".. I see nothing I can do to point to the "items"..
However I connect, I do need the path not to be hardcoded, (whether I need to change the path in C# code programically doesn't matter).. But if the path is hardcoded, I need some advice on how to redirect the path.. That's because once packaged & deployed, I don't have total authority on where people will install it..
Just hoping to find some of you having navigated these waters before who can help me..
thanks.
Hi Wendy,
What kind of a SQL DB is it and what is it based on? MS SQL Server or ???? And what kind of local database are you using?
Most DB's will use and have an ODBC Driver available, easiest way to manage this, users simply need to create the System DSN or your install scripts can do it for them.
Don
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.