Connecting to an oracle database with dao and odbc 
Author Message
 Connecting to an oracle database with dao and odbc

Hello, I have  been having trouble getting a connection to an oracle database
as in the subject.  All I would like to do is connect to this existing
database and then I am fine with the rest.  I haven't been able to get the
right syntax.  I am using vb 4.0  Enterprise edition, and if someone can give
me the syntax for these lines, or a pointer to the documentation (I've been
looking, but have not found the right bit) I would be most appreciative.  If
this is in the FAQ, then I am truly sorry (I don't think it is, but I read that
before I tried anything with oracle)

Thank you,

Carol



Sun, 06 Jun 1999 03:00:00 GMT  
 Connecting to an oracle database with dao and odbc


Quote:

>Hello, I have  been having trouble getting a connection to an oracle database
>as in the subject.  All I would like to do is connect to this existing
>database and then I am fine with the rest.  I haven't been able to get the
>right syntax.  I am using vb 4.0  Enterprise edition, and if someone can give
>me the syntax for these lines, or a pointer to the documentation (I've been
>looking, but have not found the right bit) I would be most appreciative.  If
>this is in the FAQ, then I am truly sorry (I don't think it is, but I read that
>before I tried anything with oracle)

>Thank you,

>Carol

The following code will connect you to an Oracle database

Dim mydb as database

Set mydb = Workspaces(0).OpenDatabase("", False,
False,"ODBC;DSN=odbcname;DBQ=TnsNamesName")

For DSN you supply the ODBC name that you created and fro DBQ you
provide the tnsnames.ora name.

David



Mon, 07 Jun 1999 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Connecting to Oracle using ODBC and DAO

2. How to connect VB witout usin ODBC to Oracle databases

3. How do I get data from an Oracle database via DAO/ODBC on excel7

4. Use ODBC API connect Oracle Database

5. HELP: Data Access Objects w/ ODBC connected to Oracle Database

6. how to connect ORACLE database through ODBC?

7. Problem connecting to Oracle Database using ODBC

8. HELP: Data Access Objects w/ ODBC connected to Oracle Database

9. DAO and ADO connection for ODBC Oracle Databases

10. HOWTO connecting to Oracle database without Oracle Client?

11. Can't open Oracle database with DAO35 and Oracle-ODBC

12. DAO or RDO for connecting to ORACLE????

 

 
Powered by phpBB® Forum Software