Re: Can you access an ODBC datasource from Pro*C program?
Date: 1997/08/11
Message-ID: <5snccp$83q_at_gap.cco.caltech.edu>#1/1
[Quoted] [Quoted] On Windows Platforms it is possible to use Pro*C to manipulate ODBC data sources. You need to first install the Oracle Open Client Adapter (shipped with Developer/2000). Once installed, you can connect to any ODBC data source by using 'odbc:data_source_name' as your SQL*Net connect string. You do not need to do anything special with Pro*C to get this to work.
For example, if your ODBC datasource is named MSSQLServer65, you can connect
(assuming the username is 'scott' and the password is 'passwd') using:
scott/passwd_at_odbc:MSSQLServer65
as your connect string.
- Art Clarke
Manu Kodiyan (mkod_at_best.com) wrote:
> Hi,
> I need to access an ODBC datasource and extract some data that will be
> stored in an Oracle database. I was hoping to use Pro*C to do that. Is
> it possible to access an ODBC datasource through Pro*C?
> Do any of yiu have experience doing that? Any help will be greatly
> appreciated.
> Manu Kodiyan
> mkod_at_best.com
--Received on Mon Aug 11 1997 - 00:00:00 CEST