ODBC

From Omnia
Revision as of 16:56, 15 April 2015 by Kenneth (talk | contribs) (Created page with "== ODBC == Open Database Connectivity Open Database Connectivity - Wikipedia - http://en.wikipedia.org/wiki/Odbc :"In computing, Open Database Connectivity (ODBC) provides a...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

ODBC

Open Database Connectivity

Open Database Connectivity - Wikipedia - http://en.wikipedia.org/wiki/Odbc

"In computing, Open Database Connectivity (ODBC) provides a standard software interface for accessing database management systems (DBMS). The designers of ODBC aimed to make it independent of programming languages, database systems, and operating systems. Thus, any application can use ODBC to query data from a database, regardless of the platform it is on or DBMS it uses. ODBC accomplishes this by using a driver as a translation layer between the application and the DBMS. The application thus only needs to know ODBC syntax, and the driver can then pass the query to the DBMS in its native format, returning the data in a format the application can understand."

ODBC Table View

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

Previous Name:

PassportODBC

PassportODBC - http://www.vista-files.org/programs/embassy-software-inc/passportodbc.html

  • License: Freeware
  • Language: English
  • Release: 2005-04-27
  • Size: 20 Mb
  • Cost: Free

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.

Create Connection

  • Start -> Administrative Tools -> Data Sources (ODBC)
    • %windir%\system32\odbcad32.exe

32bit and 64bit ODBC Data Sources Manager

The 64bit ODBC client is available under:

%windir%\system32\odbcad32.exe
C:\Windows\System32\odbcad32.exe

The 32-bit ODBC client is available under:

%windir%\SysWOW64\odbcad32.exe
C:\Windows\SysWOW64\odbcad32.exe

Oracle

Oracle 11gR2:

The Oracle client should be installed with the following options enabled:

  • SQL*Plus
  • Oracle Net
  • Oracle ODBC Driver
  • Oracle Services for Microsoft Transaction Server
  • Oracle Data Provider for .NET
  • Oracle Providers for ASP.NET

Oracle ODBC Issues

When connecting with 32bit client:

Unable to connect
SQLState=S1000
[Oracle][ODBC][Ora]ORA-12514: TNS:listener does not currently
know of service requested in connect descriptor

Solution:

  • Check user name and password
  • Check your tnsnames.ora file to make sure it matches what is listed on the server.

keywords