Click here to Skip to main content
15,900,973 members
Home / Discussions / Database
   

Database

 
GeneralRe: for loop in stored procedure Pin
GuyThiebaut9-Oct-07 3:16
professionalGuyThiebaut9-Oct-07 3:16 
AnswerRe: for loop in stored procedure Pin
Christian Graus9-Oct-07 14:39
protectorChristian Graus9-Oct-07 14:39 
QuestionStoring RTF in SQL Pin
MartyK20078-Oct-07 22:47
MartyK20078-Oct-07 22:47 
AnswerRe: Storing RTF in SQL Pin
Colin Angus Mackay9-Oct-07 0:13
Colin Angus Mackay9-Oct-07 0:13 
GeneralRe: Storing RTF in SQL Pin
MartyK20079-Oct-07 0:39
MartyK20079-Oct-07 0:39 
GeneralRe: Storing RTF in SQL Pin
MartyK20079-Oct-07 1:05
MartyK20079-Oct-07 1:05 
QuestionCreating Virtual Directories in Reporting Services Pin
Karuna Kumar8-Oct-07 20:44
Karuna Kumar8-Oct-07 20:44 
AnswerRe: Creating Virtual Directories in Reporting Services [modified] Pin
John Gathogo8-Oct-07 23:18
John Gathogo8-Oct-07 23:18 
This question would fit more in ASP.NET forum. But anyway you can create the virtual directory on IIS when deploy your application by adding a custom action dll to the web setup project. The custom action should have the code to configure the directories as an application in IIS (i.e. as a virtual directory)

Below is some VB.NET code that you could have in your custom action project to configure 'Reports' directory as an application in IIS in the Root directory (i.e. Root - Default Web Site):

Dim IIsBOVirDirRootObj As Object = Nothing
Dim IIsWebVDirObj As Object = Nothing

' Create an instance of the virtual directory object
' that represents the virtual directory in the default Web site.
IIsBOVirDirRootObj = GetObject("IIS://localhost/W3SVC/1/Root")

Try
' Use the Windows ADSI container object "Create" method to create a new virtual directory.
IIsWebVDirObj = IIsBOVirDirRootObj.Create("IIsWebVirtualDir", "Reports")
Catch ex As Exception

End Try

You can use the same idea to create the virtual directory in the ReportServer Website

-- modified at 5:24 Tuesday 9th October, 2007
QuestionJoining 2 Tables Pin
Brendan Vogt8-Oct-07 20:22
Brendan Vogt8-Oct-07 20:22 
AnswerRe: Joining 2 Tables Pin
Krish - KP8-Oct-07 21:09
Krish - KP8-Oct-07 21:09 
QuestionSQL 2005 SQL Profiler? Pin
devvvy8-Oct-07 16:35
devvvy8-Oct-07 16:35 
Answerfound one --- Re: SQL 2005 SQL Profiler? Pin
devvvy8-Oct-07 18:41
devvvy8-Oct-07 18:41 
QuestionIntermittent errors..please help!!! Pin
new_phoenix8-Oct-07 10:51
new_phoenix8-Oct-07 10:51 
AnswerRe: Intermittent errors..please help!!! Pin
andyharman9-Oct-07 1:30
professionalandyharman9-Oct-07 1:30 
QuestionVISTA and SQL SERVER 2005 Pin
Yoyosch8-Oct-07 7:23
Yoyosch8-Oct-07 7:23 
AnswerRe: VISTA and SQL SERVER 2005 Pin
Andy_L_J9-Oct-07 22:19
Andy_L_J9-Oct-07 22:19 
QuestionODB Problem ? Pin
hungdl8-Oct-07 6:36
hungdl8-Oct-07 6:36 
AnswerRe: ODB Problem ? Pin
Dave Kreskowiak8-Oct-07 6:48
mveDave Kreskowiak8-Oct-07 6:48 
GeneralRe: ODB Problem ? Pin
hungdl8-Oct-07 7:24
hungdl8-Oct-07 7:24 
GeneralRe: ODB Problem ? Pin
Dave Kreskowiak8-Oct-07 9:17
mveDave Kreskowiak8-Oct-07 9:17 
QuestionConverting Integet to Time: Pin
Shahzad.Aslam7-Oct-07 23:46
Shahzad.Aslam7-Oct-07 23:46 
AnswerRe: Converting Integet to Time: Pin
PIEBALDconsult8-Oct-07 5:16
mvePIEBALDconsult8-Oct-07 5:16 
AnswerRe: Converting Integet to Time: Pin
Virendrak11-Oct-07 0:56
Virendrak11-Oct-07 0:56 
QuestionRemote Connection Pin
Xerox47-Oct-07 21:43
professionalXerox47-Oct-07 21:43 
QuestionWhat sql server 2000 componenets do I have? Pin
Jwalant Natvarlal Soneji7-Oct-07 21:20
Jwalant Natvarlal Soneji7-Oct-07 21:20 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.