Re: Linux ODBC and the ODBC Bridge
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 35077
interpreted = N
texte = Open DataBase Connectivity is a Microsoft mutated standard for accessingvarious backend database. It was loosely based on a draft internationalstandard called Call Level Interface from the SQL Access Group (circa1992-3*). Microsoft took the paper interface and created a mostly proprietary system which has been replaced (mostly) by ADO and DAO (inturn).Oddly enough, the only platform with lots of support is Windows (NT or95/98). Some Unix ODBC drivers exist, but they seem to be either free(and unsupported) or expensive (and overkill for most uses). Databasevendors other than Micro$oft have native client drivers for popularplatforms, like various Unixes and Linuxes. Those high-handed bast&rds in Redmond, however, see no reason to support any other platform. F%#! 'em, I say (sorry).WebCat can use existing ODBC drivers to communication with backenddatabases, but you are limited to the existance of those drivers. If you are running WebCat under NT, it is not a big deal; Mac and Linux aregenerally stuck with the short stick. If you see no need to access abackend database, stick with WebCat's much faster RAM-based database.Now you knowJohn Peacock* ODBC details based on Programming the Perl DBI Chapter 7. O'ReillyBooks 1-56592-699-2Kim Ingram wrote:> > What the heck does ODBC stand for anyway?> > What's the difference between an ODBC database and a standard tab delimited> text file...like what I've used with WebCat for a couple of years now...> > Should I be converting for WebCatalog sake? Or does it matter? Is there> even a difference?> > > -----Original Message-----> > From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On> > Behalf Of Nicolas Verhaeghe> > Sent: Monday, July 24, 2000 12:42 PM> > To: WebCatalog Talk> > Subject: Linux ODBC and the ODBC Bridge> >> >> > Thanks to the WebDNA support, I found more information about ODBC> > on Linux.> >> > Now my investigations led me to http://www.easysoft.com/ and their product> > Easysoft ODBC-ODBC Bridge> >> > Is it really worth it? I think I might migrate from MS SQL Server to MySQL> > or PostGre, but not before I have investigated all the solutions> > available.> >> > Thanks a lot!> >> >> > -------------------------------------------------------------> > 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/> >> > -------------------------------------------------------------> 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/-------------------------------------------------------------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:
Open DataBase Connectivity is a Microsoft mutated standard for accessingvarious backend database. It was loosely based on a draft internationalstandard called Call Level Interface from the SQL Access Group (circa1992-3*). Microsoft took the paper interface and created a mostly proprietary system which has been replaced (mostly) by ADO and DAO (inturn).Oddly enough, the only platform with lots of support is Windows (NT or95/98). Some Unix ODBC drivers exist, but they seem to be either free(and unsupported) or expensive (and overkill for most uses). Databasevendors other than Micro$oft have native client drivers for popularplatforms, like various Unixes and Linuxes. Those high-handed bast&rds in Redmond, however, see no reason to support any other platform. F%#! 'em, I say (sorry).WebCat can use existing ODBC drivers to communication with backenddatabases, but you are limited to the existance of those drivers. If you are running WebCat under NT, it is not a big deal; Mac and Linux aregenerally stuck with the short stick. If you see no need to access abackend database, stick with WebCat's much faster RAM-based database.Now you knowJohn Peacock* ODBC details based on Programming the Perl DBI Chapter 7. O'ReillyBooks 1-56592-699-2Kim Ingram wrote:> > What the heck does ODBC stand for anyway?> > What's the difference between an ODBC database and a standard tab delimited> text file...like what I've used with WebCat for a couple of years now...> > Should I be converting for WebCatalog sake? Or does it matter? Is there> even a difference?> > > -----Original Message-----> > From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On> > Behalf Of Nicolas Verhaeghe> > Sent: Monday, July 24, 2000 12:42 PM> > To: WebCatalog Talk> > Subject: Linux ODBC and the ODBC Bridge> >> >> > Thanks to the WebDNA support, I found more information about ODBC> > on Linux.> >> > Now my investigations led me to http://www.easysoft.com/ and their product> > Easysoft ODBC-ODBC Bridge> >> > Is it really worth it? I think I might migrate from MS SQL Server to MySQL> > or PostGre, but not before I have investigated all the solutions> > available.> >> > Thanks a lot!> >> >> > -------------------------------------------------------------> > 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/> >> > -------------------------------------------------------------> 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/-------------------------------------------------------------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/
John Peacock
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:
Why is this search finding the right thing?! (2002)
Custom WebCat Prefs ... (1997)
webcat2b12 CGI -- Date comparisons (1997)
Attention all list readers (1997)
RE: Signal Raised (1997)
Emailer setup (1997)
[convertchars] limits (1998)
[showif]/[hideif] question (1997)
WC2f3 (1997)
[WebDNA] AJAX module (2012)
popups, netscape vs explorer (1997)
URGENT - CPU usage OSXS (2001)
[WebDNA] Apache 2 httpd.conf Question (2008)
Last Record not recognized? (1999)
Off-topic: Cheap hosting (but not webdna) ... (2002)
Trouble with carts (2000)
Authorizenet SIM (2002)
WCS Newbie question (1997)
WC2b15 File Corruption (1997)
BUG in [showif] using ^ (contains) (1997)