Hey all,
After spending much time getting the ODBC drivers, Sambar, and MySQL
working together, I'm now kinda stuck. I don't know a great deal
about writing ASP pages, but I know some, and I have a few Intranet
sites at work I've created that use ASP pages and backend to a MySQL
database running under IIS.
I am using the same version of MySQL, and the same version of the ODBC
driver on my personal Sambar webserver running under Win2K Pro, but
for the life of me, I can't figure out how to make the connection to
the database other than through Sambar .STM pages using scripting.
Here's what I have so far:
In the STM page which works:
<HTML>
<BODY>
<table border=1>
<RCQfreeppc sql="SELECT Name, Developer, Website, Filename,
Action, Arcade, Text, Board, Card, Dice, Twoplayer, Ir, Network,
Internet, Util, Productivity, Db, Game, Graphics, Multimedia, Os,
Pim, Ebook, Freeware, Shareware, Price, Rating, Downloaded,
Screenshot, Filesize from software"
format="<tr><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td></tr>">
</table>
</BODY>
</HTML>
In the ASP page which doesn't:
[code:1:1c7c8e4459]<HTML>
<HEAD>
</HEAD>
<BODY>
<%
Dim objConn, objDriver
Set objConn =
Server.CreateObject("ADODB.Connection")
objDriver="Driver=MySQL ODBC 3.51
Driver;Server=localhost;Port=3306;Database=freeppc;UID=root;"
objConn.Open objDriver
If objConn.State = 0 Then
Response.Write "> Failed to connection to Database FreePPC
over ADODB..."
Response.Write "> Quiting on failure"
Response.Quit
End If
strSQL = "SELECT * FROM software"
Set objRS = Server.CreateObject ("ADODB.Recordset")
objRS.Open strSQL, objConn
Response.Write Name
%>
</BODY>
</HTML>[/code:1:1c7c8e4459]
The same code in the ASP page works on my Intranet sites using IIS.
What am I doing wrong?
Any help would be greatly appreciated.
-------------------------------------------------------
To unsubscribe please go to http://www.sambar.ch/list/
