I'm currently in the process of getting my asp pages to work with a Dll file connecting to a MSSQL Server database on my ISP's. Problem is that we now have the MSSQL Server database setup, the Server DSN is setup. But i'm getting an error that says :
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Could not find file '(unknown)'.
/managemovies.asp, line 43
At this line of code, all i'm doing is :
Set frCMS = Server.CreateObject("FrontRow.CMS")
I think this new error is occuring because technical engineers
at ISP instructed me to place DLL file in a separated folder in
my root directory. Before i had the DLL in my root directory
and had no problems.
Ho can i ensure that when i call a create Object function,
my ASP page will know to look in a specified directory
for the DLL file ?