Home All Groups Group Topic Archive Search About

SQL Server XML

microsoft.public.sqlserver.xml
Score how to open an xml file
gee57 - 3 Dec 2004 7:35 PM - 2 messages
storeData -- text parameter the xml text. I have declared a procedure that parses XML. How Can i create a stored procedure that opens a file say c:\temp.xml and passes its content to storeData. An example would be appreciated. ...
Score sqlxml bulk load
Scott - 3 Dec 2004 6:35 PM - 2 messages
I've been trying to get schemas.monster.com Job Applicants XSD schema into a SQL Server 2000 database using SQLXML Bulk load.  I have been trying to fix the countless errors ("schema mapping: relationship expected ...") the last several days. ...
Score Requesting a attribute + registering info when availible
Shampoelas - 3 Dec 2004 4:09 PM - 2 messages
I'm working with VB.NET. I have three questions an i hope somone will answer. I want to reguest this pice ## IC25N040ATMR04-0  ## How can i do that? <Hard_disks> <primary_disk size="40007761920" sernum="MRG257K2EBGTUH">IC25N040ATMR04-0</primary_disk> ...
Score Getting the error "XML stored procedures are not supported in fibers mode"
RP - 3 Dec 2004 3:12 PM - 2 messages
Hello All I am getting the error  "XML stored procedures are not supported in fibers mode", when I try to run the example xmlsql given in the SQL books online... I have changed my "lightweight pooling option to 0", using sp_configure. ...
Score Using a NTEXT Field to Store an entire XML file Equivilent
Colin Sheppard - 3 Dec 2004 11:23 AM - 2 messages
Helo, I would like to know where I can find Code or Scripts to use a NTEXT Field to Store an entire XML file equivilent in SQL Setver 2000. Essentially, I would like to be able to treat the XML file in the ...
Score Error Mesage: Cannot load the DLL xpweb70.dll
Colin Sheppard - 3 Dec 2004 3:47 AM - 2 messages
How do I resolove the following error message? ODBC: Msg 0, Level 16, State 1 Cannot load the DLL xpweb70.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.). Thank you for your kind feedback and susgestions. ...
Score generating XML to validated against the schema
balajee - 3 Dec 2004 1:15 AM - 4 messages
hi, I have a sample xml data and sample xsd as follows: the xsd is really big and runs into 4 pages. I need to stored data into the data base and generate xml that validates against this schema. the sqlxml bulk load and view mapper fails to recognize the xsd fine. ...
Score XML files with bad characters
MarkA - 2 Dec 2004 10:55 PM - 4 messages
I have 2200 XML files containing information on our company computers. About 450 of these will not import to SQL server using an ActiveX script in DTS. The rest import fine. One of the files didn't import because of a long (em) ...
Score Re: Import XML file to database (MS Server 2000) using procedure (transact sql) ???
Michael Rys [MSFT] - 2 Dec 2004 10:10 AM - 1 message
Sorry for the late answer. Write a stored proc that takes a TEXT or NTEXT parameter and then use sp_xml_preparedocument and OpenXML. See the documentation for more information on them. Best regards Michael ...
Score Re: shaping with FOR XML AUTO
Michael Rys [MSFT] - 2 Dec 2004 9:44 AM - 1 message
Note in SQL Server 2005, you will have much better control using nested FOR XML expressions. The problem is that the join result on which FOR XML auto operates does not contain enough information on whether the order and return values are ...
Score sp_OAMethod and long text return from COM Dll method
Nayan - 2 Dec 2004 5:11 AM - 3 messages
Hi Gurus, I have a problem getting return string from COM Dll. I use sp_OAMethod with output parameter as shown below =========== T-SQL Code in SP========================= DECLARE @hr integer DECLARE @obj integer DECLARE @strXML varchar(8000)  --// <<-- Any alternate to overcome 8000 Char ...
Score Bulkloading external xml file
Paulo - 1 Dec 2004 5:21 PM - 5 messages
Can I call an external url which requests a xml file when executing a BulkLoad operation? I'm getting the error message: Error opening the datafile. Code:80004005. There is no problem with my database connection and I am able to access the ...
Score Importing and Exporting of XML Files (as Instance Data) in SQL Server 2000
Colin Sheppard - 1 Dec 2004 11:24 AM - 2 messages
Hello, I have a SQL Server 2000 Database that feature individual records which are stored in a table with data (essentially a large XML file full of data) in the InstanceData field as XML. I would appreciate it if someone could place some code that ...
Score Re: IIS Virtual Directory Management for SQL Server
Amar Nalla [MS] - 1 Dec 2004 2:03 AM - 1 message
Hi Dean,    There is no special requirements for a specific service pack for Windows 2003. For SQL 2000, you should have SP3 with you. Are you using the MMC tool from the SQL 2000 installation or have you ...
Score which requirements should i ask to my suppliers?
Virgil - 30 Nov 2004 4:22 PM - 3 messages
Hello, I want to get supplyinformation deliverd from my suppliers through xml, which i can put in mine online database (sql/access). To what format/files should my suppliers respond? Is a simple xml document with the content below enough? or should I have ...
Score SQLXMLBulkLoad xml and schema file
HG - 30 Nov 2004 3:35 AM - 2 messages
I have two tables and a xml, xsd file in following format, when I use SQLXMLBulkLoad load xml data into those two tables, get error: "Invalid value for column "NAME"", which "NAME" is a nested element in XML but not in table and "NAME is the alias for FIRST-NAME and LAST-NAME. Any one ...
Score OpenXML with a schema
John Grant - 29 Nov 2004 8:21 PM - 2 messages
Why doesn't this work? DECLARE @xml VARCHAR(8000) DECLARE @iDoc INT DECLARE @Status INT SELECT @xml = ' <xml xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882"     xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882"     xmlns:rs="urn:schemas-microsoft-com:rowset" ...
Score SQLXMLBulkLoad with VB .Net - No errors but data is not loading
Gwen - 29 Nov 2004 8:16 PM - 4 messages
I've recently written an application using a typed dataset in VB .Net which contains several tables.  In the application the dataset updates the SQL Server tables without any problems. If there are logic issues with the data I do not update the SQL Server ...
Next »