Juan
Wed Mar 12 18:11:36 CDT 2008
Looks like you're missing the port MySQL uses...
Driver={MySQL ODBC 3.51 Driver};Server=data.domain.com;Port=3306;Database=myDataBase;User=myUsername;
Password=myPassword;Option=3;
Why aren't you using Connector/Net 5.1 ?
It's designed specifically for .Net usage...
Download it here :
http://dev.mysql.com/downloads/connector/net/5.1.html
Juan T. Llibre, asp.net MVP
asp.net faq :
http://asp.net.do/faq/
foros de asp.net, en español :
http://asp.net.do/foros/
======================================
"Stonewall" <Stonewall@discussions.microsoft.com> wrote in message
news:92EEB4A6-0BAF-455A-ADD9-FE5406A0F6A0@microsoft.com...
> So how do I get it to connect to my server database? I want to test the app
> with my database on the internet.
>
> "Eliyahu Goldin" wrote:
>
>> localhost:50977 has nothing to do with database. It is your webserver.
>>
>> --
>> Eliyahu Goldin,
>> Software Developer
>> Microsoft MVP [ASP.NET]
>>
http://msmvps.com/blogs/egoldin
>>
>>
>> "Stonewall" <Stonewall@discussions.microsoft.com> wrote in message
>> news:49306549-282B-4DA9-AB5D-A0ADCD3C363C@microsoft.com...
>> >I want the program to connect to a database on the server but it's not
>> > connecting to it. So you are saying localhost:50977 is the database on my
>> > server? It doesn't seem like it. Here's what I thought the URL address
>> > should lbe:
>> >
http://66.36.240.205/AmSoftApps/login.aspx
>> > Instead it looks like this:
>> >
http://localhost:50977/root/login.aspx
>> >
>> > "Eliyahu Goldin" wrote:
>> >
>> >>
http://localhost:50977/root/login.aspx tells your browser to get
>> >> login.aspx
>> >> page from http server running on your local machine and listenning to
>> >> port
>> >> 50977. In fact, this is the development server that comes with VWD 2005.
>> >>
>> >> Server=66.36.240.205 tells your program to connect to a database located
>> >> on
>> >> that server.
>> >>
>> >> There is no conflict between the two.
>> >>
>> >> --
>> >> Eliyahu Goldin,
>> >> Software Developer
>> >> Microsoft MVP [ASP.NET]
>> >>
http://msmvps.com/blogs/egoldin
>> >>
http://usableasp.net
>> >>
>> >>
>> >> "Stonewall" <Stonewall@discussions.microsoft.com> wrote in message
>> >> news:2A0FFCDB-219F-4340-9466-8C219BC6FEE6@microsoft.com...
>> >> >I am trying to view a project using web developer 2005 on a vista laptop
>> >> > using this connection string in the web.config file.
>> >> >
>> >> > <add name="AmSoftMgt" connectionString="Driver={MySQL ODBC 3.51
>> >> > Driver};Server=66.36.240.205;Database=AmSoftMgt;User=AmSoftWeb;Password=AmS0ftW3b;Option=3;"/>
>> >> >
>> >> > But every time I debug (with no errors) or preview a page, the project
>> >> > loads
>> >> > at
http://localhost:50977/root/login.aspx
>> >> >
>> >> > I have searched my entire solution for any other references to
>> >> > localhost
>> >> > and
>> >> > none exist. Why does it keep loading in localhost?
>> >> >
>> >>
>> >>
>> >>
>>
>>