بتاريخ: 30 مارس 200719 سنة comment_95493 you can do that by linking access to oracle developer using ODBCConnecting to ODBCOracle 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 ODBCWhen 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 تقديم بلاغ
بتاريخ: 30 مارس 200719 سنة كاتب الموضوع comment_95520 جزاك الله خير ياخى على الاجابهولكنى عندى سوال اخر ياريت ترد عليا فيه وهو لو انا فقد الستب اب الخاص بالاوراكل اوالخاص نسخه الويندز كبف استرجعالجداول التى انشئتها باوراكل وايضا المعلومات اللى كانت متخزنه فى هذه الجداول تقديم بلاغ
بتاريخ: 31 مارس 200719 سنة كاتب الموضوع comment_95601 اى اريد من حضرتك طريقه نسخ للجداول فى schemaاو غيرها بس تكون متزامنه مع اى تغير يحدث فى الجداولبحيث اقدر ارجع الجداول مره اخرى لوفقدتها تقديم بلاغ
بتاريخ: 17 أكتوبر 201015 سنة comment_201638 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 wellthe oracle forms on a clint machine but still can't connect username/password@ordbc:data_source_namecan anyone help???? تقديم بلاغ
بتاريخ: 18 أكتوبر 201015 سنة comment_201672 الاخ oramasterهناك مشكلة بالاتصال بين الفورم وملف الاكسس لذلك قم باعادة انشائها من جديد مع تغيير اسمها وان شاء الله تعمل عندك تقديم بلاغ
انضم إلى المناقشة
يمكنك المشاركة الآن والتسجيل لاحقاً. إذا كان لديك حساب, سجل دخولك الآن لتقوم بالمشاركة من خلال حسابك.