RE: Connecting to MySQL from ASP

2003-08-06 Thread 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;p

RE: deleting old odbc driver

2003-07-30 Thread 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 lis

RE: MySQL ODBC Help

2003-07-28 Thread 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

Problems with MySQL, Windows 2003, IIS6, ASP?

2003-07-24 Thread 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 c