<BR>what is MySQL database? is it MS-SQL database? if it is MS-SQL here is the code:<BR><BR>Set conn = Server.CreateObject("ADODB.connection")<BR>cnstr = "Provider=MSDASQL;DATA SOURCE=dsn name;USER ID=userid;Password=userpassword"<BR>conn.open cnstr<BR>You also have to create recordset to hold your data:<BR><BR>Set Rs = Server.Createobject("ADODB.Recordset")<BR>Rs.open ("your select statement goes here")<BR><BR>Hope this help.<BR><BR>Michael<BR>
Thanks for your reply Michael. <BR><BR>MySQL is a Linux based database. It is the only database that is supported by my web hosting company. I have created the relevant tables in this database but I need to find out how to open a connection to the database using ASP code to update and insert records.<BR><BR>Any ideas ?