Home Database
 
Database
PHPMyAdmin PDF Print E-mail
Written by Support   
Tuesday, 16 June 2009 19:53

We have installed a copy of phpMyAdmin for editing / accessing your mysql database.

Please login with the relevant database user/pass at:

http://db.pobox.co.uk/phpmyadmin/

 

This allows for the creation/deletion of tables and their contents. It will not allow database deletion or new database creation.

 

If you're linking to the mysql database from your website, please use a host of db.pobox.co.uk.

 

Last Updated on Wednesday, 17 June 2009 15:01
 
DSN-Less ODBC Connection to Mysql Server PDF Print E-mail
Written by Support   
Tuesday, 16 June 2009 19:42

Customers on our 2003 hosted webserver, may wish to connect to our mysql database.  As this is located on a separate machine, you will need to create an ODBC connection.  This can be done using a DSN, which we can create for you, or you may wish to use dsn-less connections.

Details are below:

You have to provide all the details that would normally be provided if using DSNs ie, server driver type, server name, db name, user name, password etc.

Example code:

set objConn = server.createobject ("adodb.connection")
strConn = "Driver={MySQL ODBC 3.51 Driver};Server=db.pobox.co.uk; _
Database=dbname; Uid=username; Pwd=userpassword;"
objConn.Open strConn



NB: You can't use USER and PASSWORD syntax, you should use Uid and Pwd.

Last Updated on Wednesday, 17 June 2009 14:59