Conectarea sgdb acces la un server oracle

10
Conectarea SGBD Acces la surse de date externe

Transcript of Conectarea sgdb acces la un server oracle

Conectarea SGBD Acces la surse de date

externe

Open Database Connectivity (ODBC) reprezintă o interfaţă standard care permite unei aplicaţii să acceseze date din surse diferite: Oracle, MS SQL Server, DB2, Informix, MS Access, dBase ş.a. Iniţiativa ODBC a aparţinut companiei Microsoft, având acceptul şi concursul firmelor de soft care produc servere BD. Interfaţa ODBC defineşte:

• o bibliotecă de apeluri de funcţii care permit unei aplicaţii să se conecteze la o sursă de date, să execute fraze SQL şi să primească rezultatele acestora;

• o modalitate standard de conectare la o sursă (BD) de date externă;

• o modalitate standard de reprezentare a tipurilor de date.• Mai trebuie menţionat că această interfaţă mai permite şi

recepţionarea, tot printr-un mecanism standardizat, a erorilor generate de motoarele diferitelor servere de baze de date care gestionează BD sursă.

Drivere ODBC

MDACThe Microsoft Data Access Components (MDAC) are a standard database interface for Windows. MDAC is already included as part of Windows 98, Windows 2000, Windows ME, and Windows XP. Some early Windows 98 OEM systems shipped without MDAC, however. MDAC is also already installed on your system if you have Internet Explorer 5.0 (or higher) or Microsoft Office. MDAC is FREE and is fully supported by Microsoft on all versions of Windows. Zugg Software applications require MDAC version 2.5 or higher, with MDAC 2.8 recommended. Windows 2000 ships with version 2.5, and Windows XP ships with version 2.7. If you have a Windows 95, 98 or Windows NT system, installing version 2.5 or higher is required. While older versions of MDAC may work, they may be very slow or have memory leaks. For best performance, you should install MDAC 2.8 on all versions of Windows. If your system does not already have MDAC installed, you need to download it and install it according to the instructions given here. There is no way to run the application without MDAC. To check to see what version of MDAC is already installed on your system, use the MDAC Checker program described below.

Microsoft has thoroughly tested MDAC. However, since this software becomes part of your operating system, there might be some very old systems that have trouble with MDAC. Zugg Software is not responsible for any damage to your system or data loss caused by MDAC. Because MDAC is system software, there is no way to uninstall MDAC without reformatting your hard disk and reinstalling Windows. However, as scary as that sounds, problems with MDAC are very rare. If you are running a database server on your computer, such as SQL Server, Oracle, Sybase, etc, consult with your system administrator

easysoft ODBC-Oracle Driver

• trebuie apelat administratorul surselor de date ODBC (din Control Panel - ODBC Data Source). Din cadrul de pagină (User/System/File)DataSourceName

CREAREA UNEI SURSE DE DATE ORACLE PRIN ODBC

• se alege butonul Add care lansează fereastra de dialog Add Data Source.

CREAREA UNEI SURSE DE DATE ORACLE PRIN ODBC

CREAREA UNEI SURSE DE DATE ORACLE PRIN ODBC

• Din lista de drivere ODBC se alege Oracle ODBC Driver

CREAREA UNEI SURSE DE DATE ORACLE PRIN ODBC

• completarea informaţiilor cerute în fereastra de dialog Oracle8 ODBC Setup( Data Source Name, UserId şi Service Name)

CREAREA UNEI SURSE DE DATE ORACLE PRIN ODBC

• După selectarea butonului OK din ultima fereastră de dialog, numele sursei de date se va regăsi printre celelalte surse de date disponibile pe respectiva maşină.

Proiect realizat de :Irimia Diana Pantea Calin [email protected]

http://tiny.cc/f180nw