PassportODBC - ODBC Viewer, View or edit any ODBC enabled database. Use Table Dump and Table Reload feature to test and retest your applications. Viewer shows content and structure without the orginal Database Frontend.
The program connects to an ODBC connection for viewing data, editing data, displaying field information, exporting the data in a table and importing the data that was exported.
First step is to correlate an ODBC structure with an Alias. Create a new alias, select the Database Drive Name, enter a name of the Alias in place of the default name and select the path to the ODBC database. If your tables are not local, you may need to define access to your tables via the operating system ODBC Administrator.
Start the program and select the alias from the dropdown list and the tables will be displayed.
The number of fields and Record Count or number of records in the table is displayed in the upper right. The lower display describes the database, alias and field information. Right click on the table information to save to a file. Options in the Maintenance menu provides the ability to do a table dump to an ASCII file and to reload the data what was dumped. This is useful when table data is read, exported, modified and deleted during testing of custom processing. When reloading data into a table the Alias and Table name must match. If the table that is selected has a memo field, a memo display will appear between the records and table information and the data in the memo field is displayed when the memo field is selected.
List of Changes:
Version odbcv10 from 2005-04-27
Latest User Reviews:
Vheeswijk 2010-07-13 01:50:51 #
PasswordODBC is difficult, if not impossible, to find on the Internet. Download links simply do not work. Moreover, this program is often confused with ODCBView, which is an other program. The latter is a true ODBC-viewer, whereas PasswordODBC is a table editor. I was happy to find PasswordODBC in my own CD-collection and it is now up and running again. I'still evaluating the software and I might consider uploading it to an appropriate site to make it accessible again for users seeking a good ODBC table editor.
Jirving42 2010-04-09 15:40:06 #
This looked great initially as a way to access and manage data in a Spiceworks database. Then I noticed that only numeric and date fields are displayed. If there's a way to include long text fields in the display, and hopefully also to edit them, I haven't found it yet.
Cnauta70 2009-06-27 14:11:06 #
So far so good. I like how it imports tables into Access much quicker than other ODBC drivers I have tried for Quickbooks 2009.
Rstaveley 2008-05-13 06:25:37 #
Useful but could do with a command prompt
This is quite a good tool for inspecting ODBC tables. My only real grumble with it is that it inspects the entire table rather than applying a limit and that means that it appears to die while loading large tables over the Internet.
laszlo 2007-01-08 08:30:39 #
Used for testing purposes only
It worked for my needs. Thanks!
tburgar 2006-12-17 09:49:59 #
Review of ODBC Program
I cannot give a thorough evaluation. I downloaded the program to read a file that was not in the right format for the program. However, the program does seem like a useful tool if used as intended.