[sambar] ASP and MySQL

Tue, 30 Dec 2003 11:18:21 -0800

I didn't think ASP was supported on Sambar. See:
 
Mike

>>> [EMAIL PROTECTED] 12/30/03 12:00PM >>>
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/



-------------------------------------------------------
To unsubscribe please go to http://www.sambar.ch/list/

Reply via email to