Advertisement

05.28.2008 at 03:12AM PDT, ID: 23437508
[x]
Attachment Details

ActiveX component can't create object: "SQLXMLBulkLoad.SQLXMLBulkLoad" - Can anyone help?

Asked by stuartbanks in Extensible Markup Language (XML), MS SQL Server, VB Script

Tags: Microsoft, SQL Server 2000 / Windows Server 2000, 2000, Installed on dedicated server behind Firewall, ASP/SQL/XML, SQLXML 3.0 / 4.0 / 6.0

Hi
I coded a bit of VBScript on my local machine which is Windows 2003 Server with SQL Server 2000, which takes the contents of an XML document, parses it through a schema and successfully inserts the content into an SQL table.
So far so good.
As this script must run on my dedicated server (unfortunately which runs Windows 2000 Server and SQL server 2000), I transferred all my files over, installed SQLXML 3.0 on that server - and tried the script.
No luck.
I have since installed version 4.0 and parser 6.0 on the server, the script still gets the error "can't create object".
I have downloaded all the latest patches for these installations, rebooted the server, etc, and still I get the error.
I KNOW that my ASP code and XML schema, etc, are fine as they work locally on Win 2003, my problem is getting them to work on the dedicated server with Win 2000.
Can anyone suggest anything as to why this component isn't working? It's almost as if the server doesnt know I have SQLXML installed....
Thank you!
Start Free Trial
[+][-]05.28.2008 at 05:25AM PDT, ID: 21659712

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.28.2008 at 06:29AM PDT, ID: 21660156

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.28.2008 at 07:38AM PDT, ID: 21660799

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.28.2008 at 07:51AM PDT, ID: 21660941

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.28.2008 at 07:53AM PDT, ID: 21660967

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Extensible Markup Language (XML), MS SQL Server, VB Script
Tags: Microsoft, SQL Server 2000 / Windows Server 2000, 2000, Installed on dedicated server behind Firewall, ASP/SQL/XML, SQLXML 3.0 / 4.0 / 6.0
Sign Up Now!
Solution Provided By: dbaSQL
Participating Experts: 1
Solution Grade: A
 
 
[+][-]05.28.2008 at 08:41AM PDT, ID: 21661450

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.28.2008 at 08:44AM PDT, ID: 21661479

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628