DLL problem

[fbabinea]

Hello again,
Here is the problem I am facing. I have written a DLL in VB that FTPs a file to a server. I've written a test app to test/debug my DLL. I runs like a charm on my PC, so I compiled it and copied it to our server. I registered it and created a SQL stored procedure to call an instance of that DLL. I am getting the following error:

OLE Automation Error(s)Information
HRESULT: 0x800a8bab
Source : ODSOLE Extended Procedure

Is there something else I should be doing?

[Edneeis]

Does the server have all the required dependence files (MDAC...) and are they the right version?

[fbabinea]

Yes, I've re-installed the DLL. Now I'm not getting any errors within the stored proc, but it doesn't seem to ftp the file. It goes through all its steps, doesn't return an error, but just doesn't do the actual FTP.