ASP and SQLyog

[farrel]

😮 I'm new at databases and ASP and VBscript. I'm tying to teach myself some server-side applications, so I would like to find out if anyone knows about ASP working alongside SQLyog.

[Ritesh]

ASP is a server side scripting language like PHP whereas SQLyog is GUI for MySQL.

If you are using ASP with MySQL, then I guess SQLyog is the answer for MySQL GUI.

Which database do you plan to use with ASP?

[Shadow]

I use them both without any problem! I would be greatly surprised if any one of them interfered with the other 😀

[SSS]

As an experienced ASP developer, I can tell you that MySQL is a great database backend with IIS/ASP. WebYog won't interfere since it is a direct connection to your database.

A few suggestions:

1) For ASP, use an ODBC connection instead of a DSN. MySQL reads ODBC calls VERY QUICKLY, and this saves your Windows server from doing a registry lookup for the DSN which ultimately means faster connections under heavy loads. Good book on ASP/vb script: Wrox press Beginning ASP 3.0 (getting tougher to find nowadays).

2) CLOSE ALL RECORDSET,COMMAND AND CONNECTION OBJECTS — at the end of every asp page. This keeps things clean and prevents lockups (yes, even if you are using connection pooling on your Windows server).

3) Run your MySQL on a linux box and connect to it from your Windows server if possible. This works much better than using MySQL on the same box as your Windows Server (MySQL can be a resource hog on some Windows configurations, better scaling on linux, security, data is separate from application, etc).

4) If you are using an insecure connection to your database server via webyog, I strongly suggest you use a secure connection by using an SSH client. I recommend using PuTTY because it's free and easy to use:PuTTY – a free SSH client tool

Here's instructions from the MySQL site on setting up your SSH connection: Connecting to MySQL Remotely from Windows with SSH

PuTTY isn't very intuitive to set up for a newbie, so here's some extra advice:

Session: select SSH, type in host name or IP address.

Skip the Terminal & Window categories — default should be okay.

Connection: if you go through Proxy, click on it to configure.

– Click on SSH; select “SSH2 only” as preferred.

– Click on Tunnels; under port forwarding/add a new port: Source port = “3306” Destination = “[host name or IP address]:3306” select the “local” radio button

Go back to the session category, type in a session name and click save.

Now as long as you have local access on your MySQL server and a system user account with sufficient rights, you can now open PuTTY, load the session, and type in your user name and password.

Now open webyog, use “localhost” as your MySQL host address, type in your user name/password, and your good-to-go with a secure SSH tunnel to your database server!

Good luck! 😀

[rdsekar2k1]

QUOTE (farrel @ Oct 16 2003, 02:53 PM)

😮 I'm new at databases and ASP and VBscript. I'm tying to teach myself some server-side applications, so I would like to find out if anyone knows about ASP working alongside SQLyog.

i know asp and mysql also

[Author]

Posts