Last post Mar 28, 2017 07:55 PM by wphr2101
Mar 28, 2017 04:44 PM|wphr2101|LINK
I am using a .dll file which is compiled from a database. We have 2 kinds of database: Test and Product. Everything we create to the database Table, View, Store Procedure... are created under Test database and later on Product. We also have a C# project
which is compiled and used as a library file of type DLL. In the past, we refer to the Test database as a source to update but we recently switch Product database as the source and we found out one of the table is looking for the source in Test database rather
than the new Product one. Does any one have any idea how to fix this?
Mar 28, 2017 05:04 PM|PatriceSc|LINK
The "switch" you are talking about has been done by changing connection strings in a config file? Could it be that the C# project uses a wrong (maybe hardcoded ?) connection string for this table ?
Mar 28, 2017 05:10 PM|wphr2101|LINK
Yeah....I made everything using the Product database as the source in the Web.config files. I tried to search all C# code that may possibly contains the hardcoded Test database but did not find anything.
Mar 28, 2017 07:55 PM|wphr2101|LINK
You are right! I found one of the store procedure was referring to the table as:
but the rest are
Thanks for your help!