Sorry about the uselessness of this reply, but I couldn't help being curious about the directory called "con". This is the CONsole "device" in the old DOS days. Try opening a DOS command window and type in the command "copy con: c:\text.txt" and hit enter. Anything you type after that gets copied into the file C:\text.txt. You bring an end to it by typing CTRL-Z (end of file). This is a truly poor-man's editor. I tried creating directories using the names of other old DOS devices and found you couldn't. The list includes: "prn", "com1" thru "com9", and "lpt1" thru "lpt9". Truly useless info - aren't you glad you asked!
As for extended stored procedures in SQL Server, I can add the following - maybe not completely useless. I once created an extended stored procedure in SQL Server 6.5. These are external ".exe" or ".dll" programs - unlike a regular stored procedure which is Transact SQL code. Generally you would develop an extended stored procedure with C or C++ (but I assume you could use other languages). The kicker with these is that when they are loaded by SQL Server they load into the same address space as SQL Server itself. So if they go down they bring SQL Server down with them. Consequently they can be dangerous. The OA ones I believe are provide by MS themselves and provide Office Automation functionality (i.e. you can access Office objects and such - not sure what else). The thing is even if they are provided by MS they can still have bugs (oh horrors an MS bug!!). Thus they are not safe just because they are provided by MS. I can understand why a shared host environment may not want to permit extended stored procedures to be available - frankly I don't think I would. I hope this sheds some light on things - though I know it doesn't really help you any. Phill -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED] Sent: July 12, 2002 11:26 AM To: [EMAIL PROTECTED] Subject: RE: [CFTALKTor] An SQL Server Question Could be a "feature" in M$ SQL server where MS does something special with stored procedures that begin with OA. MS is known for undocumented querks like that, rather then implementing a proper solution for special cases (hackers love finding them). Eg, did you know that one cannot create a directory called "con" in windows??? Similar "feature" perhaps... Terry Fielder Network Engineer Great Gulf Homes / Ashton Woods Homes [EMAIL PROTECTED] > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On > Behalf Of Mark D'Souza > Sent: Friday, July 12, 2002 11:03 AM > To: [EMAIL PROTECTED] > Subject: [CFTALKTor] An SQL Server Question > > > I know this isn't the forum for this but I need an answer quick so I > post it in few places. Any help would be mundo appreciated. > > Are there any issues that any of you are aware of with respect to > granting permissions on extended stored procedures? > Specifically, those > stored procedures beginning with 'OA'? One of our sites is > on a shared > server and the entire server crashed sourcing a fatal error > connected to > an extended stored procedure. All databases were moved to a > new server > but the company is no longer willing to grant us access to > the extended > stored procedures we require (the ones beginning with 'OA'). > > Thoughts? > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Rick Mason Sent: July 12, 2002 10:40 AM To: [EMAIL PROTECTED] Subject: [CFTALKTor] CF Hosts I know there has been plenty of discussion here about recommended hosts and that one of the most recommended was Crystaltech. We've now launched 2 sites on Crystaltech and the sites run very slow in comparison to similar sites we've launched in other shared hosting environments. I'm just wondering if anyone else has had similar experiences with them. Also, I'm wondering if anyone can suggest a Canadian host with similar levels of service, control over the CF settings and pricing. Rick - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: "Rick Mason" <[EMAIL PROTECTED]> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net) - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: "Mark D'Souza" <[EMAIL PROTECTED]> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net) - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: [EMAIL PROTECTED] To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net) - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: "Phill Addorisio" <[EMAIL PROTECTED]> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net)
