|
| |
| | ODBC and Pragma |
 | | ODBC is based on Structured Query Language (SQL) as a standard for accessing data. | | | The ODBC Administrator is a Microsoft utility that is part of Windows NT 4.0 and Windows 98, but not of Windows 95. | | | The Microsoft ODBC Administrator program can be freely distributed. |
|
http://www.xmission.com/~sysdes/logical/t_odbc.htm
(1243 words)
|
|
| |
| | ODBC |
| | 2000 odbc window with odbc xml, odbc query tool jBLOB library is a set of easy to use ColdFusion CFX Java classes used to read and write binary information (BLOB fileds) to and from database features. | | | odbc driver download jBLOB library is a set of easy to use ColdFusion CFX Java classes used to read and write binary information (BLOB fileds) to and from database to ms sql server 2000 MSSQL, Oracle and ODBC versions are available to ms sql server 2000 db2 odbc driver depends on oracle discoverer. | | | access driver microsoft microsoft must odbc operation query updateable use - driver expired microsoft odbc server sql time is focused on btrieve odbc driver and details of call failed odbc is required by perl odbc. |
|
http://web4w3.com/jBLOB/ODBC.htm
(519 words)
|
|
| |
| | mxODBC - The Python ODBC Interface |
| | Input and output conversion is dependent on the data format the ODBC driver expects or returns for a given column. | | | On output, string data is always fetched as Unicode data from the ODBC driver and returned using Python Unicode objects. | | | If the ODBC driver/manager doesn't support processing binary data using strings, wrap the data object using Python buffers (via the buffer() constructor) to have mxODBC use a binary SQL type for interfacing to the driver/manager. |
|
http://www.egenix.com/files/python/mxODBC.html
(14066 words)
|
|
| |
| | ODBC--Open Database Connectivity Overview |
| | The ODBC Driver resides between the ODBC Client and the DBMS; however, it is loaded on the front-end computer. | | | ODBC alleviates the need for independent software vendors and corporate developers to learn multiple application programming interfaces. | | | Open Database Connectivity (ODBC) is Microsoft's strategic interface for accessing data in a heterogeneous environment of relational and non- relational database management systems. |
|
http://support.microsoft.com/support/kb/articles/Q110/0/93.asp
(993 words)
|
|
| |
| | Oracle FAQ: Oracle ODBC Connectivity |
| | Most ODBC to Oracle implementations require the ODBC software stack to run on top of the Oracle Net8 software stack. | | | The Microsoft ODBC Administrator (My Computer/ Control Panel/ ODBC) provides a simple ODBC call trace that logs ODBC calls to a file. | | | Specialized ODBC trace programs, such as Microsoft's ODBC Spy (included in the ODBC SDK 2.0), ODBC Inspector and ODBC Agent can be used to capture detailed ODBC call information and the return code for each call. |
|
http://www.orafaq.com/faqodbc.htm
(1187 words)
|
|
| |
| | ODBC |
| | If you have installed an ODBC system with x number of ODBC users, and the customer changes their mind and wants to return some of the licences, there is a way of checking up on them. | | | The problem in pinpointing ODBC problems is that the error messages reported by kisam32.dll are quite general. | | | This posses a problem if you expect to import 1500 individual fields/columns from a KISAM file into an Access database, with a bit of a re-think required on your/their part, because even if you split up the queries the resulting table will still be too big for Access to handle. |
|
http://www.kcml.com/toolset/FAQs/odbc.html
(1243 words)
|
|
| |
| | ODBC |
| | The FileMaker Pro ODBC driver must be installed on the computer generating the SQL query. | | | ODBC Driver A DLL (Windows) or shared library (Mac OS) that sends a SQL query to access data stored in a database and delivers data to the client application | | | All applications that support ODBC recognize a common subset of Structured Query Language (SQL) statements. |
|
http://www.firebridge.com.au/odbc.htm
(1384 words)
|
|
| |
| | Open Database Connectivity - Wikipedia, the free encyclopedia |
| | Most current DBMSs support ODBC which means that computer programs that rely on ODBC can connect to several different brands of DBMSs using the same basic code. | | | ODBC allows programs to use SQL requests that will access databases without having to know the proprietary interfaces to the databases. | | | This API is independent of any one programming language, database system or operating system. |
|
http://en.wikipedia.org/wiki/ODBC
(625 words)
|
|
| |
| | Minisoft ODBC/32 |
| | To use HP's "free" ODBC driver, users must setup and define DBE's (Data Base Environment) before any data can actually be accessed. | | | ODBC now supporting Eloquence, AIX, OSX, UNIX, LINUX, and Oracle Open Gateway for Heterogeneous Queries | | | Minisoft's ODBC supports advanced features such as linking to multiple databases, KSAM, and MPE files. |
|
http://www.minisoft.com/pages/middleware/odbc32/odbc32.html
(289 words)
|
|
| |
| | SQLSummit.com: ODBC Drivers, Servers and Vendors |
| | ODBC is available on computers running Windows XP and other Windows operating systems, Linux, Macintosh operating systems and various flavors of Unix. | | | Because ODBC enjoys widespread support, there are hundreds of ODBC drivers for databases, ISAM files and other data sources. | | | The alignment of ODBC with the ISO standard SQL Call Level Interface lead to widespread support for ODBC as a solution for querying SQL databases. |
|
http://www.sqlsummit.com/ODBCVend.htm
(1091 words)
|
|
| |
| | Signature Systems, Inc. -- Comet2000 ODBC Client Gateway |
| | The purpose of this layer is to translate the application's data queries into commands that the DBMS understands. | | | This driver program is activated when an Internet Basic program opens an ODBC gateway (a type 5 gateway in the system configuration). | | | To interact with an ODBC-compatible database, your program only need to include ODBC function calls and statements in Structured Query Language (SQL). |
|
http://www.signature.net/signature/products/odbc.htm
(315 words)
|
|
| |
| | MySQL AB :: MySQL® Connector/ODBC |
| | The production-ready version of Connector/ODBC is compliant with the ODBC 2.50 specification, Level 0 (with some Level 1 and 2 features). | | | The stable version, is compliant with the ODBC 3.51 specification, Level 1 (complete Core API and Level 2 features). | | | API on all Microsoft Windows and most Unix platforms, including through such applications and programming environments such as Microsoft Access, Microsoft Excel, and Borland Delphi. |
|
http://www.mysql.com/products/myodbc
(216 words)
|
|
| |
| | August Software |
| | ODBC.NET works with August Software's ODBC Router to make all of the SQL data sources found in the ODBC control panel of a Windows Server available for use by REALbasic. | | | August Software today delivered ODBC.NET, a free ODBC plug-in for the popular REALbasic cross-platform development environment by REAL Software. | | | AUGSOFT and ODBC Router are trademarks of August Software. |
|
http://www.augsoft.com/corp/pr061302.shtml
(272 words)
|
|
| |
| | ODBC SDK for ODBC driver development and OLE DB SDK for OLE DB provider development and JDBC SDK for JDBC driver ... |
| | ODBC SDK for ODBC driver development and OLE DB SDK for OLE DB provider development and JDBC SDK for JDBC driver development the Easy Way from OpenAccess Software, Inc. | | | OpenAccess ODBC SDK, OLE DB SDK,.NET Data Provider SDK, and JDBC SDK are your cost-effective, risk-free solutions to enable ODBC, OLE DB, ADO.NET, and Java (JDBC) compliant access to your Proprietary, Legacy, Object or RDBMS Databases or to your business logic. | | | OpenRDA ODBC Driver for UNIX - From UNIX and OpenVMS platforms you can access ODBC compliant databases on MS Windows. |
|
http://www.odbcsdk.com
(841 words)
|
|
| |
| | Easysoft ODBC-ODBC Bridge Product Description - Easysoft.com |
| | For example, your ODBC application needs to run on Linux but it needs to use a Microsoft ODBC driver only available on Windows. | | | Contains ODBC optimisations for fetching rows from applications not using bound columns. | | | Leads you through the process of creating your first data source and shows you your remote data, during installation on Unix. |
|
http://www.easysoft.com/products/data_access/odbc_odbc_bridge
(1778 words)
|
|
| |
| | [No title] |
| | The DB API only exposes limited ODBC functionality (that isn't its purpose), but it is simple to use and comes free with win32. | | | First, figure out which ODBC functions you need to call, then add the wrappers to odbc.py, using the existing functions as guides. | | | In particular, you can get at ODBC by directly calling functions in odbc32.dll, and Sam has provided a wrapper module, odbc.py, to do just that. |
|
http://www.python.org/windows/OdbcHints.html
(663 words)
|
|
| |
| | ODBC Performance |
| | "Understanding ODBC and Multidatabase APIs" (DBMS, March 1994) included informal benchmarks that showed there were significant differences in the execution time of several applications that were executing the same query against the same tables using the same ODBC driver. | | | TimesTen Performance Software is raising the bar on SQL database performance with its in-memory database that provide an ODBC interface. | | | Clearly execution time in this instance was a function of the application, not of the query or ODBC. |
|
http://ourworld.compuserve.com/homepages/Ken_North/ODBCPERF.HTM
(500 words)
|
|
| |
| | High-Performance Data Access Drivers for ODBC, JDBC, ADO.NET, and OLE DB |
| | ODBC Drivers are available for Windows, Linux, Mac OS X, and all UNIX flavors. | | | JDBC Drivers are 100% pure and run on any platform hosting a Java Virtual Machine (runtime environment). | | | Irrespective of you seek to exploit UDA based middleware, it will always ultimately provide better value to your enterprise than any proprietary (aka Native) alternative. |
|
http://uda.openlinksw.com/odbc
(415 words)
|
|
| |
| | PHP: odbc_exec - Manual |
| | Another way to solve the problem with single quotes (at least in my environment (php 4.3.6, ODBC to MS Access db)), is to edit the php.ini file and set magic_quotes_gpc = On and magic_quotes_sybase = On. | | | MS Access through ODBC doesn't just not like quotes (escape with '' - two single quotes), it also really hates newlines - chr(10)s - in LONGCHAR fields, and maybe in other BINARY based fields as well. | | | If a single quote exists within the field specified by your WHERE statement, ODBC fails because of a parsing error. |
|
http://us3.php.net/odbc_exec
(1432 words)
|
|
| |
| | Win32::ODBC - A Tutorial |
| | In it, Dave married the ODBC toolkit with Perl, finally giving me (and countless others) access to databases from Perl on Win32 machines. | | | With ODBC, you simply write to the ODBC API and let the ODBC Manager and Driver take care of the database language specifics. | | | I will also assume that the web server, scripts, ODBC data sources, and everything else are already set up and working. |
|
http://www.northbound-train.com/perl/article/Article.html
(2557 words)
|
|
| |
| | Unix and OpenVMS ODBC Driver from OpenAccess Software, Inc. |
| | The required header files and library files are included to allow you to develop your own applications. | | | OpenAccess Software's solution is a client/server solution that uses a client component and a server component to allow connectivity across many platforms without the need for vendor supplied libraries. | | | Unix and OpenVMS ODBC Driver from OpenAccess Software, Inc. |
|
http://www.odbcsdk.com/products/openrda/unix_features.asp
(456 words)
|
|
| |
| | Flicks Software's FAQ |
| | however I am getting 31, ODBC error with statement, error number is: 3704 The operation requested by the application is not allowed if the object is closed. | | | Stored procedure example for use with ODBC - Advanced. |
|
http://www.flicks.com/fbeta/q_and_a.htm
(15318 words)
|
|
| |
| | ODBC Broker, C++ Library for database applications |
| | In application development using ODBC, developers usually define C/C++ variables that match what’s in the database table (static binding). | | | The approach assumes the database tables are defined before the corresponding database classes. | | | It is capable of handling dynamic query, batch SQL commands, database caching, and runtime binding. |
|
http://www.sqldata.com/broker.htm
(394 words)
|
|
| |
| | PHP Help: Microsoft Access Database ODBC and PHP |
| | The queries are nearly the same with the exception of a few less MySQL query functions. | | | Lets begin preparing our databases and configuring our ODBC sources. | | | Remarks: Updated for new website, fixed up code. |
|
http://www.phpfreaks.com/tutorials/61/0.php
(344 words)
|
|
| |
| | ODBC Driver, Unix ODBC, Linux ODBC, Oracle ODBC Driver, DB2 ODBC: Products: Home |
| | This independent research from database expert Ken North proves that programs written in the ODBC API using wire protocol drivers from DataDirect Technologies yield even better performance than programs written in the native language of database vendors. | | | That means one DB2 ODBC driver for Windows, Unix, OS/390, and iSeries (AS/400). | | | The DataDirect ODBC driver does not require database client software such as Oracle Net. |
|
http://www.datadirect.com/products/odbc/index.ssp
(595 words)
|
|
| |
| | search.cpan.org: DBD::ODBC - ODBC Driver for DBI |
| | Unfortunately, the Access ODBC driver that I have does not allow one to specify the UNC path, only the X:\ notation. | | | 2) ODBC Driver Manager - the piece of software which interacts with the drivers for the application. | | | It's probably not as useful now, but it allowed get_info and get_type_info to return correct/updated information that ODBC 2.x didn't permit/provide. |
|
http://search.cpan.org/~jurl/DBD-ODBC-1.09/ODBC.pm
(2448 words)
|
|
| |
| | PHP: ODBC Functions (Unified) - Manual |
| | I searched for the solution of why odbc connection of a network remote drive under Windows + Apache 2.0.X, cannot give the query, but seems no one provides the solution. | | | The windows version of PHP has built in support for this extension. | | | In my mind this should also work with MS-SQL-Server and with Sybase - via ODBC and direct (mssql_.../sybase_...). |
|
http://us2.php.net/manual/en/ref.uodbc.php
(1263 words)
|
|
| |
| | [No title] |
| | The Bridge is a joint development of Merant and Java Software. | | | See your ODBC driver vendor for information on installing and configuring ODBC. | | | See your database vendor for client installation and configuration information. |
|
http://java.sun.com/j2se/1.3/docs/guide/jdbc/getstart/bridge.doc.html
(751 words)
|
|
| |
| | Business Intelligence for Progress |
| | Sequelink is a real Client/Server application, where we need only Sequelink Client software on the Client PC's, and a complete self-servicing Server process is running on a Server machine. | | | The SQL89 engine will not be developed any further, and Progress wants to use the SQL92 engine for other reasons than BusinessIntelligence, too: we want to open up our database for all kinds of SQL92 compatible applications as well. | | | This is the main reason why Sequelink and OpenLink still offer extra functionality: they use the SQL89 engine (ESQL/C), and thus can run queries over multiple databases, just like the Progress 4GL can do. |
|
http://home.hccnet.nl/martins/odbc/odbc.htm
(864 words)
|
|
| |
| | August Software |
| | Available now from www.ODBCRouter.com, ODBC Router systems enable applications on Mac OS X, Classic Mac OS, Darwin, Windows and Linux to utilize virtually any SQL data source by way of a standard Windows NT/2K/Xp system and standard Windows ODBC drivers. | | | AUGSOFT and ODBC Router are trademarks of August Software. | | | In this sense, XML and ODBC are analogous to e-mail and instant messaging”, said the company. |
|
http://www.augsoft.com/corp/pr071202.shtml
(184 words)
|
|
| |
| | ODBC - Mono |
| | Before filing a bug, make sure your native provider works with other languages (C, perl, etc). | | | Read these web pages about UNIX, ODBC, and IBM DB2 | | | For UNIX, you will need unixODBC or iODBC installed |
|
http://www.mono-project.com/contributing/odbc.html
(693 words)
|
|
| |
| | MacDevCenter.com: Open Database Connectivity in Jaguar |
| | The ODBC driver manager that comes with Jaguar is actually OpenLink Software's iODBC product (click here for more information). | | | Setting up the odbc.ini file correctly is the key to making ODBC work properly. | | | ODBC allows programs to connect to databases from different vendors using the same set of connectivity protocols. |
|
http://www.macdevcenter.com/pub/a/mac/2003/06/20/odbc.html
(792 words)
|
|
| |
| | ODBC Driver at DataDirect: JDBC Driver, Data Provider, XQuery, ODBC Download |
| | DataDirect XQuery - the first embeddable component for XQuery that implements the XQuery API for Java™ (XQJ), enables Java developers to query XML, relational databases or a combination of the two, integrating the results for XML-based data exchange, XML-driven Web sites, and other applications that require or leverage the power of XML. | | | - Fastest, most comprehensive suite of ODBC drivers for all major databases and platforms, including UNIX and Linux. | | | DataDirect Technologies is the vendor of choice for superior database drivers, whether you're looking for the most reliable ODBC driver, JDBC driver, or ADO.NET data provider. |
|
http://www.datadirect.com/index.ssp
(476 words)
|
|
| |
| | PHP Database ODBC |
| | If you are running Internet Information Server (IIS) on your own computer, the instructions above will work, but if your web site is located on a remote server, you have to have physical access to that server, or ask your web host to to set up a DSN for you to use. | | | The code line below returns the value of the first field from the record: | | | ODBC is an Application Programming Interface (API) that allows you to connect to a data source (e.g. |
|
http://www.w3schools.com/php/php_db_odbc.asp
(666 words)
|
|
| |
| | Technorati Tag: odbc |
| | On one of my customer projects, I needed to access an Oracle 9 database to transfer information from a Notes database to the SQL database. | | | Continuing research for porting my blog over to WordPress, I started learning how to interact with a MySQL database with C#. | | | Python odbc problem Submitted by Peter on Tue, 21/06/2005 - 14:22. |
|
http://technorati.com/tag/odbc
(361 words)
|
|
| |
| | MySQL 5.0 Reference Manual :: 24.1.1.1 What is ODBC? |
| | For more information about ODBC, refer to http://www.microsoft.com/data/. | | | MySQL 5.0 Reference Manual :: 24 MySQL Connectors :: 24.1 MySQL Connector/ODBC :: 24.1.1 Introduction to MyODBC :: 24.1.1.1 What is ODBC? | | | ODBC usually is used when database independence or simultaneous access to different data sources is required. |
|
http://dev.mysql.com/doc/refman/5.0/en/odbc.html
(178 words)
|
|
| |
| | ODBC ROUTER™ Database Networking |
| | In this way, ODBC Router™ eliminates countless hours of proprietary database-client networking configuration and ODBC driver setup work throughout your network, replacing all of those complex and expensive components with a single self-contained and free "overdriver". | | | ODBC Router™ is a Windows Service that connects all of your network's Mac, Linux and Windows systems with all of your mainframe, minicomputer, Unix and PC databases. | | | ODBC Router™ technology operates with binary efficiency, eliminating data conversions that saturate shared server resources in some competitive products. |
|
http://odbcrouter.com/overview.shtml
(275 words)
|
|
| |
| | EasyTable ODBC Driver |
| | The following environments were successfully tested with the EasyTable ODBC Driver: | | | To learn about EasyTable database format read EasyTable Specification. | | | The EasyTable ODBC Driver is easy-to-use: just run setup.exe to install/uninstall the dll in your system. |
|
http://www.aidaim.com/products/eodbc/eodbc_spec.php
(654 words)
|
|
| |
| | WeberDev.com - Code Archive -> Databases -> ODBC |
| | Recordset Class like ADO Recordset (plus DataBase Splitting feature) using ODBC functions | | | WeberContent : : System Services : : Uptime Monitor : : Web Development Jobs : : Beginner Guides : : web development forums : : PHP Code Examples : : PHP Articles : : PHP Classes : : PHP Tool bar : : Manuals : : Site Map : : Project Matching : : | | | WeberDev.com - Code Archive -> Databases -> ODBC |
|
http://www.weberdev.com/search.php3/category/ODBC/Databases/1
(254 words)
|
|
| |
| | The Open Database Connectivity Standard (ODBC) |
| | For several years, a working party called the SQL-Access Group (SAG), consisting of interested hardware and software vendors, worked towards defining a common database access method to simplify Client-Server computing. | | | Microsoft has taken a core set of SAG's output and developed a call-level interface called the Open Database Connectivity (ODBC) Application Programming Interface. | | | The Open Database Connectivity (ODBC) interface allows applications to access data from database management systems (DBMS). |
|
http://www.openlink.co.uk/info/docs/odbcwhp/open.htm
(282 words)
|
|
| |
| | ODBC Module |
| | Although ODBC has theoretically been ported to other operating systems, and people theoretically have had it working on these platforms, no binaries or support is available for them. | | | import dbi, odbc try: s = odbc.odbc('DSN/UID/PASSWORD') cur = s.cursor() cur.execute('select * from discounts') print cur.description for tup in cur.description: print tup[0], print while 1: rec = cur.fetchmany(10) if not rec: break print rec except NameError,e: print 'error ', e, 'undefined' | | | [Note however, Bill Tutt seems to think that this problem implies a problem with the specific ODBC driver, rather than with the ODBC implementation of Python. |
|
http://www.python.org/windows/win32/odbc.html
(299 words)
|
|
| |
| | PHP ODBC |
| | I hava also written a number of helper functions for form building using DB2 on CS1. | | | Connecting and retrieving results from a database using the ODBC interface requires the following steps: | | | PHP supports a large number of databases and simplifies access via a unified ODBC interface. |
|
http://cs1.mcm.edu/tutorial/htmlguid/php/php-odbc.phtml
(134 words)
|
|
| |
| | ODBC |
| | The AR System 4.0 ODBC driver is the file: | | | · Data may be available through ODBC that is not available through SQL (it depends on the application and its database). | | | It allows them to integrate with the AR System through standard ODBC. |
|
http://www.windthrope.com/odbc.htm
(201 words)
|
|
| |
| | ODBC in Ruby on Rails |
| | http://www.unixodbc.org/ – “The unixODBC Project goals are to develop and promote unixODBC to be the definitive standard for ODBC on non MS Windows platforms. | | | http://www.iodbc.org – “iODBC is the acronym for Independent Open Data-Base Connectivity, an Open Source platform independent implementation of both the ODBC and X/Open specifications.” |
|
http://wiki.rubyonrails.com/rails/show/ODBC
(83 words)
|
|
| |
| | The freeodbc++ project |
| | In general, the library should run on anything that has a reasonable c++ environment and an ODBC driver manager version 2.5 or higher. | | | Any environment with a reasonable compiler, standard c++ library and ODBC Driver Manager should do. | | | To see what is implemented and what is to come, take a look at the development roadmap. |
|
http://libodbcxx.sourceforge.net
(209 words)
|
|
| |
| | Open Directory - Computers: Programming: Databases: ODBC |
| | It is based on the Call-Level Interface (CLI) specifications from X/Open and ISO/IEC for database APIs and uses Structured Query Language (SQL) as its database access language. | | | Microsoft ODBC - Open Database Connectivity (ODBC) is an application programming interface (API) for database access. | | | PC - ODBC - AS/400 FAQ - Frequently asked questions with answers for programmers working with PC connected to AS/400 machine through ODBC. |
|
http://dmoz.org/Computers/Programming/Databases/ODBC
(122 words)
|
|
| |
| | Middleware - Interfaces to Databases |
| | freeodbc++ - an object oriented wrapper for ODBC | | | is a package of libraries which provide applications on Linux with access to ODBC data sources on remote machines. | | | Allows embedding C in your application code, uses ODBC to connect to databases, and provides presentation layers using |
|
http://cbbrowne.com/info/middleware.html
(643 words)
|
|
|
