Wrox Programmer Forums
|
BOOK: ASP.NET Website Programming Problem-Design-Solution
This is the forum to discuss the Wrox book ASP.NET Website Programming: Problem - Design - Solution, Visual Basic .NET Edition by Marco Bellinaso, Kevin Hoffman; ISBN: 9780764543869
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: ASP.NET Website Programming Problem-Design-Solution section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 16th, 2004, 08:23 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 917
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I also have the developer's edition, but mine listens on 1433. This is what Books On Line (BOL) says:

The default number for a default instance is 1433, the official IANA socket number for SQL Server. The port for a named instance is dynamically assigned when the instance is first started, unless you set an alternate port during setup.

If I search for 1039 in BOL, I get no hits. If I search for 1433, I get a number of hits.

Could you have already had something on port 1433 when you installed it? Maybe you had another instance of SQL Server installed at one time?

My hosted site uses a non-standard port, but that's because they have several instances of SQL Server on the same computer.

Eric
 
Old July 4th, 2004, 05:35 AM
Registered User
 
Join Date: Jul 2004
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi,

I've tried the DSN mode in every .config file using

sqlConnectionstring="DSN=MyConnection;"
(previously I tested that System DSN on my machine with standard ASP)

But does not work; I get the error:
"key word not admitted: 'dsn'"

System.ArgumentException: Palabra clave no admitida: 'dsn'.
   at System.Data.Common.DBConnectionString.ParseInterna l(Char[] connectionString, UdlSupport checkForUdl, NameValuePair& keychain)
   at System.Data.Common.DBConnectionString..ctor(String connectionString, UdlSupport checkForUdl)
   at System.Data.SqlClient.SqlConnectionString..ctor(St ring connectionString)
   at System.Data.SqlClient.SqlConnectionString.ParseStr ing(String connectionString)
   at System.Data.SqlClient.SqlConnection.set_Connection String(String value)
   at System.Data.SqlClient.SqlConnection..ctor(String connectionString)
   at Wrox.WebModules.Data.DbObject..ctor(String newConnectionString) in C:\Inetpub\wwwroot\plataforma\wrox\website\ThePhil eVB\WebModules\Core\DBObject.vb:line 32
   at Wrox.WebModules.Polls.Data.Questions..ctor(String newConnectionString) in C:\Inetpub\wwwroot\plataforma\wrox\website\ThePhil eVB\WebModules\Polls\Polls.Data\Questions.vb:line 33
   at Wrox.WebModules.Polls.Business.Question.GetCurrent Id() in C:\Inetpub\wwwroot\plataforma\wrox\website\ThePhil eVB\WebModules\Polls\Polls.Business\Question.vb:li ne 227
   at Wrox.WebModules.Polls.Web.Controls.User.Poll.DataB ind() in C:\Inetpub\wwwroot\plataforma\wrox\website\ThePhil eVB\WebModules\Polls\Poll.ascx.vb:line 260
   at Wrox.WebModules.Polls.Web.Controls.User.Poll.Page_ Load(Object sender, EventArgs e) in C:\Inetpub\wwwroot\plataforma\wrox\website\ThePhil eVB\WebModules\Polls\Poll.ascx.vb:line 62
   at System.Web.UI.Control.OnLoad(EventArgs e)
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Page.ProcessRequestMain()

What's wrong with that?

thanks
L.
 
Old July 6th, 2004, 10:29 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 917
Thanks: 0
Thanked 0 Times in 0 Posts
Default

>sqlConnectionstring="DSN=MyConnection;"

Everything is wrong with this. Where did you get this code from?

Are you putting this into the config files?

Did you read the earlier messages in this thread?

Eric





Similar Threads
Thread Thread Starter Forum Replies Last Post
VBScript or SQL solution to problem mat41 Classic ASP Professional 5 October 8th, 2008 05:13 PM
A serious string problem. Urgent solution needed. asfak XSLT 2 November 28th, 2007 06:08 AM
Windows based Problem Design Solution Book ricpue BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 5 September 1st, 2006 07:47 AM
php/mysql programming problem - design - solution jben.net Beginning PHP 8 November 14th, 2003 09:00 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.