| Author |
 Topic  |
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
 Posted - 26 October 2004 : 19:08:19
|
| Have you tried the other 2.51 MySQL Connection string as well? .. I suspect you may actually need to use a DSN connection if trying to run this on *nix so neither may work. |
Kiwihosting.Net - The Forum Hosting Specialists
|
Edited by - Gremlin on 26 October 2004 19:08:55 |
 |
|
|
Polar
Starting Member
Denmark
14 Posts |
Posted - 28 October 2004 : 01:33:10
|
quote:
Originally posted by Gremlin
Have you tried the other 2.51 MySQL Connection string as well? .. I suspect you may actually need to use a DSN connection if trying to run this on *nix so neither may work.
Hi
None of the strings work
This is info from my host could that be of any use?:
ASP connection string:
<%
Dim objConn
Dim objRS
Set objRS = Server.CreateObject("ADODB.Recordset")
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString="DRIVER={MySQL};SERVER=localhost;DATABASE=[DOMAIN_COM];UID=[DOMAIN_COM];PWD=[PASSWORD];"
objConn.Open
objRS.Open "[QUERY]", objConn, 3,3
%>
<%
objRS.Close
Set objRS = Nothing
objConn.Close
Set objConn = Nothing
%>
ODBC:
<%
ConnString ="Driver={MySQL};SERVER=localhost;DATABASE=xxx;UID=xxx;PASSWORD=xxx"Set Conn =server.CreateObject("ADODB.Connection")
Set RS = server.CreateObject("ADODB.recordset")
Conn.Open ConnString
sql = "select * from table
RS.Open sql, Conn, 1, 2
%>
Thanks for all of the help so far!
Kind regards
Morten |
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 28 October 2004 : 03:32:27
|
| Can you connect to your database using other tools? phpmyadmin, sqlyog, mysql-front etc? |
Kiwihosting.Net - The Forum Hosting Specialists
|
|
|
|
Polar
Starting Member
Denmark
14 Posts |
Posted - 28 October 2004 : 12:14:07
|
quote:
Originally posted by Gremlin
Can you connect to your database using other tools? phpmyadmin, sqlyog, mysql-front etc?
Yes
With the help of phpmyadmin
Kind regards
Morten |
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 28 October 2004 : 18:11:49
|
| I'm rapidly running out of ideas personally :( |
Kiwihosting.Net - The Forum Hosting Specialists
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Polar
Starting Member
Denmark
14 Posts |
Posted - 29 October 2004 : 01:37:45
|
quote:
Originally posted by ruirib
Does the script still time out or do you get another error message? Asked you before and got no reply...
Sorry.
It's the same time out error.
Kind regards
Morten |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Polar
Starting Member
Denmark
14 Posts |
Posted - 29 October 2004 : 20:50:29
|
quote:
Originally posted by ruirib
When you connect using phpmyadmin, are you using the same database access data?
Yes
/Morten |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Polar
Starting Member
Denmark
14 Posts |
Posted - 31 October 2004 : 11:06:47
|
quote:
Originally posted by ruirib
Have you talked to your host about it? Do other ASP apps run without problems?
That's what they tell me - no problems.
Kind regards
Morten |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Polar
Starting Member
Denmark
14 Posts |
Posted - 02 November 2004 : 12:46:31
|
quote:
Originally posted by ruirib
Well, that being the case, and given the fact that we have managed to run snitz on various Chilisoft / SunOne platforms, I don't know what else to suggest. Sorry.
OK
Thanks for all the help anyway.
Kind regards
Morten |
Edited by - Polar on 02 November 2004 12:47:07 |
|
|
|
Topic |
|
Topic Locked
