connecting to oracle database what driver should i use

A

aneurin

hi a complete mac newbie here
on a daily basis i have to connect to an oracle database
using the below connection

Dim cnn As New ADODB.Connection
Dim rst As New ADODB.Recordset
Dim col As Integer

cnn.Open "Driver={microsoft odbc for oracle};" & _
"Server=" & servername & ";" & _
"Uid=easy;" & _
"Pwd=easy;"

which works great on a pc
but iam trying to make the connection work on a mac
and i havent got a clue which driver to use
can someone please advise

aneurin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Oracle Connection String 1
Syntax to add recordset using ADO, ODBC Sybase driver 2
DSN-Less connections with MS Oracle Driver 4
INSERT INTO where data is on an Oracle database 3
DAO & ADO within the Same Application? 1
Oracle Sequence Jumps by 3 from Excel 1
Convert ODBCDirect Codes to ADO in Access 2007 1
Appending records: 2 ADO connections 1

Top