The Oracle Connection Form is displayed after choosing the "Scriptoria for Oracle" Tools | Add-ins MS-Access menu item.
After selecting an ODBC Data Source, the ODBC data source description is displayed. Enter your User ID and Password.
Note-1: To make a connection from Scriptoria with a different Oracle database requires that you exit and restart Access.
Use the ODBC Data Source Administer found in the Control Panel to register Oracle ODBC data sources.
Important DataDirect ODBC Driver Work Around:
When using DataDirect ODBC drivers (version 4.0, 4.1, 4.2), you must modify the registry entry for each ODBC data source you create. The following work around is found in the DataDirect knowledge base.
reserved error (-7748): there is no message for this error
To resolve this error, set WorkArounds2=8192 for your data source.
This can be done by using the registry editor (REGEDIT).
For a USER Data Source, select the following registry key: \\HKEY_CURRENT_USER\Software\ODBC\OBDC.INI\(YOUR_DSN_NAME).
For a SYSTEM Data Source, select the following registry key: \\HKEY_LOCAL_MACHINE\Software\ODBC\OBDC.INI\(YOUR_DSN_NAME).
Right click, and select 'New' and then 'String Value'. Set the name of the new string to 'WorkArounds2' and its value to 8192.
NOTE: Windows 95, 98, or Me platforms require a reboot after making these changes.