My hosting company swears that I should be able to connect to a MySQL DB located on their server. To prove it they uploaded an ASP script. What the hell IS this?

<%

set Conn = server.CreateObject("ADODB.connection")

 

conn.connectionstring = "dsn=kmaster;"

conn.open

 

 

dim rs,sql

set rs = server.CreateObject("adodb.recordset")

sql ="Select * From master"

rs.open sql, conn

do until rs.eof

            response.Write(rs(0) & "<br>")

            rs.movenext

            loop

rs.close

 

 %>

It's asp code connecting to a database using a DSN (Data Source Name)

And what is complaint about anyway?

Well I can't connect via phpMyAdmin or MySQL Admininistrator. This script supposedly proves that it's not on their end. I'm not familiar with ASP, but when I run this page, it just displays...

1
2

What is that supposed to mean to me? Nowhere in the script does it specify the host, user, pass, etc.

Well, as it's ASP you wouldn't expect PHPAdmin to work really.

The hostname and user etc is setup in the DSN which you may be able to set up via your hosting control panel or the host would set it up for you.

but you can soon setup a DSNLess Connection. This is how I set mine up

const SQLServerName = "hostname"  
const SQLUserName = "username"
const SQLPassword = "password"
const SQLDatabase = "database_name"  

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

Take a look at ASP101 for their database samples and welcome to the world of real programmers not that home grown php stuff (just kidding guys)

The 1 and 2 are the scripts "Response.Write" results from looping through the record sets and displaying them "1 & 2" (starting with 0 and adding 1). It's only purpose it seems is to prove to you that you can connect to a DataBase

Have you asked your hosting company if they even support PHP? A lot of windows machines don't even bother . . . until clients specifically ask for it. If they do support PHP, please tell and I will look into your issue further.

I believe he was inquiring about ASP not PHP.

Originally Posted by phillyhotshots

Well I can't connect via phpMyAdmin or MySQL Admininistrator. This script supposedly proves that it's not on their end. I'm not familiar with ASP, but when I run this page, it just displays...

I was referring to this line that he wrote after his original post which implies that he was trying to connect using PHP - but his company gave him sample ASP code which means that he is on a windows box.

Got it. He need to connect via ASP. PHP on a windows server is great for giving away code.