Re: Witango-Talk: Unable to connect to JDBC or retrieve more than three rows in ODBC

[Mark Weiss]

Rick, ON jdbc, Robert Garcia taught me that there are two places where you need to have settings. 1. is in the user library, preferences, witango 2. is in  harddrive/applications/witangoserver/5.5/configuration/jdbc.ini. The first is from the dev studio. The second you have to configure yourself.  the file on my pb look like this: <?xml version="1.0" encoding="ISO-8859-1" ?> <!DOCTYPE JDBCINI SYSTEM "jdbcini.dtd" > <JDBCINI Version="0x00010000"> <DataSources> <DataSource ID="Northstardb"> <DSN>Northstardb</DSN> <DriverClass>com.mysql.jdbc.Driver</DriverClass> <URL>jdbc:mysql://127.0.0.1:3306/northstardb</URL> <Properties /> </DataSource> </DataSources> </JDBCINI> have a good weekend. I hope this helps. Mark On Nov 3, 2006, at 6:10 PM, Rick Donagrandi wrote: All: I'm on: Mac OS X Server 10.4.8 Tango Server and Dev Studio 5.5 LITE (yes, the console and such tell me the license is valid.) OpenBase 10.0.0.1 and attempting to either retrieve more than three rows through ODBC with Actual Technologies ODBC driver (I can successfully retrieve more than three rows through FileMaker using this driver, so it's not the driver -- and yes, I purchased their license.) OR Connect to the OpenBase database through JDBC.... (I can connect and successfully test in Dev Studio -- but when I deploy and attempt to access through the server, the server thinks the URL to the database is NULL. I even personally edited and added the datasource to WiTango Server's JDBC.ini file.) Any clues to what's going on? Everything else appears to be working; Dev Studio opens the databases and I can create .taf files from the Search builder; Server returns forms and resultsets -- except the resultsets are consistently limited to three rows when there should be over 600 rows.... Thanks, Rick Donagrandi ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf Mark Weiss [EMAIL PROTECTED] http://trustthechildren.blogspot.com ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf