RE: Connecting to MySQL from ASP

[Bill J. Vallance]

Depending on what driver of MySQL ODBC you are using.
The one below I use for v3.51:
strConnString = "drver={MySQL ODBC 3.51
Driver};server=SERVER_IP;database=DB_NAME;user=UID;password=PWD;OPTION=4

The one below I used in the past for v2.50:
strConnString =
"driver=MySQL;server=SERVER_IP;uid=UID;pwd=PWD;database=DB_NAME"

Bill

-Original Message-
From: Ratmil Torres [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 06, 2003 8:11 AM
To: [EMAIL PROTECTED]
Subject: Connecting to MySQL from ASP


Hi. I am developing a web site using ASP. I need to connect to a MySQL
Server. I am using ODBC, so how should the connection string be? I have
already installed the ODBC driver for MySQL.
Thanks.



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: deleting old odbc driver

[Bill J. Vallance]

Gustavo,

At this moment this is the only way I know how to remove the old ODBC
driver.  Run regedit go to "My
Computer\HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI".

Find the folder with the old MySQL driver name (most likely just MySQL).
Open up that folder and you should see a couple files listed.  These
files you can delete. 
BEFORE DELETING FILES MAKE SURE THE NEW ODBC DRIVER DOES NOT USE THEM.
You can make sure by opening up the new MySQL driver folder and double
check the same files are not listed.  If a file is listed in both
directories then do NOT delete that file.

Now select the old MySQL driver folder and delete it.
Now go to "My
Computer\HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers"
Find the string with the old MySQL driver name and delete it too.

You are all set.
Bill

-Original Message-
From: Gustavo A. Baratto [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, July 30, 2003 10:03 AM
To: '[EMAIL PROTECTED]'
Subject: deleting old odbc driver

I want to remove the old 2.50 myodbc driver. I installed a new version 
of myodbc, and the old driver is still being diplayed in the list...
I know this is not really a mysql problem, but I'm not much of a windows

user and google didn't return good results this time... maybe someone 
here could give me hint...

thanks
-- 





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: MySQL ODBC Help

[Bill J. Vallance]

Something you may want to try.  Look in this file C:\WINNT\system32\drivers\etc\hosts 
and make sure this entry is in there 
127.0.0.1   localhost

Also make sure a ";" or "#" is not in front of the line.  If the line does not exist 
at all then create it.

Hope that helps,
Bill

-Original Message-
From: Nils Valentin [mailto:[EMAIL PROTECTED]
Sent: Monday, July 28, 2003 6:01 AM
To: jackiesu
Cc: [EMAIL PROTECTED]
Subject: Re: MySQL ODBC Help


Hi Jackie,

I am sorry  haven't searched for any documents myself, but I can imagine that 
Google will list them up when you search for " OpenOffice MySQL Windows 
Setup".

Best regards

Nils Valentin
Tokyo/Japan


2003年 7月 28日 月曜日 17:07、jackiesu さんは書きました:
> Thank you very much for your help, but I don't run on a Linux system. Is
> there any tutorials that you know of for Windows NT/XP? Thanks again =)
> - Original Message -
> From: "Nils Valentin" <[EMAIL PROTECTED]>
> To: "jackiesu" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Saturday, July 26, 2003 6:17 PM
> Subject: Re: MySQL ODBC Help
>
>
> Hi Jackie,
>
> Having the odbc driver installed , doesnt mean that it is set up yet.
>
> You probably have just finished 25% of the complete setup.
>
> There are some good documents describing the setup:
>
> http://www.linuxworld.com/story/32629.htm
> http://www.linuxworld.com/story/32634.htm
> http://www.unixodbc.org/doc/OOoMySQL.pdf
>
> 1)Read them ALL.
> 2) Shake the gained knowledge and apply only the useful stuff ;-)
> 3) Enjoy your ODBC application.
>
> The whole procedure might take 30 minutes up to easily 1 day depending on
> your
> skill level and driver versions (incompatibilities etc. ) ;-).
>
> Good Luck !!
>
> Best regards
>
> Nils Valentin
> Tokyo/Japan
>
> 2003年 7月 26日 土曜日 23:22、jackiesu さんは書きました:
> > I've installed Apache 2, PHP 4 and I've tried to install MySQL. But when
> > I open the MySQL ODBC Driver and click Test Data Source it says
>
> [MySQL][ODBC
>
> > 3.51 Driver] Can't connect to MySQL server on 'localhost' (10061), can
> > anyone help?

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Problems with MySQL, Windows 2003, IIS6, ASP?

[Bill J. Vallance]

Hello,
I have been using Snitz forums on windows 2000 IIS5 and MySQL for the
DB.  I have set up a test Microsoft Server 2003 IIS6, but I am having
problems with the setup.  It is able to connect to the database and the
account I have set up has full rights to the db.  The problem is the
setup.asp can not create the tables.  I've posted up asking for help on
Snitz support forums, but no one else has been successful with MySQL &
Server 2003.
http://forum.snitz.com  
So my question is has anyone else had problems with MySQL and Windows
2003?  If so how did you fix it?
Thanks
Bill