|
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 |
 |
 |
 |
|
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 |
|
|
|
|
|
Database