Import SQL Data to xml - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Import SQL Data to xml

Author

Topic

ceema
Yak Posting Veteran

80 Posts

Posted - 2006-04-19 : 09:33:44

Hello,

I am using the following query to import sql data to xml.

EXEC sp_makewebtask
@outputfile = 'c:\Shippers.xml',
@query = 'SELECT schoolid,class,busno,regno FROM buslist ',
@templatefile ='c:\Shippers.txt'

But it ends up with an error

ODBC: Msg 0, Level 16, State 1
Cannot load the DLL xpweb70.dll, or one of the DLLs it references. Reason: 126(error not found).

I am using sql 2000.

Any body knows the reason?

Thanks
Ceema"

KenW
Constraint Violating Yak Guru

391 Posts

Posted - 2006-04-19 : 16:29:54

Ummm... Because it can't find the DLL xpweb70.dll on the
search path? :-)

Do a search on your hard drive for that file. You should
find it somewhere in the MSSQL folders. Either add that
folder to your PATH, or copy it into the Windows (or WinNT,
depending on what version of Windows you're using) System32
folder.

HTH

ceema
Yak Posting Veteran

80 Posts

Posted - 2006-04-20 : 04:15:42

Thank you KenW, I have done it alreay - programatically, using asp.net. I don't know whether I can post the code here because it's asp.net, if I can post, I am ready to post it here, for some one else' reference. And I think your direction will help all of us so much,because I have seen a lot of people posted the same query in internet but without any answer.

Thanks you so much

Ceema

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources