Connecting to onlien database... help please..

[unborn]

Ok my website is mindchips.com

for the database server is that all i put? how do i know what port? i know my database name and user and password but i cant get it to connect to my mySQL database on my site for anything. I dled the mySQL database thing to connect but still no luck.. i tried dling an example and just puting my info in and it did not work still.. any suggestions?

  Set conn = New ADODB.Connection
  conn.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};" _
                        & "SERVER=[URL unfurl="true"]www.mindchips.com;"[/URL] _
                        & " DATABASE=hp161_linkage;" _
                        & "UID=hp161_linkage;PWD=(pass); OPTION=3"

thats isnt the only code in the source to connect but i believe thats the information i have wrong -TO- connect.. when i work in php i use "localhost" but its not local now its remote..

thanks for the help!!

in the begining man created code.
in the end code will create man.
clones are coming only matter of time.
examples?

http://planetsourcecode.com

 

[jebenson]

The default TCP port for MySQL is 3306, but many web hosting providers/administrators change this. I once had this same problem, spent about a week working with the hosting company's tech support to find out why I couldn't connect, and finally someone informed me that the MySQL server was running on port 3310.

Basically, you need to check with whoever is hosting the server and request full connection information, and be sure to ask if they are using a non-default port.

Hope this helps.


I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson