When i enter the username and password on the home page of my website; i get this error: Could not load file or assembly 'ADODB, Version=7.0.3300.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified. Can someone help me please, i would really appreciate it.
I don't think the the ADODB version 7.0.3300.0 is installed on the servers GAC. You may want to go with ADO.Net instead. Try looking at this link. http://www.codeproject.com/KB/database/DatabaseAcessWithAdoNet1.aspx
Using ADO Sarahp(and others), If you copy the adodb.dll to your bin directory, your .Net application will find and use it, even if it is not in the GAC. Just make sure Visual Studio includes it when you publish your website to the production server.