|
Home > Archive > MS SQL XML > July 2005 > SQLXMLBulkLoad using sp_OA procedures
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQLXMLBulkLoad using sp_OA procedures
|
|
|
| Hello,
Iam assuming SQLXML bulkload can be used from sp_OA procedures.
When I execute the script from .vbs, it works fine. But when i use sp_OA
procedures, it fails on line
EXEC @Return = sp_OAMethod @SQLXMLBulkLoad, 'Execute',null, @vMappingSchema
,@vXMLFile
with error
OLE Automation Error Information
HRESULT: 0x80040e21
Source: Microsoft XML Bulkload for SQL Server
Description: Error connecting to the data source.
The same schema file, XML file, server, database worked from .vbs.
Whay am I doing wrong?
-Prasad
| |
| Bertan ARI [MSFT] 2005-07-26, 1:24 pm |
| Are you just able to establish a connection to the database without
executing Bulkload?
--
Bertan ARI
This posting is provided "AS IS" with no warranties, and confers no rights.
"YLP" <YLP@discussions.microsoft.com> wrote in message
news:F5FF33AD-1508-4724-A3B3- E6A5194EBEBF@microso
ft.com...
> Hello,
>
> Iam assuming SQLXML bulkload can be used from sp_OA procedures.
>
> When I execute the script from .vbs, it works fine. But when i use sp_OA
> procedures, it fails on line
> EXEC @Return = sp_OAMethod @SQLXMLBulkLoad, 'Execute',null,
> @vMappingSchema
> ,@vXMLFile
> with error
> OLE Automation Error Information
> HRESULT: 0x80040e21
> Source: Microsoft XML Bulkload for SQL Server
> Description: Error connecting to the data source.
>
> The same schema file, XML file, server, database worked from .vbs.
>
> Whay am I doing wrong?
>
> -Prasad
| |
|
| The problem is with connectstring.
I had an extra double quote.
It works now.
Thanks for the reply.
"Bertan ARI [MSFT]" wrote:
> Are you just able to establish a connection to the database without
> executing Bulkload?
> --
> Bertan ARI
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>
>
> "YLP" <YLP@discussions.microsoft.com> wrote in message
> news:F5FF33AD-1508-4724-A3B3- E6A5194EBEBF@microso
ft.com...
>
>
>
|
|
|
|
|