Dec 22, 2014 Linked Server Error: 64-bit Server 2012, 32-Bit ODBC driver to Codebase.DBF file based database, #7303 DSN architecture mismatch between the driver and application SQL Server. We are delighted to present the updated version of Devart ODBC driver for xBase 1.3, which now allows you to: View and edit databases in.
![]()
License: All 1 2 | Free
Odbc 4 ALL is a 32 bit Windows utility designed to easily allow any application, including DOS apps and batch files, to run SQL queries using any Odbc data source, (Access, Informix, MySql, Oracle, Sql Server, ...), redirecting the output to the screen, an ascii file / table or a DBF table. When run in interactive mode, you can interactively choose the Odbc Data Source...
Category: Utilities / System Surveillance
Publisher: aSwIt Srl: Mail, Print for DOS, Windows, License: Shareware, Price: USD $64.00, EUR49, File Size: 1.1 MB Platform: Windows
xBaseView is a multi-functional database tool designed for novice database administrators or advanced database users. It looks like Microsoft Windows Explorer and allows you to work with databases just like in Explorer: database files are displayed in a folder-tree and you can open it with the mouse. With xBaseView, you can perform all typical operations such as searching, filtering and...
Category: Business & Finance
Publisher: Mutex LLC, License: Shareware, Price: USD $39.00, File Size: 1.4 MB Platform: Windows
DTM Odbc Manager is a free simple and easy-to-use Odbc Data Sources manager. The program allows you to export data source definitions into a file and then restore it on a local or remote system. Odbc Manager is an indispensable tool for DBAs or developers who have to transfer data source definitions between computers and is a perfect addition to the system Odbc...
Category: Business & Finance
Publisher: DTM soft, License: Freeware, Price: USD $0.00, File Size: 295.4 KB Platform: Windows
DTM Odbc Driver List is a free command line tool that enumerates or export to text file the list of installed Odbc drivers. The text file generated by the tool is ready to open by Microsoft Excel. There are tow output format: brief and full. The program also can show version of installed driver. This feature helps to identify driver revision problems by one click. The...
Category: Software Development
Publisher: DTM soft, License: Freeware, Price: USD $0.00, File Size: 21.0 KB Platform: Windows
DTM SQL runner is a free command line tool for SQL statements execution. The runner allows the user to specify Odbc data source name and file with SQL statement to be executed. This handy tool for developers, database administrators and advanced users is suitable for batch and scheduled job execution. It is compatible with Window Scheduler and most third party schedulers. The...
Category: Software Development
Publisher: DTM soft, License: Freeware, Price: USD $0.00, File Size: 69.0 KB Platform: Windows
Devart Odbc Driver for Oracle provides high-performance and feature-rich connectivity solution for Odbc-based applications to access Oracle databases from Windows 32-bit and 64-bit, Mac OS X, Linux. Full support for standard Odbc API functions and data types implemented in our driver makes interaction of your database applications with Oracle fast, easy and extremely handy....
Category: Business & Finance / Database Management
Publisher: Devart, License: Shareware, Price: USD $149.95, File Size: 6.2 MB Platform: Windows, Mac, Linux
Devart Odbc Driver for SQL Server provides high-performance and feature-rich connectivity solution for Odbc-based applications to access SQL Server databases from Windows, Linux, MacOS, both 32-bit and 64-bit. Full support for standard Odbc API functions and data types implemented in our driver makes interaction of your database applications with SQL Server fast, easy and...
Category: Software Development / Components & Libraries
Publisher: Devart, License: Shareware, Price: USD $149.95, File Size: 5.8 MB Platform: Windows, Mac, Linux
Devart Odbc Driver for PostgreSQL provides high-performance and feature-rich connectivity solution for Odbc-based applications to access PostgreSQL databases from Windows, Linux, MacOS, both 32-bit and 64-bit. Full support for standard Odbc API functions and data types implemented in our driver makes interaction of your database applications with PostgreSQL fast, easy and...
Category: Software Development / Components & Libraries
Publisher: Devart, License: Shareware, Price: USD $149.95, File Size: 5.7 MB Platform: Windows, Mac, Linux
Devart Odbc Driver for InterBase provides high-performance and feature-rich connectivity solution for Odbc-based applications to access InterBase databases from Windows, both 32-bit and 64-bit. Full support for standard Odbc API functions and data types implemented in our driver makes interaction of your database applications with InterBase fast, easy and extremely handy....
Category: Software Development / Databases & Networks
Publisher: Devart, License: Shareware, Price: USD $149.95, File Size: 10.9 MB Platform: Windows ![]()
Devart Odbc Driver for Firebird provides high-performance and feature-rich connectivity solution for Odbc-based applications to access Firebird databases from Windows, both 32-bit and 64-bit. Full support for standard Odbc API functions and data types implemented in our driver makes interaction of your database applications with Firebird fast, easy and extremely handy....
Category: Software Development / Databases & Networks
Publisher: Devart, License: Shareware, Price: USD $149.95, File Size: 11.0 MB Platform: Windows
Devart Odbc Driver for SQL Azure provides high-performance and feature-rich connectivity solution for Odbc-based applications to access SQL Azure databases from Windows, Linux, MacOS, both 32-bit and 64-bit. Full support for standard Odbc API functions and data types implemented in our driver makes interaction of your database applications with SQL Azure fast, easy and...
Category: Software Development / Components & Libraries
Publisher: Devart, License: Shareware, Price: USD $149.95, File Size: 4.3 MB Platform: Windows
Devart Odbc Driver for SQLite provides high-performance and feature-rich connectivity solution for Odbc-based applications to access SQLite databases from Windows, Linux, MacOS, both 32-bit and 64-bit. Full support for standard Odbc API functions and data types implemented in our driver makes interaction of your database applications with SQLite fast, easy and extremely...
Category: Software Development / Components & Libraries
Publisher: Devart, License: Shareware, Price: USD $149.95, File Size: Platform: Windows, Mac, Linux
Devart Odbc Driver for Salesforce provides high-performance and feature-rich connectivity solution for Odbc-based applications to access Oracle databases from Windows 32-bit and 64-bit, Mac OS X, Linux. Full support for standard Odbc API functions and data types implemented in our driver makes interaction of your database applications with Oracle fast, easy and extremely...
Category: Business & Finance / Database Management
Publisher: Devart, License: Shareware, Price: USD $149.95, File Size: 8.3 MB Platform: Windows
Devart Odbc Driver for MongoDB provides high-performance and feature-rich connectivity solution for Odbc-based applications to access MongoDB databases from Windows, MacOS, Linux. Full support for standard Odbc API functions, MongoDB data types and SQL queries implemented in our driver makes interaction of your database applications with MongoDB fast, easy and extremely...
Category: Business & Finance / Database Management
Publisher: Devart, License: Shareware, Price: USD $149.95, File Size: 10.1 MB Platform: Windows
View and Synchronize Microsoft Access, Excel, Oracle, Foxpro, dBase or any Odbc enabled database with palm. Add, Delete, Modify Database records on palm. Get updated desktop data on palm and palm data on desktop automatically. Synchronize data at specific date-time. View one record at a time or all at once on Palm. Export records to Memo Pad application. Search Facility is provided. Beam...
Category: Business & Finance / MS Office Addons
Publisher: Cellica Software Services, License: Shareware, Price: USD $24.95, File Size: 801.7 KB Platform: Palm, Handheld/Mobile Other
DBFView - the most popular DBF editor and viewer for Win9x/NT/2000/XP/Vista/Win7 in the world! DBFView is a compact but powerful tool for viewing, editing, and printing DBF-format databases. It supports dBase, Clipper, FoxPro, Visual FoxPro and other DBF formats. In contrast to many analogues, DBFView is completely a Windows9x/NT/2000/XP/Vista/Win7 program.The user friendly program...
Category: Business & Finance / Database Management
Publisher: DBFView Software, License: Shareware, Price: USD $49.00, File Size: 603.6 KB Platform: Windows
ASP XMLMaker is an easy-to-use code generator for creating ASP (Active Server Pages) that output XML from a Microsoft Access Database or any Odbc Data Source. You can instantly serves XML for Ajax, RSS, Flash or any other applications that consumes XML. ASP XMLMaker is designed for high flexibility, many options enable you to generate the XML in a format that best suits the client...
Category: Software Development
Publisher: e.World Technology Ltd., License: Shareware, Price: USD $49.95, File Size: 5.7 MB Platform: Windows
DAC for EnterpriseDB is a BDE replacement for Delphi/C++Builder. It allows you to create Delphi/C++Builder applications with direct access to EnterpriseDB without BDE and Odbc. This component set was developed for easy migration of existing projects from a BDE/Odbc scheme to the native one. The interface is BDE-like and TDataSet compatible. A TDBImageEx component...
Category: Software Development
Publisher: MicroOLAP Technologies LTD, License: Shareware, Price: USD $134.95, File Size: 5.2 MB Platform: Windows
DAC for MySQL (also known as MySQLDAC) is the most powerful component suite for Delphi/C++Builder/MySQL. This component suite allows you to create Delphi/C++Builder applications with direct access to MySQL DB without BDE and Odbc. BLOB fields are supported. MySQLDAC was developed for easy migration of existing projects from BDE/Odbc scheme to the native one. A MySQL...
Category: Software Development / Components: Delphi
Publisher: MicroOLAP Technologies LTD, License: Shareware, Price: USD $134.95, File Size: 32.3 MB Platform: Windows
Data Exchange Wizard Loads or export data from/into ANY database. Full support for Excel, Access, DBF and Text files,XML, Oracle, MS SQL Server, Interbase/Firebird, MySQL, PostgreSQL, OleDB, SQLite, MS SQL Server Compact or ANY Odbc compliant database. Great performance - Thousands of records per second. Easy to use and learn Data Exchange Wizard may run calculations during import and...
Category: Business & Finance / Database Management
Publisher: DB Software Laboratory, License: Shareware, Price: USD $130.00, File Size: 6.0 MB Platform: Windows
This ActiveX helps you to load and export data from/into various datasources such as delimited and fixed width files or Odbc data source into/from Oracle, MS SQL Server or any Odbc compliant database Uses naitive API, Capable of performing calculation during import, may also execute SQL statements before and after Import or Export . Integrated expression builder, comprehensive...
Category: Software Development / ActiveX
Publisher: DB Software Laboratory, License: Shareware, Price: USD $100.00, File Size: 3.4 MB Platform: Windows
Powerful, easy-to-use SQL tracer for Oracle, MS SQL, MySQL, Interbase/Firebird, Advantage Server, Odbc, ADO. You don't need to have administrator privileges on your database server! File and registry operations are supported as well. FlexTracer dumps all executed SQL statements, their results, parameters and execution time. It's also possible to merge a SQL statement with its parameters....
Category: Software Development
Publisher: Easymatica.com, License: Shareware, Price: USD $39.95, File Size: 810.0 KB Platform: Windows
Pure Java Type 4 DBF JDBC(1.2, 2.0, 3.0) driver packages for Xbase database (dbase, Visual DBASE, SIx Driver, SoftC, Codebase, Clipper, PowerPlus, Foxbase, Foxpro, VFP, xHarbour, Halcyon, Apollo, Goldmine, and BDE), which supports transaction, embedded access, and remote access. It supports Xbase applications' compatible lock ( DBASE, DBASE4BDE, DBASEIII, DBASEIV, Clipper,...
Category: Software Development
Publisher: Hongxin Technology & Trade Ltd., License: Shareware, Price: USD $221.00, File Size: 973.2 KB Platform: Windows, Mac, Linux, Unix, OS/2, Netware
Odbc database viewer.Easy and suitable access through Odbc DSN to different database. Comparison of the structure database. Data exchange between DSN source including XML scenario export. The Possibility of the use transactions. Built-in Scheduler. Open XML interface of the expansion Odbc driver. Full multithreading. Testing for Oracle RDB 7.01, MsSql 6.5 - 2005, Oracle 10,...
Category: Software Development
Publisher: dbPlus, License: Shareware, Price: USD $49.00, File Size: 312.0 KB Platform: Windows
PostgresDAC is a PostgreSQL BDE replacement for Delphi/C++Builder. It allows you to create Delphi/C++Builder applications with direct access to PostgreSQL DB without BDE and Odbc. This components set was developed for easy migration of existing projects from BDE/Odbc scheme to the native one. Interface is BDE-like and TDataSet compatible. It supports of Delphi 5-7,...
Category: Software Development / Components: Delphi
Publisher: MicroOLAP Technologies LTD, License: Shareware, Price: USD $134.95, File Size: 29.6 MB Platform: Windows, Other
In this brief tutorial, I'll show you how to configure ODBC driver for xBase on Windows and connect Tableau Desktop to a Visual FoxPro database using ODBC. xBase database family includes a range of databases informally known as dBase clones and includes such databases as Visual FoxPro, Clipper, dBase III, dBase IV, and many others. dBase-like databases store data in .dbf files. A single .dbf file contains a table description, field descriptors, and records.
Prerequisites:
1) At first, you need to install an ODBC driver. Devart ODBC driver for xBase supports the following dialects of the xBase family: dBaseIII-dBase10, VisualFoxPro, HiPer-Six, Clipper, and Codebase.
2) Download and install the fully-functional trial version of the driver.
3) Open the ODBC Data Source Administrator and click Add to create a data source name.
4) Choose Devart ODBC Driver for xBase in the list of drivers installed in the system and give a name to your data source.
Let's move on! Since .dbf files are stored locally and don’t require a database server, you only need to specify the path to the folder that contains the files and select the xBase dialect, which is Visual FoxPro in this case.
Run Tableau and select Connect > To a Server > Other Databases (ODBC).
In the connection box that appears, select the previously configured DSN and click Connect.
Tableau will automatically fill the connection string parameters of the wizard with values specified in the DSN. You only need to confirm the connection attempt by clicking Sign in.
In the workbooks that open, you have two options to retrieve data from DBF files.
1. Enter a few letters of the table name that you’re interested in, click the search icon, and Tableau will show you the respective table. Drop the table onto the Drag tables here area, and then click Update Now.
2. Double-click the New Custom SQL button and write your SQL statement, without the semicolon at the end of the statement. After that, click Update Now to retrieve the matching data.
Either way, you should see the table contents displayed in the grid.
That's it! Now you can create a data extract to use the full functionality of Tableau and analyze the extracted data.
What connection methods do you use?
![]() Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2023
Categories |