|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
You don't need a fax machine to get faxes. Get a fax-to-email fax number from CallWave. Try it free.
|
|
#1
November 23rd, 2003, 04:46 PM
|
|||
|
|||
|
Connecting Visual Basic to Oracle
Hi,
Can someone please provide me detailed instructions on how I can connect Visual Basic 6.0 Professional to Oracle 8.1.5 (which is on a server) using the Oracle Driver (not Microsoft ODBC Driver)? Do I need a DSN and TSN? What is the VB code that I use and where would I place it in my VB Project? What references/libraries do I need--how would I add them to the project? How can I send a SQL queries and retrieve results from the Oracle server? As you can tell, this is my first time doing this...please help. I would greatly appreciate it. Thanks.
|
|
#2
November 24th, 2003, 04:05 AM
|
||||
|
||||
|
In order to use Oracle's ODBC driver you have to install Oracle Client and configure your tnsnames.ora.
__________________
My blog about OpenSource Databases PDF tutorials about OSS databases, DBMonster ... Please contribute to Open Source Development, fill bug reports!!! Developer Shed eSupport Commented my.ini/my.cnf (PLEASE ADD YOUR OWN CONFIG TRICK) Understanding SQL Joins An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries
|
|
| Viewing: Dev Shed Forums > Databases > Oracle Development > Connecting Visual Basic to Oracle |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
