New topic: SQLExecute on ODBC
<http://forums.realsoftware.com/viewtopic.php?t=47252> Page 1 of 1 [ 1 post ] Previous topic | Next topic Author Message Dralion Post subject: SQLExecute on ODBCPosted: Sun Mar 10, 2013 10:22 pm Joined: Sat Mar 15, 2008 8:14 am Posts: 149 Location: Montreal, Quebec, Canada I everyone I'v seen many post about ODBC connection In my case...the connection is made and tested OK But im unable to do transaction to the DB My Datasource is "Dinox" and its connected My Database create by MS server studio is "testDB" iv declare testDB in a properties as ODBCDatabase i want to add colum to it by: oDB=New ODBCDatabase oDB.DataSource ="dinox" oDB.UserName = "Admin" oDB.Password = "sqlz" oDB.Timeout = 5 if oDB.Connect then MsgBox "Connectez a "+oDB.DataSource testDB.SQLExecute("create table Products (Name varchar)") else MsgBox "Failed to connect to " + EndOfLine + oDB.ErrorMessage oDB = nil end if testDB.SQLExecute("create table Products (Name varchar)") return NilExecption iv try to make hierarchy by dinox.testDB.SQLExecute("create table Products (Name varchar)") doesn't work either..so i need help thanks _________________ -------------------- RB 2011r4 on win7 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]
