RE: [cobalt-users] windoze server space

["Neil Stringer" <neil@xxxxxxxxxxxxxxx>]

> 
> There is a MySQL gui for windows called MySQL Front which allows you 
> to import an access database.  You could then drop access and not 
> have to bother with another server.
> 
> The development of MySQL front as stopped but the latest version 
> (2.5) is stable.  Not sure of an address for it, try searching 
> google.
> 

I think there is also an wintel ODBC driver for MySql, so you could use
access to export the data to MySQL directly, then just use a DSNless
connection in the ASP to search the data as you do now...

E.g.

	MyConnectionString =
"Driver={MySQL};SERVER=localhost;DATABASE=dbname;UID=userid;PASSWORD=pas
sword"
 	MySQL = "SELECT .... Some SQL here....;"
 	Set conADOdb = Server.CreateObject("Adodb.Connection")
 	conADOdb.Open MyConnectionString 
 	Set rsForMySQL = server.CreateObject("ADODB.Recordset")
 	rsForMySQL.ActiveConnection = conADOdb
 	rsForMySQL.Open MySQL