Robert, which JDBC driver set works the best? - s
On Jan 26, 2011, at 2:55 PM, Robert Shubert wrote: > Steve, > > > > I have tested Witango 6 on OS X against MySQL with both JDBC and ODBC. > > > > JDBC works fine and I would recommend it slightly above ODBC on OS X. > > > > For ODBC, you need to download and install the MySQL ODBC 5.1 driver for OS X > 10.6 32-bit (not the 64-bit one since iODBC on OS X runs in 32-bit mode) > > > > You may also need an ODBC administrative tool. The MySQL installer may > install one, I can’t be sure, because I already had 2 others. Apple has one, > but I couldn’t get that one to work properly. Ultimately, I used the OpenLink > ODBC Administrator to setup the DSN and Witango 6 was happy with that. > > > > Incidentally I have tested Witango 6 against the current open link drivers > (for MS SQL) and that worked well. > > > > By default Witango Server 6 is setup to access both JDBC and ODBC. > > > > Robert > > > > PS. I have not done any testing with PostgreSQL yet, and we don’t support > that DBMS in the Studio. I will get to this as soon as I can. > > > > > > From: Steve Smith [mailto:[email protected]] > Sent: Wednesday, January 26, 2011 12:01 PM > To: [email protected] > Subject: Re: Witango-Talk: I Screwed Up > > > > Found the problem. As good as Apple's user interface for OS X Server is, > sometimes you see a slightly different picture when you open up terminal and > run ls -la. Once I remembered what the letters meant, I was able to figure > out what needed to be fixed. > > > > Now it is on to setting up a data source on this box. My experience was > always with ODBC, but my sense is that JDBC is the way to go in today's > world. Planning on continuing to use MySQL, or possibly look at PostgreSQL. > For now I'll be porting over my existing system which runs under MySQL. > > > > Is JDBC the way to go? > > > > Steve Smith > > > > Oakbridge Information Solutions > > Oakville Office: (416) 628-0793 > > Cambridge Office: (519) 489-0142 > > Email: [email protected] > > Web: www.oakbridge.ca > > > > Certified DayLite Master Partner > > Certified DayLite Trainer > > Billings Consultant > > FileMaker Business Alliance Member > > MoneyWorks Consultant > > LightSpeed Authorized Reseller > > > > On 2011-01-25, at 8:37 PM, Robert Shubert wrote: > > > > > Steve, > > > > Simply put, the permissions on the folder where you site files reside doesn’t > have read permissions. It should have Everyone “Read only” on it (and > possibly folders leading up to it). Just Get Info on each and set them > accordingly. > > > > Creating the share may have automatically set tighter permissions, or perhaps > changed the group permission that was originally allowing Apache to access > the files. > > > > Robert > > > > From: Steve Smith [mailto:[email protected]] > Sent: Tuesday, January 25, 2011 7:25 PM > To: [email protected] > Subject: Witango-Talk: I Screwed Up > > > > With Robert's help, I was able to get Witango v6 up and running on my Mac > mini OS X Server... > > > > for a few minutes. Then I started to tinker and tried a couple of things in > an attempt to create a Share Point that I could access from the machine that > is running Witango Studio. > > > > And I screwed things up. Now whenever I attempt to access any document on the > webserver I get this: > > > > Access forbidden! > > You don't have permission to access the requested directory. There is either > no index document or the directory is read-protected. > > If you think this is a server error, please contact the webmaster. > > Error 403 > > 10.0.1.10 > Tue Jan 25 19:13:10 2011 > Apache/2.2.15 (Unix) > > And while I thought that I had Time Machine turned on, I must have turned it > off so I can't even restore. > > In System Admin's logs for the webserver, I see this: > > Tue Jan 25 19:13:10 2011 error http://client 10.0.1.16 (13)Permission denied: > access to / denied > > Is this an easy fix and if so can someone help me out? > > > > Steve Smith > > > > Oakbridge Information Solutions > > Oakville Office: (416) 628-0793 > > Cambridge Office: (519) 489-0142 > > Email: [email protected] > > Web: www.oakbridge.ca > > > > Certified DayLite Master Partner > > Certified DayLite Trainer > > Billings Consultant > > FileMaker Business Alliance Member > > MoneyWorks Consultant > > LightSpeed Authorized Reseller > > > > > > To unsubscribe from this list, please send an email to [email protected] > with "unsubscribe witango-talk" in the body. > > > > To unsubscribe from this list, please send an email to [email protected] > with "unsubscribe witango-talk" in the body. > > > > > > To unsubscribe from this list, please send an email to [email protected] > with "unsubscribe witango-talk" in the body. > > > To unsubscribe from this list, please send an email to [email protected] > with "unsubscribe witango-talk" in the body. ---------------------------------------- To unsubscribe from this list, please send an email to [email protected] with "unsubscribe witango-talk" in the body.
