I'm using dreamweaver cs3 and trying to create a mysql data connection on the
asp.net frameset. I downloaded mysql 5.1 and installed it as shown on a video
from lynda.com. I created a database using MySQL Administrator.

When I try to make a connection, I cannot fine MySQL in the list of Data
Sources. How do I add MySQL in windows OCBC Data Source Administrator? I
downloaded and installed MySQL Connect Net v1.010.1 and v5.16 and I still see
no MySQL data source to choose...

I have XP PRO with IIS installed.

"VeganMan007" <webforumsuser@macromedia.com> wrote in message
news:g5igu6$d0$1@forums.macromedia.com...
> I'm using dreamweaver cs3 and trying to create a mysql data connection on
> the
> asp.net frameset. I downloaded mysql 5.1 and installed it as shown on a
> video
> from lynda.com. I created a database using MySQL Administrator.
>
> When I try to make a connection, I cannot fine MySQL in the list of Data
> Sources. How do I add MySQL in windows OCBC Data Source Administrator? I
> downloaded and installed MySQL Connect Net v1.010.1 and v5.16 and I still
> see
> no MySQL data source to choose...

did you install the ODBC drivers? Did you create a DSN (if you're wanting to
use a DSN)?

You'll probably need to use myOLEDB.

--
Jules
http://www.charon.co.uk/products.aspx
Charon Cart
Ecommerce for ASP/ASP.NET


"VeganMan007" <webforumsuser@macromedia.com> wrote in message
news:g5igu6$d0$1@forums.macromedia.com...
> I'm using dreamweaver cs3 and trying to create a mysql data connection on
> the
> asp.net frameset. I downloaded mysql 5.1 and installed it as shown on a
> video
> from lynda.com. I created a database using MySQL Administrator.
>
> When I try to make a connection, I cannot fine MySQL in the list of Data
> Sources. How do I add MySQL in windows OCBC Data Source Administrator? I
> downloaded and installed MySQL Connect Net v1.010.1 and v5.16 and I still
> see
> no MySQL data source to choose...
>
> I have XP PRO with IIS installed.
>

Hi Hunter,

I have many drivers but none are for MySQL. I thought installing MySQL Connent
would do that. If I'm wrong, could you provide some direction?

How can I create a dsn to mysql with no mysql ocbc drivers?

"VeganMan007" <webforumsuser@macromedia.com> wrote in message
news:g5imo0$6hg$1@forums.macromedia.com...
> Hi Hunter,
>
> I have many drivers but none are for MySQL. I thought installing MySQL
> Connent
> would do that. If I'm wrong, could you provide some direction?

mySQL has ODBC drivers on their site to d/l. And, no, just installing the DB
will not install the ODBC drivers.


> How can I create a dsn to mysql with no mysql ocbc drivers?

I don't know that you can. You didn't really state how you were trying to
connect, so that's why I asked those generic questions.

Hi again Hunter,

As mentioned, I downloaded MySQL Connect Net which have the drivers. I
rebooted my computer and noticed the driver, MySQL ODBC 5.1, in the drivers tab
of my ODBC Data Source Administrator (and in the connection pooling tab). It's
not in any other tabs.

However, I can't see it in dreamweaver when I try to make a connection. I have
only two choices to connect. Neither show MySQL to make a connection

"VeganMan007" <webforumsuser@macromedia.com> wrote in message
news:g5iqop$aqa$1@forums.macromedia.com...
> Hi again Hunter,
>
> As mentioned, I downloaded MySQL Connect Net which have the drivers. I
> rebooted my computer and noticed the driver, MySQL ODBC 5.1, in the
> drivers tab
> of my ODBC Data Source Administrator (and in the connection pooling tab).
> It's
> not in any other tabs.

Should it be in any other tabs?

>
> However, I can't see it in dreamweaver when I try to make a connection. I
> have
> only two choices to connect. Neither show MySQL to make a connection

Probably because DW only "sees" mySQL for PHP pages. I use it for regular
ASP pages, but I make a system DSN and use it. As for .NET? Its
functionality is limited at best in DW and all support for it will drop in
the next version AFAIK. Expressions Web or MS' Visual Studio are what most
..NET people use for their pages, I believe.

Oh that's wonderful... I'm on disability and spent every last $ getting a new
system and the master collection cs3. I just got it last week.

There must be a way to connect mysql to asp.net pages.

How do you make a system DSN

"VeganMan007" <webforumsuser@macromedia.com> wrote in message
news:g5j11e$hfl$1@forums.macromedia.com...
> Oh that's wonderful... I'm on disability and spent every last $ getting a
> new
> system and the master collection cs3. I just got it last week.

Adobe may have a 30 day return policy - you'd have to check with Adobe on
that. Otherwise it's pretty well documented on Adobe's site that .NET
functionality is limited and going away in the future.

> How do you make a system DSN

If you open your ODBC Data Source Administrator in Control Panel, the HELP
function has the info on creating them. Just be aware that you may not have
access to this on any remote servers.

First link is to download MySQL ODBC driver. Once downloaded and installed,
second link will help you configure it.

http://dev.mysql.com/downloads/connector/odbc/5.1.html

http://dev.mysql.com/doc/refman/5.1/...n-windows.html

Hope this helps.

Thanks,
Deven