| Author |
 Topic  |
|
|
Yamaboy
Starting Member
46 Posts |
 Posted - 23 June 2006 : 13:01:06
|
I have looked at past topics and still can't figure out why my connection is failing. The error message I get after moving all file and databases from a linux server to another linux server (lunar pages) is;
Error Type:
ADODB.Connection.1 (0x80004005)
SQLState: S Native Error Code: 2002 [TCX][MyODBC]Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
inc_header.asp, line 106
I have tried both versions;
strConnString = "driver=MySQL;server=localhost;uid=xxx;pwd=xxx;database=xxx" '## MySQL w/ MyODBC v2.50
'strConnString = "driver={MySQL ODBC 3.51 Driver};option=4;server=localhost;user=xxx;password=xxx;DATABASE=xxx;" '##MySQL w/ MyODBC v3.51
Here is information that may be helpful;
PHP is 4.4.1
mySQL is 4.1.18-standard
--mySQL info is
--Server: Localhost via UNIX socket
--User: xxx@localhost
host has told me that ODBC is v2.5
I tried installing a new forum and new database and still get the same error. To me that tells me my connection string is wrong. I have tried changing permissions and other possible variables, but I still can't seem to connect on the new server.
Any help to get things up and running again would be really appreciated. |
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 24 June 2006 : 00:36:15
|
What asp emulator are you using on the new host, is it the same as the old server?
|
======
Doug G
======
Computer history and help at www.dougscode.com |
 |
|
|
Yamaboy
Starting Member
46 Posts |
Posted - 24 June 2006 : 10:51:22
|
| I'll have to find out from the host. According to them, the only difference was the PHP version on the old and new server were slightly different. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 24 June 2006 : 20:44:57
|
PHP doesn't have anything to do with Snitz. You need asp for Snitz, either from a windows server or using Sun One emulator on *nix. There are other linux asp emulators, like apache:asp, but they don't support Snitz.
|
======
Doug G
======
Computer history and help at www.dougscode.com |
|
|
|
Yamaboy
Starting Member
46 Posts |
Posted - 26 June 2006 : 10:45:46
|
| I am on the phone with the host now. Just looking at come of the server particulars on my own, I see that .asp is a system defined handler as chiliasp. Does that mean anything to anyone? |
|
|
|
Yamaboy
Starting Member
46 Posts |
Posted - 26 June 2006 : 11:22:56
|
Another note. If I decide to go to a windows host with the same ISP, would it be possible to move the database over from mysql to an ms sql version or maybe import the data?
-edit* mySQL is availible on the windows server. Any problems with moving from linux/unix to windows and keeping the database intact? |
Edited by - Yamaboy on 26 June 2006 11:33:55 |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 28 June 2006 : 01:43:44
|
Snitz and mysql works for me on an internal LAN.
|
======
Doug G
======
Computer history and help at www.dougscode.com |
|
|
|
Yamaboy
Starting Member
46 Posts |
Posted - 28 June 2006 : 12:59:44
|
| Thanks for the help. Things are looking good. I moved to a windows server and through some trial and error I was able to import the mysql database (finally, without sql parsing errors) to the new server from linux. My fault for not realizing that windows makes snitz really happy. As soon as the DNS change propigates, all that should need to be done is to re-upload the forum. |
|
|
|
optimal
Starting Member
12 Posts |
Posted - 15 February 2007 : 03:35:55
|
quote:
Originally posted by Doug G
PHP doesn't have anything to do with Snitz. You need asp for Snitz, either from a windows server or using Sun One emulator on *nix. There are other linux asp emulators, like apache:asp, but they don't support Snitz.
I just signed up for a month's trial with a linux host that has Red Hat Fedora Core 4 OS and appache::asp installed. It is a virtual dedicated server so I can load anything I want but it is up to me to support whatever I load. Question is do you know if I can load and run the Sun One emulator with apache::asp already installed without having conflicts with the double installation? |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
| |
Topic |
|
Topic Locked
