New topic: Desktop App access to Database on Web
<http://forums.realsoftware.com/viewtopic.php?t=44828> Page 1 of 1 [ 1 post ] Previous topic | Next topic Author Message mpastor Post subject: Desktop App access to Database on WebPosted: Wed Jul 25, 2012 7:09 am Joined: Sat Oct 18, 2008 4:58 pm Posts: 96 I have created a web app that uses and creates REALSQLdatabases and stores them in a user directory on the server which I am hosting the web app from. I would like to create a desktop app that can connect to those same databases that are created by the web app. Do I need to leverage REALSQLServer? If so, where can I find that (if it still exists - I may have missed the news). Do I need to leverage some server plug-in? Or should I be able to connect to the database with... Dim db As New REALSQLDatabase db.Host = "12.34.567.890/userdirectory/" db.DatabaseName = "userdata.db" db.UserName = "username" db.Password = "userpassword" if db.Connect Then Dim rs As RecordSet = db.SQLSelect("SELECT * FROM Items") Dim s As String s = rs.Field("Description").StringValue End For some reason - this doesn't work. rs returns a nil record set, and when I explore the debugger it seems to indicate that the table "items" does not exist - even though I know it does. What are the obvious faux pas here? Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 1 post ] -- Over 1500 classes with 29000 functions in one REALbasic plug-in collection. The Monkeybread Software Realbasic Plugin v9.3. http://www.monkeybreadsoftware.de/realbasic/plugins.shtml [email protected]
