Wrox Programmer Forums
|
BOOK: Beginning ASP.NET Dynamic Websites w/ Web Matrix
This is the forum to discuss the Wrox book Beginning Dynamic Websites: with ASP.NET Web Matrix by Dave Sussman, James Greenwood, Alex Homer, Colt Kwong, John M. West; ISBN: 9780764543746
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning ASP.NET Dynamic Websites w/ Web Matrix 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 May 3rd, 2005, 12:33 PM
Registered User
 
Join Date: May 2005
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to supercres
Default Can't connect to any DB server

I had some trouble configuring the MSDE server that came with the book, so I installed MySQL on my winXP sp2 pc. I've verified that I can connect to it using the "mysql administrator" software from mysql.com. I have 3 databases set up in mysql that I can see from mysql admin which I have granted full access to all the users. The server is running on port 3307. web matrix is installed on the same machine, but I can't connect to the mysql server from webmatrix. I'm guessing it has to do with what I'm typing in the "server" field. I've tried localhost, localhost:3307, localhost\mysql, localhost\mysql:3307, localhost\mysqld, localhost\mysqld:3307, 192.168.0.5, 192.168.0.5:3307, etc...
Nothing I've tried from webmatrix has gotten me anywhere. DB access is the main reason I got this book too, so I can't just skip the chapter.

 
Old August 4th, 2005, 06:03 PM
Authorized User
 
Join Date: May 2005
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I know nothing about MySQL ,but I used to have trouble
with MSDE2000 too. I had an idea that MDAC comes along
with .NET Framework ,so no need to install it. As a result
I couldn't create any database(look at my post).
Then in the other Wrox book
"Beginning ASP.NET 1.1 with Visual C# .NET 2003" on p.12
        I read :
"you need to install the Microsoft Data Access Components
(MDAC) version 2.7 or later ... enable you to communicate with databases and display the contents of your database on a Web page
MDAC is a free download from http://www.microsoft.com.
Version 2.7 comes as part of Windows Component Update of the
.Net Framework and the Windows XP Service Pack, so if you've
installed these you won't need to install it again"
         However ,after I installed MDAC it started working.
By the way you can try forum http://forums.asp.net/
Michael





Similar Threads
Thread Thread Starter Forum Replies Last Post
How to connect to DB rtr1900 VB Databases Basics 4 December 5th, 2006 03:36 PM
Connect to DB hernann C# 2005 2 July 31st, 2006 05:06 PM
pear db::connect turing PHP Databases 1 September 15th, 2004 05:22 PM
how i can connect to remote sql server db yoord ADO.NET 16 June 16th, 2004 01:40 AM





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