I have a DAL, BAL and the UI.
In my DAL and BAL, i have a reference to IBM.Data.DB2.iSeries dll.
I also use SQLClient.
I use this code for my DAL (changed it to VB.Net): http://aspalliance.com/837_Implementing_a_Data_Access_Layer_in_C
Users can choose either between IBM connection or SQL connection.
I copied the entire code to another server.
I brought up the site and chose "SQL" connection but got an error about the IBM dll.
*** I copied the IBM.Data.Db2.iSeries.dll to the BIN directory of the UI folder and it works..., i didnt get the IBM error... ***
Why is that? When I chose SQL, why was it looking for the IBM dll?? So now when we give the application to a client who has SQL2000, we have to give them the IBM dll as well??