June 14, 2002 at 9:02 am
Using VB code generated from scriptpkg, I have created an ActiveX DLL which imports a given data source into a SQL 2000 table. This dll is called from an ASP page located on our web server, however, SQL Server is located on a different machine. When the ASP page is loaded, it gives the following:
error '800a01ad'
ActiveX component can't create object
I presume that this error is somehow a result of SQL Server and the Web Server being on two different machines. (As all seems to work fine when the SQL Server and Web Server are on one same machine.)
Any help in resolving this issue would be greatly appreciated. Thank you very much!
June 14, 2002 at 12:35 pm
How do you define the connection to the SQL server with regards to the ActiveX control. If it is hard coded you may have pointed at the web box. If not and is in the object tag check what you have. The key is how does it know where the SQL server is.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
June 14, 2002 at 1:27 pm
The connection is set within the ActiveX script as follows:
Set oConnection = goPackage.Connections.New("SQLOLEDB.1")
oConnection.DataSource ="COMPUTERNAME"
where COMPUTERNAME is the name of the computer on which SQL Server is located. How can I further let the web server know where the SQL Server is? Thanks again!
June 14, 2002 at 3:27 pm
Not a SQL error. you have an error with the IIS account loading the DLL. Track that down first. The "knowing where the server is" is stricly a location item. If the web server and IIS account can ping or otherwise resolve the name. You can try IP, but I think your error is a security or code error.
Steve Jones
June 14, 2002 at 7:41 pm
Steves right, I was have gotten this enough that I should have seen that. Several issue can exist. Make sure the component has been registered. Also may have needs to run under a special account so depending on you Windows version you need to create a package in MTS or Component Services and setup to run under an account that has proper access. Consider anything special that the component needs, access to drive, access to machine?
This is being thrown by you SERVER.CREATEOBJECT("whatever")
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Edited by - antares686 on 06/14/2002 7:42:36 PM
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply