Access to mysql database help 1

[krappleby025]

can someone help me, i have never worked with mysql, i need a few things and answers,

1.. i currently use an access database connection and scripting set up for that.. If i change to the mysql database then would i need to change all the scripting to reflect that, or just change the connection string?

2.. If i send someone a copy of the database, in access, can someone please make an exact duplicate in mysql. and send me the file back.. (ps, including the field names, varialbles etc must be exactly the same, due to the scripting)

3.. can someone also please send me the connection string for the mysql database connection. at the moment i use a odbc access string...


<%
dim con
Set con = server.Createobject( &quot;ADODB.Connection&quot; )
Con.Open( &quot;DRIVER={Microsoft Access driver (*.mdb)}; DBQ=&quot; & server.MapPath(&quot;****.mdb&quot; ) )
%>

I hope someone can help me... thank you in advance

thanks

 

[snowboardr]

MySQL database, is not a file like it is with Access, MySQL is a database server, and you create the database within the MySQL server.. I suggest, finding a copy of MySQL front, the project has been discontinued, but you should be able to find a copy of it.

MySQL connection string:

conn.open = "DRIVER={MySQL ODBC 3.51 Driver};"_
							& "SERVER=localhost;"_ 
							& "DATABASE=database_name;"_
							& "UID=root;PWD=; OPTION=35;"

I have a tutorial on my website, for setting up MySQL.

http://www.vzio.com/tutorial

Hope that helps.
- Jason www.vzio.com
ASP WEB DEVELOPMENT

 

[snowboardr]

http://www.vzio.com/tutorials

oops www.vzio.com
ASP WEB DEVELOPMENT

 

[krappleby025]

Thanks for you help, i have now transfered the site to a mysql server, however i am getting and error with the insert statements.. Please help, take a look at the post today, about

ASP insert to MYSQL

thanks very much

keith