Wrox Programmer Forums
|
BOOK: Beginning ASP.NET 3.5 : in C# and VB BOOK ISBN: 978-0-470-18759-3
This is the forum to discuss the Wrox book Beginning ASP.NET 3.5: In C# and VB by Imar Spaanjaars; ISBN: 9780470187593
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning ASP.NET 3.5 : in C# and VB BOOK ISBN: 978-0-470-18759-3 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 March 1st, 2009, 05:17 PM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Ah, I see. It's been a long time since I used something like MySql, so I can't tell whether it's supposed to work or not.

Are you using a separate connector to connect to MySQL? If not, maybe installing one adds the necessary tools to support this behavior? http://www.mysql.com/products/connector/net/

Just guessing here, but it may work out for you....

Cheers,

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
 
Old March 1st, 2009, 05:59 PM
Registered User
 
Join Date: Mar 2009
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I think you got it, I used the ODBC connector, not knowing that there was a .NET specific connector.

Here's the latest for .NET:
http://dev.mysql.com/downloads/connector/net/5.2.html

I found it amongst the other connectors here:
http://dev.mysql.com/downloads/

Thanks, I'll give it a try and report back.

Last edited by nielseno; March 1st, 2009 at 06:00 PM.. Reason: misspelling
 
Old March 1st, 2009, 07:56 PM
Registered User
 
Join Date: Mar 2009
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Well, I installed the new connector and the only thing that changes was that I now have a MySQL option immediately available in the Data Dource portion of the Add Connection Dialog box, which effectively simplified the connection creation process but didn't affect the behavior when dragging a table over to the cpMainContent area.

So, I guess that seems to be the expected behavior when using a non-Microsoft database. Would you know if wrox would have a book dealing with DB connections to non-Microsoft databases?

BTW, I have a full version of VS on one PC and the Express version on another. After installing the connector on the Express version, the MySQL database connection option did not show. Not sure if that's a bug or not but I plan on posting to MySQL to see...

Last edited by nielseno; March 1st, 2009 at 08:03 PM.. Reason: Add info
 
Old March 2nd, 2009, 02:16 PM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Quote:
Would you know if wrox would have a book dealing with DB connections to non-Microsoft databases?
There's a (generic) ADO.NET book that deals with, among others, MySQL: http://www.wrox.com/WileyCDA/WroxTit...764584375.html

Cheers,

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
 
Old March 2nd, 2009, 02:33 PM
Registered User
 
Join Date: Mar 2009
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I'll check it out.

Also, I've done some looking around both on the MySQL website and the ASP.net website and it seems like a lot of people are having issues with the MySQL connection. The asp forums seem to have more activity.

http://forums.asp.net/56.aspx
 
Old March 5th, 2009, 08:46 PM
Authorized User
 
Join Date: Feb 2009
Posts: 17
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I'm stumped.

I am able to query the pubs and northwind db's with server name "localhost\sqlexpress" in Visual Studio but I cannot connect with SQL Server Management Studio Express. I have tried every possible combination: (name of computer\SQLEXPRESS), (local)\sqlexpress

Do I need to create a new instance of sql?

Here' the error:

TITLE: Connect to Server
------------------------------
Cannot connect to (localhost)\sqlexpress.
------------------------------
ADDITIONAL INFORMATION:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

I do have both VWD 2008 and VS 2008 installed on Vista.

Thanks, Kevin
 
Old March 6th, 2009, 03:47 AM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

You shouldn't use (localhost), but only (local) or simply a dot .\SqlExpress

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
 
Old March 6th, 2009, 10:32 AM
Authorized User
 
Join Date: Feb 2009
Posts: 17
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks Imar, I really appreciate your help with this, but that didn't work either.

I "Enabled" Remote Connections as described on page 690/Appendix B but that did not work either. Should I enable "Via" I don't know, very frustrated!

This connection string works in VS:

Code:
 
<add name="NorthwindConnectionString" connectionString="Data Source=localhost\sqlexpress;Initial Catalog=Northwind;Integrated Security=True"
providerName="System.Data.SqlClient" />

Kevin
 
Old March 6th, 2009, 10:46 AM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Maybe this helps: http://imar.spaanjaars.com/QuickDocId.aspx?ID=395

Check out the section "Other issues" at end in partcuclar....

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
 
Old March 6th, 2009, 10:47 AM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

And have you tried:

(local)\SqlExpress

or

.\SqlExpress

instead of

localhost\sqlexpress

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!





Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with Visual Studio 2008 IDE dotnetDeveloper Visual Studio 2005 1 December 6th, 2008 12:55 PM
Visual Studio 2008 .NET3.5 TashaAT BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 4 September 7th, 2008 12:13 PM
very new to Visual Studio 2008 Joel Saren Visual Basic 2008 Essentials 2 June 6th, 2008 03:27 PM
Visual studio 2008 - wap Feodorov Other Programming Languages 1 March 11th, 2008 09:17 PM
Visual Studio 2008 looks juzjess Intro Programming 0 October 26th, 2007 03:35 PM





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