Re: SQL statements

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 42616
interpreted = N
texte = For everyone using macODBC on mac OS X 10.1.x, here are the setups for setting up SQL support in webcatalog.BTW: macODBC has a few quirks with it's gui manager, such as it requires you log in as root to make changes, but it works well if you want something quick and easy. It supports mySQL and postgre out of the box, though the drivers are not the newest it is possible to update them or install other drivers since this is just a gui wrapped around unixODBC.Please note: these were kindly provided to me by Simon Cotsworth, who is a member of this list.After installing macODBC,>> You just need to recompile one of the files for WebCatalog: >> >> cd /usr/lib >> sudo gcc -bundle -undefined error -o libodbc.so libodbc.dylib.2.1.0One minor change here, unless you have gcc installed:sudo cc -bundle -undefined error -o libodbc.so libodbc.dylib.2.1.0>> This file (libodbc.so) is the one that you have to set in the >> WebCatalog >> preferences, you will need to use a text editor (BBEdit NOT TextEdit) >> to do >> this as there is no setting in the WebCatalog admin pages. Just look >> for the >> line MSQLLibraryPath and enter /usr/lib/libodbc.soYour milage may vary, but so far this has worked perfectly.I would be interested in knowing what is needed to get the built in ODBC support in OS X 10.2 to work with webcat, I suspect it's very similar just haven't had a chance to test it out.Thanks,Jason Tyler On Friday, August 16, 2002, at 01:25 PM, Ben Swihart wrote:> Sure, send me (us) the steps! ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: SQL statements (Jason Tyler 2002)
  2. Re: SQL statements (Ben Swihart 2002)
  3. Re: SQL statements (Bjørn Are Solstad 2002)
  4. Re: SQL statements (John Peacock 2002)
  5. Re: SQL statements (Jason Tyler 2002)
  6. Re: SQL statements (Clint Davis 2002)
  7. Re: SQL statements (dale's stuff 2002)
  8. Re: SQL statements (Jason Tyler 2002)
  9. Re: SQL statements (John Peacock 2002)
  10. Re: SQL statements (dale's stuff 2002)
  11. Re: SQL statements (Pedro Rivera 2002)
  12. Re: SQL statements (Jesse Williams-Proudman 2002)
  13. Re: SQL statements (Ben Swihart 2002)
  14. Re: SQL statements (Pedro Rivera 2002)
  15. SQL statements (Ben Swihart 2002)
For everyone using macODBC on mac OS X 10.1.x, here are the setups for setting up SQL support in webcatalog.BTW: macODBC has a few quirks with it's gui manager, such as it requires you log in as root to make changes, but it works well if you want something quick and easy. It supports mySQL and postgre out of the box, though the drivers are not the newest it is possible to update them or install other drivers since this is just a gui wrapped around unixODBC.Please note: these were kindly provided to me by Simon Cotsworth, who is a member of this list.After installing macODBC,>> You just need to recompile one of the files for WebCatalog: >> >> cd /usr/lib >> sudo gcc -bundle -undefined error -o libODBC.so libODBC.dylib.2.1.0One minor change here, unless you have gcc installed:sudo cc -bundle -undefined error -o libODBC.so libODBC.dylib.2.1.0>> This file (libODBC.so) is the one that you have to set in the >> WebCatalog >> preferences, you will need to use a text editor (BBEdit NOT TextEdit) >> to do >> this as there is no setting in the WebCatalog admin pages. Just look >> for the >> line MSQLLibraryPath and enter /usr/lib/libODBC.soYour milage may vary, but so far this has worked perfectly.I would be interested in knowing what is needed to get the built in ODBC support in OS X 10.2 to work with webcat, I suspect it's very similar just haven't had a chance to test it out.Thanks,Jason Tyler On Friday, August 16, 2002, at 01:25 PM, Ben Swihart wrote:> Sure, send me (us) the steps! ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Jason Tyler

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

database size? (1997) WebCat (or other) Indexing (1999) Running 2 two WebCatalog.acgi's (1996) webcat NT (1998) Separate SSL Server (1997) Emailer (1998) Version 4? (2000) turning every 5th line red (1999) Emailer (WebCat2) (1997) Linux uninstall / reinstall (2003) hmmm (2006) Quit revisited (1997) [random] only for 1-100??? (1997) New Command prefs ... (1997) off topic