Comparing to UBB - but trouble w/ install

[icompact]

Hi all,

I'm seriously looking for an alternative to UBB, which is ok, but crashes the server too much, and ISP keeps shutting me down. On suggestion from another member, I'm trying to install the lite version of vbulletin on my NT server. Mysql was set up for me by ISP. I'm getting the error "Warning: Can't connect to MySQL server on 'localhost' (10061) in e:\web\icompact\vbt\admin\db_mysql.php on line 31". Here are my config settings:
<?php

/////////////////////////////////////////////////////////////
// Please note that if you get any errors when connecting, //
// that you will need to email your host as we cannot tell //
// you what your specific values are supposed to be //
/////////////////////////////////////////////////////////////

// type of database running
// (only mysql is supported at the moment)
$dbservertype="mysql";

// hostname or ip of server
$servername="localhost";

// username and password to log onto db server
$dbusername="icompactdba";
$dbpassword="*****";

// name of database
$dbname="icompact";

//password needed to enter the control panel
$cppassword="icompact";

?>


Here is what my host told me when I asked what hostname or IP I should use: "Aimee, You should be able to connect to the database with the follwoing info: The DSN name is "icompact", username "icompactdba" and password "***". Please let us know if there are any problems"

What am I doing wrong?

Thanks!
Aimee

[Floris]

// Please note that if you get any errors when connecting, //
// that you will need to email your host as we cannot tell //
// you what your specific values are supposed to be //


:D


But the config looks good, and localhost is what I would recommend as entered host, however, you might want to try and enter the IP of your website where the database is running on.

Also, more information can be found in this thread: here (http://vbulletin.com/forum/showthread.php?s=&threadid=11391)

[tubedogg]

Originally posted by icompact
The DSN name is "icompact", username "icompactdba" and password "***".I have never seen a host refer to a database as a "DSN" before...Are you positive your host supports MySQL? I'm not trying to insult your intelligence or anything but the error you gave usually indicates MySQL isn't running on the machine.

[Floris]

Originally posted by tubedogg
I have never seen a host refer to a database as a "DSN" before...Are you positive your host supports MySQL? I'm not trying to insult your intelligence or anything but the error you gave usually indicates MySQL isn't running on the machine.

Doesn't MySQL have a mysql driver on Windows machine's?

(I wouldn't know, I try to boycot/avoid Windows as hosting)

[nuno]

hmm
is by any chance media3.net your host?
if so, Kevin is right
look here
http://www.media3.net/solutions/dedicated/win2k.htm

[tubedogg]

Originally posted by xiphoid
Doesn't MySQL have a mysql driver on Windows machine's?
Yes, it works fine on Windows, but it has to be installed first...

[Wayne Luke]

Verify with your host that you can access MySQL using PHP. Specifically ask if you MySQL support is compiled into PHP. They may be requiring you to access it through COM objects which we do not support.

[JamesUS]

Originally posted by tubedogg
I have never seen a host refer to a database as a "DSN" before...Are you positive your host supports MySQL? I'm not trying to insult your intelligence or anything but the error you gave usually indicates MySQL isn't running on the machine.

A DNS is the way Windows servers often handle database connections - it means the paramaters such as server address etc can be set by the host to save the user doing it and having problems.

But as Wayne said, we only support access via MySQL, not via ODBC/DSNs.

[filburt1]

On the note of vB Lite installing wrong...I never got vB Lite working, but ironically vB full worked perfectly fine for some reason. *shrug*