by Jan Aleman » Tue Mar 02, 2004 9:33 pm
If you want to connect to oracle use Oracle's JDBC driver. You can download it from technet.oracle.com or you can find it on your Oracle installation cdrom. If you've done a default oracle install on your machine you can find it in the following directory:
C:\oracle\ora81\jdbc\lib
The driver is named classes12.zip
(NOTE that later versions of the driver have a different name)
Place this file into your drivers directory inside your Servoy folder. Restart Servoy. Choose Oracle in the Auto Setup Server puldown in the DB Servers tab of preferences. Change the Server name to a name you like. Fill in the correct username and password for the connection. In the URL field replace localhost with the hostname or IP of your database server
replace <orcl_sid> (INCLUDING the < > signs) with the oracle database name. If necessary also fill in the Schema (depending on your database configuration you need to fill in a specific schema here, if you don't know you can try putting in your username)
Press OK to test your connection.
Jan Aleman
Servoy