![]() But with ODBC, they can write code to a single standard and framework. Without a common interface to the databases, the developers would have to create code specific to both Oracle and DB2. Your Web developers must also integrate that database into the intranet site to give the sales staff access to current inventory levels. In another division, you have an IBM AS/400 running IBM’s DB2 that hosts an inventory control database. Your Web application developers need to design an intranet site that lets sales staff view and modify the contact database. For example, assume your company maintains an extensive Oracle database of customer information. ODBC enables applications to query data from hosted databases without requiring that the application support the database management system (DBMS) that is hosting the database. ODBC is a standards-based technology that provides a common interface to multiple types of relational database systems. ODBC stands for Open Database Connectivity. In this Daily Drill Down, I’ll explain what ODBC is all about and how you can put it to work sharing databases with other users and applications. In all of these situations, ODBC is the tool you need to make it happen. Or, maybe you need to pull SQL data into Microsoft Access. Maybe you need to make a database available from the Internet, but you’re not sure how to go about it. For example, let’s say you’ve created a database using Microsoft Access, but you have a non-Microsoft application that needs to pull data from it. You may need to share that database with other users or enable other applications to query the data. Most IT pros maintain at least one database containing information important to the business they support. ![]() Provide a common interface to multiple types of relational database systems with ODBC technology. If so, please let me know.Configure IT Quick: Configure Access and SQL ODBC connections for user database access Of course there may be a (lot) better method. Use lrange to extract the actual stored text. In a rush (as always) I found the easiest solution is to store the memo as a two element list (or as two separate fields), index 0 contains an integer 'size' of the memo and index 1 the memo itself. TclOdbc returns all the data associated with the memo, spurious or otherwise. When using tclodbc to work with Access memo fields, if you insert a record which contain a memo field that contains a large amount of data, you may get a problem rereading it. (Omit this if opening an existing database) # (For opening an existing database, use tk_getOpenFile instead of # Prompt the user for a database to create It creates an empty MDB file at the location the user gives and then opens it. (You do need Jet, but I don't think I've ever seen a Windows box without it.) You can use database configure to create an Access database - in fact, you don't even need Access on the system. RS: A simple way to interact with Access is via CSV files (see also the links there) - plain text files with comma-separated values (in German locale, Access does not allow to use commas though, because it is considered decimal separator, so use semicolons instead Excel accepts commas though. Windows has bundled Jet for several years now-write a Jet-dependent application, and it should work fine on any Windows host since Windows 95 (?). Jet is Access's persistence back-end, and the aspect of Access most likely to interest Tcl developers immediately. They also offer a rudimentary ODBC driver." Description ![]() ![]() I believe that it offers an API which can be pretty easily wrapped and though it is not completely stable (according to traffic on their mailing list) seems to do a pretty good job. Microsoft Access is a database system See Also a form for Access Database migrating ms access to other databases using XML Tcl Programs for Access TDBC Tclodbc SQL Relay Other Programs for Access MDB Tools a package of libraries and utilities that allow Unix-like systems to natively read Microsoft Access database (MDB) files.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |