New topic: ODBC: Problems and irritation
<http://forums.realsoftware.com/viewtopic.php?t=44788> Page 1 of 1 [ 1 post ] Previous topic | Next topic Author Message fkersten Post subject: ODBC: Problems and irritationPosted: Fri Jul 20, 2012 12:08 pm Joined: Fri Jul 20, 2012 11:47 am Posts: 1 Hi there, I'm irritated and don't know what I'm doing wrong. RealStudio Professional v4.3 I linked an ODBC Data Source with "Projekt" - "Hinzufügen" -"Datenbank" - "Select ODBC-Datenbank" The Datasource is shown in the Project-Environment (I called it AMCDB) beneath "Build Automation" When I open it, I see all my tables When I click "Scroll", I would expect to see some data but don't When I specify a select statement like "SELECT * from firma" RealStudie crashes In the code I tried this: dim rs as RecordSet dim sql as String dim y as Integer sql = "SELECT ID, Name, Ort FROM firma" rs = AMCDB.SQLSelect(sql) y = rs.RecordCount MsgBox "Anzahl Datensätze: " +str(y) Result: The messagebox shows a value of -1 The same, if I try to connect to the ODBC-Database using db=New ODBCDatabase db.DataSource="DSN=AMCDB;UID=xxx;PWD=xxx" If db.Connect then .. The link to the ODBC-Database works with Filemaker and I'm absolutely sure, that there is data stored in the database. Can anybody give me an advice? Thanks a lot in advance! Frank 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]
