IIS - Simple ASP DB problem.

Asked By Des

17-Jan-08 09:01 PM

I am trying to connect to a MySQL database on a windows server using
ASP / ADODB

I keep getting unable to display page

http://www.desmond-otoole.co.uk/index.asp

Any sugestions?

15-Jan-08 10:27 AM

Not without seeing the code used to connect, as well as the acutal error
message ... do you have "friendly errors" shut off so you you can see
the actual errors in your browser?
http://www.aspfaq.com/show.asp?id=2109

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

17-Jan-08 09:01 PM

On 15 Jan, 15:27, "Bob Barrows [MVP]" <reb01...@NOyahoo.SPAMcom>

------------------
Hear is the entire code for the page. This is a MYSQL database


Set connection = Server.CreateObject("ADODB.Connection")
Set rsResult = Server.CreateObject("ADODB.Recordset")

sqlconn =
connection.Open sqlconn

sqlResults = "SELECT * FROM Members"

rsResult.Open  sqlResults, connection
rsResult.MoveFirst
sName = rsResult("f_name")

echo sName
%>

15-Jan-08 01:06 PM

mondot;Pwd=s131679"
This is all the code I really needed to see. I don't use MySQL so I'm
not sure how the server is supposed to be referred to. Maybe you can try
an example at www.connectionstrings.com

Where is the error message you are getting? You could modify your code
to have vbscript handle the error and display the actual error message,
like this:

on error resume next
connection.Open sqlconn
if err <> 0 then
Response.Write err.message
else
'open the recordset and process it
end if

You are limiting our ability to help you by not telling us what error
message you are getting.

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

15-Jan-08 01:19 PM

Echo? Should be:

Response.Write sName

If that does not work, remove all other code, and have one line:


Response.Write "Hello World"

%>

and go from there

Jeff

17-Jan-08 09:01 PM

r
109
id=3Ddesmon=ADdot;Pwd=3Ds131679"

-----------------
Error is
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name not found and no
default driver specified

/index.asp, line 9


Line 7: sqlconn =3D
=3Ddesmondot;Pwd=3Ds131679"
Line 8: conn.ConnectionString =3D sqlconn
Line 9: conn.open

Desmond

15-Jan-08 01:43 PM

mondot;Pwd=s131679"
Ok, have you verified the syntax of your connection string a
www.connectionstrings.com?
The "mysql12.streamline.net" bit looks suspicious to me, but I'm used
the MS SQL Server, so that could be the correct way to refer to it. You
should verify with a mysql newsgroup.

Assuming the name you are using is correct, is that database server
accessible to the web server? And particularly, is it accessible to the
user account being used to run your code? If your website allows
anonymous access, then that user account is the IUSR_MachineName account
(replace "MachineName" with the name of the machine running the web
server ... )

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

17-Jan-08 09:01 PM

g
ror

=3D2109
a
;Uid=3Ddesmon=AD=ADdot;Pwd=3Ds131679"
=3Ddesmon=ADdot;Pwd=3Ds131679"

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
Thanks Guys. I have changed the connection string to
Driver};Server=3Dmysql12.streamline.net;Database=3Ddesmondot;Uid=3Ddesmondot=
;Pwd=3Ds131679"
NOW this works

Cheers -> Desmond

15-Jan-08 05:11 PM

NOW would be a very good time to change your password.

15-Jan-08 05:20 PM

Ted Dawson wrote on 15 jan 2008 in microsoft.public.inetserver.asp.general:


Now would be a better time to learn quoting, Ted.

--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)

15-Jan-08 06:24 PM

Didn't want to repeat the PW again.