WAP Programming
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsProgramming Languages - MoreWAP Programming

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now!
  #1  
Old September 23rd, 2004, 04:31 PM
cazino cazino is offline
Permanently Banned
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Sep 2004
Posts: 17 cazino Negative: is most likely a SPAMMER and a traitor to the cause. 
Time spent in forums: 42 m 43 sec
Warnings Level: 10
Number of bans: 1
Reputation Power: 0
Using asp to connect to remote mysql database and display on wap device...help

Hi, I am trying to display dynamic wap content on a mobile by using Asp and my sql database. THE PROBLEM IS THE DATABASE IS NOT ON THE SAME SERVER WHERE THE SCRIPT EXECUTES. I keep getting this error Class not defined ADODB HERE IS THE CODE:

<% @Language="VBScript" %>
<% response.contenttype="text/vnd.wap.wml" %>
<% Set conn = New ADODB.Connection
conn.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=ftp.members.lycos.co.uk; DATABASE=mydatabase_uk_db; UID=me; PWD=; OPTION=3"
conn.Open
SQL = "SELECT name FROM memtest"
set SelectRS = MyConn.Execute(SQL)
%>
<?xml version="1.0"?>
<!DOCTYPE wml PUBLIC "-//WAPFORUM//DTD WML 1.2//EN"
"http://www.wapforum.org/DTD/wml12.dtd"><wml><card id="top" title="Employees"> <p>
<%
'loop through results
while not selectRS.EOF
response.write selectRS("message") & "<br/>"

'move to the next record
selectRS.MoveNext
wend

'close up connection
selectRS.close
set selectRS = nothing
%>
</p>
</card>
</wml>

ANY HELP ON THIS WOULD BE VERY MUCH APPRECIATED, IM A PHP PROGRAMMER THIS IS MY FIRST TIME USING ASP AND I DONT UNDERSTAND THE ABOVE ERROR. THANKS IN ADVANCE!!

Reply With Quote
Reply

Viewing: Dev Shed ForumsProgramming Languages - MoreWAP Programming > Using asp to connect to remote mysql database and display on wap device...help


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 6 hosted by Hostway