Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 792
  • Last Modified:

XML to SQL

Hi Experts,

I have installed soap 2.0 and sqlxmloledb 3.0 on sql 2k , win 2k server.
I have (i hope) properly setup IIS virtual directory to use these things.

Now when I am trying to do DTS or Import / Export and specify SQLXMLOLEDB or SQLXMLOLEDB 3.0 I see
"To connect click Properties"....I do ....then I am trying to enter Data Source and/or location of XML files but
anything I do it gives me error

error source : SQLXMLOLEDB 3.0
error desc :    SQLOLEDB must be specified as a data provider.

Please help.
0
fpoyavo
Asked:
fpoyavo
1 Solution
 
Partha MandayamTechnical DirectorCommented:
When you use sqlxmloledb 3.0, you must specify

provider=SQLXMLOLEDB.3.0;data provider=SQLOLEDB

Check this example

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlxml3/htm/xmloledbprovider_86cy.asp
0
 
fpoyavoAuthor Commented:
It is irrelavant becuase I am talking about DTS not client side app.Thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now