Hi Everyone! could anyone please tell me how i can do database connectivity using the oracle database. Following is the code i wrote but the table "rosm" just does'nt get updated
thanks a lot in advance, Ravissant
Joined: Nov 12, 2006
hi again, well i figured it out by myself,but then again i have some doubts.I found 2 approaches of which i could get only one working. First, the approach i could'nt get, im including only the code snippents i did'nt understant:
could anyone please descriptively tell me what "jdbcracle:thin:@training:1521:Oracle" is?
Moving on to the second approach:
could anyone please tell me what the DSN exactly does? Also I'd really appreciate it if someone could tell me the exact difference between the two approaches.
Thanks a lot, Ravissant
Joined: Jul 17, 2006
first question: jdbcracle:thin:@training:1521:Oracle is the URL of your database. jdbc = connection type oracle = your database thin = drivertype training = machinename 1521 = portnumber Oracle = databasename
second question: jdbcdbc:Mydsn_oracle Mydsn_oracle is the name of your ODBC-datasource (should be somewhere in settings - control panel - administrative tools)
third question: difference between those two: The first tries to connect to the database using the Oracle driver, the second one uses the JDBC-ODBC bridge as driver (not meant for production-code)