I have a few sql queries that select data from a table on 1 database and stores it in a table on a different database. My problem comes when the table on the second database has an additional column which i want to add text dependant on what query is run. i.e. the name of the query.
example...
Im trying to save form data to mysql database. Do I use an sql connection or an odbc connection as I have searched the net and I have seen both used. (im using c# just incase you need to know)
Also when I used the sql connection I had the following error
Server Error in '/web app' Application...