IIS - SQL Server Developer Edition
Asked By WoodsieOwl
12-Aug-09 06:24 PM
Last year I downloaded for free SQL Server Developer Edition and the .Net
Framework and Visual Studio from the Microsoft site for free. Yi ha! Only
problem is I am running XP Home which will not support SQL Server. I am wondering
if I should buy XP Professional upgrade or Windows 7 Professional.
SQL Server
(1)
Visual Studio
(1)
Windows 7
(1)
Vista
(1)
ASP.NET
(1)
XP
(1)
Database
(1)
Mike
(1)
Bob Barrows replied...
What are your criteria for making your decision?
I am curious why you chose to post this here instead of one of the sqlserver
groups. This is not really an asp question, is it. I mean, you do not mention
asp even once ...
--
Microsoft MVP - ASP/ASP.NET - 2004-2007
Please reply to the newsgroup. This email account is my spam trap so I
do not check it very often. If you must reply off-line, then remove the
WoodsieOwl replied...
Ah. The whole point is to write asp.net code using SQL Server data. I
did not mention that. If you think this belongs on another group, I will go
there, though.
Bob Barrows replied...
***canned wrong-newsgroup reply************************
There was no way for you to know it (except maybe by browsing through some
of the previous questions in this newsgroup before posting yours - always a
recommended practice) , but this is a classic (COM-based) asp newsgroup.
ASP.Net bears very little resemblance to classic ASP so, while you may be
lucky enough to find a dotnet-knowledgeable person here who can answer your
question, you can eliminate the luck factor by posting your question to a
group where those dotnet-knowledgeable people hang out. I suggest
microsoft.public.dotnet.framework.aspnet or the forums at www.asp.net.
******************************************************************
What you intend to do with the database has no bearing on your decision as
to what OS to use. Again, you need to explain your criteria. Otherwise no
one will be able to make any recommendations beyond pushing their own
favorite OS which of course, gets you nowhere.
--
Microsoft MVP - ASP/ASP.NET - 2004-2007
Please reply to the newsgroup. This email account is my spam trap so I
do not check it very often. If you must reply off-line, then remove the
MikeR replied...
FYI -
You cannot upgrade from XP to Windows 7. You must do a clean install. You can upgrade
from Vista.
Mike
Sylvain Lafontaine replied to WoodsieOwl
To my (limited) knowledge, any SQL Server Developer Edition should install
fine on XP Home. Did you try it?
--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)
Database logging with IIS 7.0 IIS Hi I am trying to setup database logging with IIS 7. I am following these instructions: http: / / weblogs.asp.net / steveschofield / archive / 2007 / 12 / 20 / iis7-post-57-how-to-setup-odbc-logging-in-iis-7-0.aspx This is not working and I am receiving the following error in the experienced here: http: / / forums.iis.net / t / 1154908.aspx This is a x64 W2K8 environment. SQL Server is 2008 I have tried the following: - Logging to a remote SQL Server and logging to a local SQL Express 2008 instance. Same problem. - Turning on ODBC
aParamSize, aParamValue) Dim dbConn, SQLcmd Dim iNumElements, iLoop Set dbConn = getConnection() 'Create Command set SQLcmd = server.createobject("ADODB.Command") SQLcmd.activeconnection = dbConn SQLcmd.commandtext = (sMainQueryString & " " & sWhereClause) SQLcmd.CommandType = adCmdText SQLcmd.NamedParameters 500 or no records returned Thanks in advance IIS ASP DB Discussions ADODB.Command (1) SQL Server (1) SQLcmd.Parameters.Append (1) SQLcmd.CreateParameter (1) SQLcmd.NamedParameters (1) SQLcmd.CommandType (1) GetRSFromParmQuery the parameter values in the order in which they appear in the string containing the sql statement. If the rest of this post does not help solve your problem, show us sWhereClause, aParamValue) '* ** *end single line* ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** Dim dbConn, SQLcmd Set dbConn = getConnection() 'Create Command set SQLcmd = server.createobject("ADODB.Command") SQLcmd.activeconnection = dbConn SQLcmd.commandtext = (sMainQueryString & " " & sWhereClause) SQLcmd.CommandType = adCmdText 'the name is crucial): Set ExecParameterisedQueryAndReturnResultSet = SQLcmd.Execute , aParamValue '* ** *end single line* ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** End Function - - Microsoft MVP - ASP / ASP.NET - 2004-2007 Please reply to the newsgroup. This email account is my spam trap so system \ ado \ msado15.dll" - -> Yes friendly errors are off but I am still getting the server 500 error. This is not a server in our office (never did get that SQL
Access to external javascript file denied IIS I have a page in an ASP.NET web application that includes an external javascript file using a fairly basic script tag: When running the application on the ASP.NET internal webserver everything works fine. When I try to host it on IIS7 however I in that *.js file and, upon closer inspection (using firebug) it appears that under IIS 7 what is returned is not the contents of the DispatchRuleControl.js file at all but instead the fully rendered Login page for the ASP.NET web appliction. . . So essentially it seems that access to that file is being denied by IIS 7. . . this causes ASP.NET to redirect to the login page and return this instead of
Classic ASP and ASP.Net - The "Big" Picture? IIS While I have been supporting a Classic ASP app for a while, and have also written some separate ASP.Net apps, my understanding is vague on some larger issues - What are the issues with mixing onto a particular language? - What environment does Classic ASP operate within (i.e. analogous to ASP.Net programs operating under CLR)? - What support to I have for the "native" Windows features under ASP.Net? Is everything done through the CLR? Do I have more direct access to Windows
IIS 7 and Enabling ASP.Net Extensions. . . IIS On Windows Server 2003 we had a cheesy little widget to determine if Asp.Net extensions were installed and enabled. It would just dump txt files based on the state us) I am wondering if I have to worry about any of this in IIS 7. How can I go about checking asp extensions are installed / registered and enabled in IIS