Does anyone have any sample Classic ASP/VBScript code for accessing a MySQL database?

I have tried a ton of code I found through Google, but nothing seems to work.

Would just like a small piece of code that connects to a MySQL server and database and passes a simple "SELECT title FROM mytable" and displays all the results.

Generally it's the same as any other database. Only the driver is different.

'  SQL server parameters.
const SQLServerName = "ServerName"
const SQLUserName = "User"
const SQLPassword = "pass"
const SQLDatabase = "dbName"  

dim m_sConnString : m_sConnString = "driver={MySQL ODBC 3.51 Driver}"
	m_sConnString = m_sConnString & ";server="
	m_sConnString = m_sConnString & SQLServerName 
	m_sConnString = m_sConnString & ";uid="
	m_sConnString = m_sConnString & SQLUserName 
	m_sConnString = m_sConnString & ";pwd="
	m_sConnString = m_sConnString & SQLPassword
	m_sConnString = m_sConnString & ";database="
	m_sConnString = m_sConnString & SQLDatabase
	m_sConnString = m_sConnString & ";option=16387"

dim m_oConn : set m_oConn = Server.CreateObject("ADODB.Connection")
dim m_oRS : set m_oRS = Server.CreateObject("ADODB.Recordset")

m_oConn.open m_sConnString

dim m_sSQL : m_sSQL = "SELECT fieldlist FROM table"

m_oRS.Open m_sSQL, m_oConn, adOpenStatic, adLockReadOnly, adCmdText

'check recordset and use it if records found
'rest of page code



m_oRS.close
set m_oRS = nothing
m_oConn.close
set m_Conn = nothing

I have tried a ton of code I found through Google, but nothing seems to work.

The ODBC driver is installed on your server / test machine I take it?

I'll give that a try. I'm hosting with GoDaddy and they don't provide any sample scripts for connecting to MySQL from ASP.

You have to install MyODBC on the server if it's going to work.

Originally Posted by Learning Newbie

You have to install MyODBC on the server if it's going to work.

Not my server, so this will be interesting...

Originally Posted by dnavarrojr

I'll give that a try. I'm hosting with GoDaddy and they don't provide any sample scripts for connecting to MySQL from ASP.

maybe there's a reason for that.

Originally Posted by dnavarrojr

Not my server, so this will be interesting...

Ahhh. They're asking you to make 2 + 2 = 5?

Ask GoDaddy about the ODBC driver version of mySQL. I had similar problem with my webhosting company. I asked then and after wating for 2 days, finally they gave me driver version of mySQL installed on their servers.

hi

How can i install mySQL on their servers?

You can't.

Finally called their support team and they are going to email me the correct connect string shortly.