|
|
|
Версия XML Parser'a и SQL Server
|
|||
|---|---|---|---|
|
#18+
Читая Books Online, обнаружил, что процедуры sp_xml_preparedocument и sp_xml_removedocument всегда используют версию 2 XML парсера. То есть, даже установив на сервер новый парсер (4), невозможно воспользоваться его преимуществами (повышение скорости, в частности). Или есть на этот счет какие-либо статьи MS KB? Благодарю ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 25.07.2002, 00:30:40 |
|
||
|
Версия XML Parser'a и SQL Server
|
|||
|---|---|---|---|
|
#18+
Может это надо? http://www.microsoft.com/downloads/release.asp?ReleaseID=39208&area=search&ordinal=26 SQLXML 3.0 SP1 SQLXML enables XML support for your SQL Server Database. It allows developers to bridge the gap between XML and relational data. You can create XML View of your existing relational data and work with it as if it was an XML file. SQLXML allows you to: ·Build Web Services with SQL Server 2000 ·Build websites to publish data from SQL Server ·Query relational database with XPath ·Update relational data as if it was XML ·Load XML into SQL Server ·Query SQL Server via URLs, OLEDB/ADO or .NET Managed Classes For More Information - http://www.microsoft.com/sql/techinfo/xml/ Version - 3.0SP1 Release Date - 23 May 2002 Estimated Download Size/Time @28.8 - 2,661 kb / 14min System Requirements This release is installed using the Microsoft Windows Installer 2.0. You might need to upgrade your installer to Windows Installer 2.0 prior to installing SQLXML 3.0. Additionally, users might need to install the Microsoft SOAP Toolkit 2.0. Please note that this release of SQLXML requires SQL Server 2000 RTM (Version 8.00.194) and MDAC 2.6 or later to be installed before the installation can be run. This release also has a dependency on MSXML version 4.0. This version of MSXML is included with the download. SQLXML Managed Classes require .NET Framework RTM to be installed before the SQLXML installation is run. If you do not have .NET Framework RTM installed, SQLXML 3.0 installation will succeed, but the Managed Classes will not be installed. Operating System - Windows 95 & 98, NT 4.0 & 2000, Windows Me, Win XP Download Now sqlxml.msi - 2,732 Kb IMPORTANT DOWNLOAD INSTRUCTIONS - Uninstall SQLXML 3.0 - Select "Run this Program from its Current Location" to start the download immediately. - Select "Save this Program to Disk" to copy the download to your machine for installation at a later time. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 25.07.2002, 05:36:14 |
|
||
|
Версия XML Parser'a и SQL Server
|
|||
|---|---|---|---|
|
#18+
Спасибо, но к сожалению, процедуры sp_xml_* даже при установленном SQLXML 3 используют msxml2.dll ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 25.07.2002, 11:14:25 |
|
||
|
Версия XML Parser'a и SQL Server
|
|||
|---|---|---|---|
|
#18+
Забавно. Если решишь проблему - свистни ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 25.07.2002, 15:10:33 |
|
||
|
Версия XML Parser'a и SQL Server
|
|||
|---|---|---|---|
|
#18+
Спешу страшно. Может поможет. Раскопал в своих развалах. Бегло просмотрел. Не знаю. ----------------------------------------------------------- Right before the code sample he says the code utilizes MSXML 3.0 but the code actually creates MSXML 2.0 Objects Set srvXmlHttp = CreateObject("MSXML2.ServerXMLHTTP") Set xmlResult = CreateObject("MSXML2.DomDocument") - Anonymous 09 Feb 2001Respond Re: Slight discrepancy MSXML2 it's just a namespace... MSXML3.DLL (Microsoft XML version 3) uses MSXML2 in the namespace. In VB this is the Project Name. In IDL this is library. Open the DLL in OLEVIEW or Object Browser(VB) to see the namespace IDL Sample: [ uuid(F5078F18-C551-11D3-89B9-0000F81FE221), version(3.0), helpstring("Microsoft XML, v3.0") ] library MSXML2 { ... - fgaluppo@hotmail.com 13 Feb 2001Respond Re: Slight discrepancy That is MSXML3.0. The ProgID isn't the same as it's designed to be used side-by-side hence MSXML2 rather than MSXML - Anonymous 13 Feb 2001Respond Re: Slight discrepancy MSXML 3.0 objects are called MSXML2.Whatever. - Anonymous 13 Feb 2001Respond Re: Slight discrepancy Yeah ,well Actually i think that's the way you reference it .because,the other day i downloaded the version 3 xml sdk,and it installed version msxml2.dll,anyway search for the tlb's or dll's and check the properties of the file you'll see. - Anonymous 13 Feb 2001Respond Re: Slight discrepancy Yeah ,well Actually i think that's the way you reference it .because,the other day i downloaded the version 3 xml sdk,and it installed version msxml2.dll,anyway search for the tlb's or dll's and check the properties of the file you'll see. - Anonymous 13 Feb 2001Respond Re: Slight discrepancy I meant msxml3.dll(2 is the namespace,I 'm anti MS but they re confusing sometimes,gotta get used to that.. - Anonymous 13 Feb 2001Respond Re: Slight discrepancy the msxml3.0.dll returns "MSXML2 as it's dll name. he's right. - Anonymous 14 Feb 2001Respond Re: Slight discrepancy If you've used the Msxml parser data model, you would know that Msxml 3.0 is accessed by the "2" ending. To clarify: "Dim oDomDoc as MSXML2.DomDocument" is code that accesses MSXML3.dll whereas "Dim oDomDoc as MSXML.DomDocument" accesses MSXML2.dll I can't explain the logic here, but I like to write it off as a "Feature" - Anonymous 20 Feb 2001Respond The Right Time to Migrate There a several data access evangelists, but it's rare to find one that tells scripters the truth, like Dino. I'd say this is well said - and said at the right time. - Anonymous 09 Feb 2001Respond Dino Rocks! Please keep writing these great articles. - Anonymous 08 Feb 2001Respond in like a lion, out like a lamb (dino) the article started out defining how and when to migrate, and then trailed off somewhere .... Will there be a part II? - Anonymous 08 Feb 2001Respond Some lesser know issues... There are a few really important things that you should keep in mind, that weren't mentioned in this article. 1. You can access .NET classes through web services, but expect a huge performance penalty compared to COM/DCOM. This also assumes that it's a trivial thing to retrofit your code to deal with XML instead of recordsets. 2. Right now, the only ADO.NET is Beta 1. Expect the name of objects and methods to change in Beta 2, meaning if you write a lot of .NET code today, you will have some work to do when Beta 2 releases. On the plus side, there aren't supposed to be any incompatible changes between Beta 2 and RTM. 3. Right now, .NET doesn't support connection pooling on the SQLConnection object (which is what you'll want to use if you're talking to SQL server). As a result, you'll see another performance hit until Beta 2 releases. 4. There are some things that just don't exist in ADO.NET. For example, you can't create server side dyanmic, keyset, or static cursors (not that these were usually good ideas), so if you have code that depends on these, expect some work. 5. It would have been nice to actually seem some ADO vs. ADO.NET code. Unfortunately, there wasn't any at all. Basically, this article really sucks. And it's not just the heaven/hell/change of season junk that fills up a bunch of space without even providing a good analogy. It's more that the author wrote an article without really knowing what he's talking about. Dino, how many times have you actually implemented this scenario in the real world? Never. Don't get me wrong, ADO.NET rocks. You will want to move to it. But wait at least until Beta 2 releases. - Anonymous 08 Feb 2001Respond Great Article... Dino is really a great Writer and Speaker(VS Live - SFO 2K1)... - fgaluppo@hotmail.com 08 Feb 2001Respond Re: Great Article... he is a son of darkness - Anonymous 12 Feb 2001Respond ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 25.07.2002, 17:07:38 |
|
||
|
Версия XML Parser'a и SQL Server
|
|||
|---|---|---|---|
|
#18+
Еще раз спасибо. Но грузит он все равно msxml2.dll... Эх, видимо не судьба. P.S. Я так тестирую: Код: plaintext ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 25.07.2002, 18:18:06 |
|
||
|
Версия XML Parser'a и SQL Server
|
|||
|---|---|---|---|
|
#18+
Вот цитата из этой мутаты: the msxml3.0.dll returns "MSXML2" as it's dll name Уже несколько странно. Или нет? Позволю себе лирическое отступление. Мне кажется, что лучше не придумывать себе проблем и не углубляться в подобные дебри. Здесь уже замешаны бизнес, реноме фирмы (M$), тайны кодов и т.д. У этих гениев (надо признать) так всё закручено и перемешено, что listdlls в любой момент (шутка) может вернуть что угодно. В прошлом году я было кинулся изучать эту тему. Всякие там "островки данных" лепил, тэги XSL и проча и проча. На www.w3.org ходил. Даже стояла у меня на компе прога какая-то немчурная (хоть убей, не вспомню название) для удобной лепки XML и DTD. А потом мне так надоели путаница и неразбериха во всей этой мутате, что я сказал себе: а пошли вы все в задницу с вашими эксэмэлями. Захотелось простоты и ясности. И потом, пардон, на хрена вам так захотелось новый парсер использовать? Их, этих парсеров, знаете сколько будет? Только плати, вам сделают. И никто ваши сизифовы труды не оценит и не восхитится ими (был, кстати, недавно случай, подтверждающий мои слова). ЗЫ Заходите к нам в гости на "Просто треп". У нас там есть прыгающий пушистый крокодильчик. Дадим на руках подержать. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 25.07.2002, 21:34:09 |
|
||
|
|

start [/forum/topic.php?desktop=1&fid=46&tid=1821559]: |
0ms |
get settings: |
7ms |
get forum list: |
9ms |
check forum access: |
2ms |
check topic access: |
2ms |
track hit: |
36ms |
get topic data: |
6ms |
get forum data: |
3ms |
get page messages: |
23ms |
get tp. blocked users: |
1ms |
| others: | 207ms |
| total: | 296ms |

| 0 / 0 |
