الانتقال إلى المحتوى
View in the app

A better way to browse. Learn more.

مجموعة مستخدمي أوراكل العربية

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

كيفيه ربط الديفلوبر بجداول اكسيس

Featured Replies

بتاريخ:

اريد عمل فورمز مربوطه بجداول اكسيس كيف ذللك؟

بتاريخ:

you can do that by linking access to oracle developer using ODBC

Connecting to ODBC
Oracle Developer uses the Oracle Open Client Adapter (OCA) to connect to non-Oracle data sources. If you go into Forms Developer's online help system and look up ODBC, you will see information on "Accessing non-Oracle data sources."
Personal Oracle Lite



Configuring ODBC
When Jim installed Access on his machine, it made sure to update the necessary ODBC drivers so that other applications could access any databases he created. When Jim created a test database with a couple of tables and some sample data, he performed the first steps necessary to be able to use Oracle Developer with Access. Jim needs to complete the setup by going into the ODBC configuration program and finish setting up the database. Jim does this by following these steps:

Click on Start, Settings, Control Panel.

Double-click on the ODBC Data Sources icon.

Select MS Access Database from the list, and click the Configure button. If it does not exist, Jim needs to add one by clicking on the Add button, selecting Microsoft Access Database, and clicking on the Finish button.

Assign a name to the database. Jim is using the name ODBCTest.

Assign a description about the connection.

Click on the Select button. A File dialog box appears, in which the test database file can be chosen. Jim chooses the name db3 because it seems like a good idea at the time. (You can choose something a little more descriptive.)

Click on the Advanced button for the option of assigning a username and password. Doing this allows one to limit access to the database. More importantly, it allows one to create connections strings similar to Oracle's. Jim is using the combination of test for the username and test for the password. It is not original, but very easy to remember for this exercise.

Click OK to close the Set Advanced Options dialog box.

Click OK to close the ODBC Microsoft Access Setup dialog box.

Click OK to close the ODBC Data Source Administrator dialog box.

You are now ready to connect Oracle developer to your Access database.

Good luck

بتاريخ:
  • كاتب الموضوع

جزاك الله خير ياخى على الاجابه
ولكنى عندى سوال اخر ياريت ترد عليا فيه وهو لو انا فقد الستب اب الخاص بالاوراكل اوالخاص نسخه الويندز كبف استرجع
الجداول التى انشئتها باوراكل وايضا المعلومات اللى كانت متخزنه فى هذه الجداول

بتاريخ:
  • كاتب الموضوع

اى اريد من حضرتك طريقه نسخ للجداول فى schemaاو غيرها بس تكون متزامنه مع اى تغير يحدث فى الجداول
بحيث اقدر ارجع الجداول مره اخرى لوفقدتها

بتاريخ:

جزاك الله خير

  • بعد 3 سنة...
بتاريخ:

i folowed the steps mensioned above but the error ora-03121
the mdb access file located on the oracle db server and the ms access ODBC data source as well
the oracle forms on a clint machine
but still can't connect username/password@ordbc:data_source_name
can anyone help????

بتاريخ:

الاخ oramaster
هناك مشكلة بالاتصال بين الفورم وملف الاكسس لذلك قم باعادة انشائها من جديد مع تغيير اسمها
وان شاء الله تعمل عندك

انضم إلى المناقشة

يمكنك المشاركة الآن والتسجيل لاحقاً. إذا كان لديك حساب, سجل دخولك الآن لتقوم بالمشاركة من خلال حسابك.

زائر
أضف رد على هذا الموضوع...

برجاء الإنتباه

بإستخدامك للموقع فأنت تتعهد بالموافقة على هذه البنود: سياسة الخصوصية

Account

Navigation

البحث

إعداد إشعارات المتصفح الفورية

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.