Bulk Load problem - error connecting

I get the following error when trying to use the SQL Bulk Load object.

"Error connecting to the data source." The datasource is used right above this code to successfully read from the database. It is the last line that blows up.

Here is the problem code:

connStr = "provider=SQLNCLI;Data Source=myserver;Initial Catalog=mydb;Integrated Security=True"

Dim objBL As New SQLXMLBULKLOADLib.SQLXMLBulkLoad

objBL.ConnectionString = connStr

objBL.BulkLoad = True

objBL.XMLFragment = True

objBL.KeepIdentity = False

objBL.ErrorLogFile = "C:\BulkLoadErrors.xml"

objBL.Execute(SchemaFile, datafile)

(SchemaFile and datafile are strings containing the full file name and path)

Use the connection string as follows :

ConnStr = "provider=sqloledb;data source=myserver;database=mydb;integrated security=SSPI;"

It should work.

Thanks.

Naras.

|||Thank you! That did it. Annoying part is the connection string I was using was taken straight from the MSDN examples.

Builder Report and oracle

Hi,

I want to create a model report project using a DataSource with Oracle, I am using de Wizard to create de Model Report but I get the follow error:

ORA-000903 Invalid table name

Command: Select count(*) From [TIG].[ATM05]

Anyway to make Report Builder to omit the signs [] in the clause FROM ?

Thanks for you help.

Ana

Sorry, Report Builder doesn't work with Oracle in the SQL 2005 release. Oracle support is high on the list for a future release.|||Are there plans to include an oracle provider in the report builder in SQL Server 2005 SP 2? If so, is there a target date for the release of SP2?|||

Yes, Oracle support will be available in SP2. The first availability will be with the Community Tech Preview 1 of SP2. The dates for these have not been publically announced. Please check back with www.microsoft.com/sql for download availability.

Thanks, Jon

Builder Report and oracle

Hi,

I want to create a model report project using a DataSource with Oracle, I am using de Wizard to create de Model Report but I get the follow error:

ORA-000903 Invalid table name

Command: Select count(*) From [TIG].[ATM05]

Anyway to make Report Builder to omit the signs [] in the clause FROM ?

Thanks for you help.

AnaSorry, Report Builder doesn't work with Oracle in the SQL 2005 release. Oracle support is high on the list for a future release.|||Are there plans to include an oracle provider in the report builder in SQL Server 2005 SP 2? If so, is there a target date for the release of SP2?|||

Yes, Oracle support will be available in SP2. The first availability will be with the Community Tech Preview 1 of SP2. The dates for these have not been publically announced. Please check back with www.microsoft.com/sql for download availability.

Thanks, Jon