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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-02-26 : 07:44:51
|
| Miles writes "Hi!I'm trying to set up the xml samples so that I can learn sql server 2000 with xml... but I'm haveing a few problems.What I did was click on "Configure sql xml support in IIS". From here I set up all the directories etc so that I could access the xml samples in sql server 2000 [C:\Program Files\Microsoft SQL Server\80\Tools\DevTools\Samples\xml\XMLDemo].Once set up I clicked on a file called url.htm. Within this document are links to xml examples which have already been setup. Some of these pull info out of the Northwind database - which works a treat. However, some of the links don't work. They come up with the following error: ERROR: 404 Not FoundHResult: 0x80070002Source: Microsoft SQL isapi extensionDescription: File not foundTo try and solve this I did the following:- search for the sqlisapi.dll file and found it in C:\Program Files\Common Files\System\Ole DB. - made sure that in the Advance tab of "IIS virtual directory management for sql server" that the isapi location was pointing to this location.- made sure that the dll was registered... and this is where I think I'm having problems:I then went to "Start" and "Run..." and entered: "regsvr32.exe sqlisapi.dll". When I did this an error message popped up saying it could not find the file. I then typed "regsvr32.exe C:\Program Files\Common Files\System\Ole DB sqlisapi.dll". Again it failed to find the file.I then went to my other sql server 2000 machine and also tried to register the same dll. I had exactly the same problem.If you could help in any way I would be very grateful.Regards Miles" |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2003-02-26 : 09:03:27
|
| Sorry I can't help with your problem, but I ran some samples from Ken Henderson's book: The Guru's Guide to SQL Stored Procedures, XML and HTML with no problem. The book walks through server and web setup procedures to get the samples running properly.Sam |
 |
|
|
|
|
|
sqlisapi.dll