SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Alternative to the Microsoft MMC Console


Alternative to the Microsoft MMC Console

Author
Message
Dale Corey
Dale Corey
Say Hey Kid
Say Hey Kid (693 reputation)Say Hey Kid (693 reputation)Say Hey Kid (693 reputation)Say Hey Kid (693 reputation)Say Hey Kid (693 reputation)Say Hey Kid (693 reputation)Say Hey Kid (693 reputation)Say Hey Kid (693 reputation)

Group: General Forum Members
Points: 693 Visits: 4

Jereme,

Not bad for your second article. I read your first one too on Printing in .NET. Keep up the good work! You have a very helpful style.




All the best,

Dale

Author: An Introduction to SQL Server 2005 Management Studio
robert-249275
robert-249275
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
Points: 2 Visits: 4
As you are missing the /inc folder, and files, what is the db table structure. this sounds like a great idea but the missing files obscure the solution you used....
rlively-343684
rlively-343684
Valued Member
Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)

Group: General Forum Members
Points: 50 Visits: 52

I posted this once but it went to the wrong place. The original post went here: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=280&messageid=297580. I couldn't find a way to delete that post.

I am having difficulty setting this up to work. I have a virtual directory in IIS with the pages downloaded to it, and I have installed the tswebsetup.exe from http://www.microsoft.com/windowsxp/downloads/tools/rdwebconn.mspx.

In connections.asp these files are referenced:

<!-- #INCLUDE FILE="/conn.inc" -->
<!-- #INCLUDE FILE="/adovbs.inc" -->
<!-- #INCLUDE FILE="/inc/Func.inc" -->

But these files are not included in the zip file for download, and there is no mention in the article as to the contents or format these files need in order to work on the page. I get this error when I visit the page:

Error Type:
Active Server Pages, ASP 0130 (0x80004005)
File attribute '/conn.inc' cannot start with forward slash or back slash.
/newmmc/connections.asp, line 4

I thought conn.inc would include the servers to include in the list, but it looks like it wants to connect to a SQL Server to get that list, so I created a new DB and added a ServerList table and an SP for the page to call to get the list.

I got past the error stemming from the constant adCmdStoredProc not being defined by downloading adovbs.inc from here: http://www.asp101.com/articles/john/adovbs/default.asp.

That brought me to this error, which is probably because I need the function which is defined in Func.inc?

Error Type:
Microsoft VBScript runtime (0x800A000D)
Type mismatch: 'ConvertText'
/newmmc/connections.asp, line 22

On another topic, does this forum only work for IE? I tried with both Opera 9 and FireFox 1.5 and neither one would let me type into the reply box, and there were multiple JavaScript errors reported in both error consoles.


philcart
philcart
SSCarpal Tunnel
SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)

Group: General Forum Members
Points: 4100 Visits: 1436

Nice short article, but probably a little too short and definately needs some screenshots. Maybe after "a couple hours", a extra couple of hours should have been spent making everything presentable.

The provided download should be easy to setup and get working. Unfortunately there seems to be a couple of missing files, the asp page calls a stored procedure that is not mentioned or provided in the download. It seems other posters have had other various issues as well.

Maybe I'm missing something, but how is this any different that the Remote Desktop snap-in provided in the Windows Server 2003 Admin Tools Pack?



Hope this helps
Phill Carter
--------------------
Colt 45 - the original point and click interface

Australian SQL Server User Groups - My profile
Phills Philosophies
Murrumbeena Cricket Club
Mr.No
Mr.No
SSC Rookie
SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)

Group: General Forum Members
Points: 34 Visits: 1
Great article, thanks.



willhaney
willhaney
SSC-Enthusiastic
SSC-Enthusiastic (174 reputation)SSC-Enthusiastic (174 reputation)SSC-Enthusiastic (174 reputation)SSC-Enthusiastic (174 reputation)SSC-Enthusiastic (174 reputation)SSC-Enthusiastic (174 reputation)SSC-Enthusiastic (174 reputation)SSC-Enthusiastic (174 reputation)

Group: General Forum Members
Points: 174 Visits: 37

I'm also getting an error when running the Connections.asp page

Active Server Pages, ASP 0126 (0x80004005)
The include file 'inc/stuff.inc' was not found.
/test/NewMMC/Connections.asp, line 5





jereme.guenther@gmail.com
jereme.guenther@gmail.com
SSC Eights!
SSC Eights! (965 reputation)SSC Eights! (965 reputation)SSC Eights! (965 reputation)SSC Eights! (965 reputation)SSC Eights! (965 reputation)SSC Eights! (965 reputation)SSC Eights! (965 reputation)SSC Eights! (965 reputation)

Group: General Forum Members
Points: 965 Visits: 194

Sorry all, I have been gone for the last week due to my wife having our second child.

Thanks to Steve Jones, the zip file available for download within the article now includes the files needed for the right click and disconnect functionality.


jereme.guenther@gmail.com
jereme.guenther@gmail.com
SSC Eights!
SSC Eights! (965 reputation)SSC Eights! (965 reputation)SSC Eights! (965 reputation)SSC Eights! (965 reputation)SSC Eights! (965 reputation)SSC Eights! (965 reputation)SSC Eights! (965 reputation)SSC Eights! (965 reputation)

Group: General Forum Members
Points: 965 Visits: 194

The /inc folder simply contained my connections to my SQL server. Seeing as this is a SQL server specific site, I assumed that people would know how to create databases, tables, and connections to the database. For those that need help in this area, here is the script to create the table and stored proc.

USE [MyDatabase]
GO
/****** Object: Table [dbo].[Servers] Script Date: 08/02/2006 09:06:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Servers](
[MyDatabase_ID] [int] IDENTITY(1,1) NOT NULL,
[Name] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Active] [bit] NULL,
[Location] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Description] [varchar](500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

/**************************Stored Procedure**************************/

USE [MyDatabase]
GO
/****** Object: StoredProcedure [dbo].[spTSWeb] Script Date: 08/02/2006 09:16:21 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spTSWeb] AS
Select [Name]
,Location AS Loc
,Description AS Desc
From Servers
Where Active = 1
Order By Location,Servers_Name


willhaney
willhaney
SSC-Enthusiastic
SSC-Enthusiastic (174 reputation)SSC-Enthusiastic (174 reputation)SSC-Enthusiastic (174 reputation)SSC-Enthusiastic (174 reputation)SSC-Enthusiastic (174 reputation)SSC-Enthusiastic (174 reputation)SSC-Enthusiastic (174 reputation)SSC-Enthusiastic (174 reputation)

Group: General Forum Members
Points: 174 Visits: 37

Congratulations on the birth!

The error I was getting was this:

The include file 'inc/stuff.inc' was not found.

Are you saying that the file, stuff.inc, which is to be an include in connections.asp has the script to create tables?

I’m confused.

Will





jereme.guenther@gmail.com
jereme.guenther@gmail.com
SSC Eights!
SSC Eights! (965 reputation)SSC Eights! (965 reputation)SSC Eights! (965 reputation)SSC Eights! (965 reputation)SSC Eights! (965 reputation)SSC Eights! (965 reputation)SSC Eights! (965 reputation)SSC Eights! (965 reputation)

Group: General Forum Members
Points: 965 Visits: 194

The constants that were stored in my include files which you need are these:

AnonUser = "myUserName"
AnonPword = "mySQLPassword"

Const adCmdStoredProc = &H0004

strConn = "Provider=SQLOLEDB.1;" & _
"Initial Catalog=MyDatabase;" & _
"Data Source=MyDatabaseServer;" & _
"User Id=" & AnonUser & "; " & _
"Password=" & AnonPword

As a side note, the adovbs file actually ships with windows. Whether good or bad, many web developers include that file when dealing with server objects and the constants contained within the adovbs file.

As to the ConvertText function, that one was totally my fault for not including it. Here it is, you should be able to put it right before the do loop at the top of the connections.asp file.

Function ConvertText(Value)
If IsNull(Value) then
ConvertText = ""
Else
ConvertText = Value
End If
End Function


Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search