I am in the process of setting up a forum/message board website.

My hosting (easily.co.uk) has php, mysql etc - everything that’s needed

However I can’t update the mysql database remotely (ODBC, DSN connections), but I can locally through an asp/php script to update the mysql

My hosting company has limited support for php matters but has suggested I use this code:

<%
ConnString = "Driver={MySQL};SERVER=localhost;DATABASE=dbname;U ID=xxx;PWD=yyy"

Set conn = Server.CreateObject("ADODB.Connection")
conn.Open ConnString

%>


But I don’t know where I should include the code and what the file type should be (.php?)

If anyone knows how I can use this code or even knows a better method than this to access the mysql locally, I'd be most grateful of your help.

Thanks

Hi Martin,

You should probably include that somewhere near the top of your screen, and the code you have posted above looks like ASP code to me.

Just keep this in mind: <% ... %> is ASP and <? ... ?> is PHP.

Good luck!

Sorry could you be a bit more specific on what I need to do? like where have I to include the above code?

Martin,
Did you find a solution to your problem? Because I also have hosting with Easily and am having the same difficulty connecting to my database (from ASP though). The connection string I'm trying to use looks just like the one you have written. All I get is

ADODB.Connection.1 error '80004005'

SQLState: IM002
Native Error Code: 0
[INTERSOLV][ODBC lib] Data source name not found and no default driver specified

If you have any info, would much appreciate a reply.