|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
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
|
|||
|
|||
|
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!! |
![]() |
| Viewing: Dev Shed Forums > Programming Languages - More > WAP Programming > Using asp to connect to remote mysql database and display on wap device...help |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|