SQLXMLBulkLoad for Oracle

From: Barry Tang (Barry_S_Tang_at_hotmail.com)
Date: 10/14/04 

Date: 14 Oct 2004 14:26:46 -0700

In an article, http://www.dbazine.com/cook3.shtml, the author
suggested that for SQLXMLBulkLoad:
 
"The ConnectionString property is a valid OLE DB connection string. In
this example, a connection is made to a SQL Server. Instead, the
connection could have been to an Oracle server."

(I tried to send an e-mail to the author of the article but the e-mail
address is invalid)
 
However, when I tried to connect to an Oracle server, it wasn't
successful.
 
Based on the example in http://support.microsoft.com/?kbid=316005 and
using the following connection string:
 
objBL.ConnectionString = "provider=MSDAORA;data source=ora_sti;User
Id=<MyUser>;Password=<MyPassword>"
 
I got an error:
 
 
    Error: Bulkload will only work with SQL Server 2000 or later.
    Code: 80004005
    Source: Microsoft XML Bulkload for SQL Server
 
 
Note that the data source "ora_sti" is a service name I created using
Oracle Net Manager, which I tested successfully with a C# program
using ODP.NET.
 
I also tried using the OLEDB provider from Oracle, but got the same
error:
 
objBL.ConnectionString = "provider=OraOLEDB.Oracle;data
source=ora_sti;User Id=<MyUser>;Password=<MyPassword>"
 
I am using SQLXML 3.0 SP1 on a XP SP2 client box; the server is Oracle
10g on Windows 2000 SP4.
 
Any help is appreciated.

Relevant Pages

  • Re: What is the best way to connect to a server not on the network?
    ... That 192 IP address is most likely not a remote one. ... but doesn't object to migrating the data to SQL server. ... I tried using ADO within Access to create a connection string to the remote ...
    (microsoft.public.access.modulesdaovba)
  • Re: ASP.net and Oracle error System.Data.OleDb.OleDbException
    ... Also see http://www.connectionstrings.com/ and try other providers ... > Here is some of my connection code: ... >> And are you sure your connection string is ok. ... >>> Oracle error occurred, but error message could not be retrieved from ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Installing Sql Server Express on Vista Home Premium
    ... It seems that your SQL Server instances are Named Instances, ... Default Instances uses 1433 TCP port by default as a Static Port but not the ... If you change your Connection String as following, ...
    (microsoft.public.sqlserver.setup)
  • connecting to Oracle from ASP.NET 2.0 ?
    ... I am able to access 9i and 10g Oracle DBs from other clients on my pc ... An error has occurred while establishing a connection to the server. ... When connecting to SQL Server 2005, this failure may be caused by the ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Database Connection Problems
    ... What I didn't understand before, is that you can create a database that is not attached to the SQL server. ... The common connection strings I've encountered only work when the database is provided by the SQL server. ... connection string not working. ...
    (microsoft.public.dotnet.framework.adonet)