Re: Can you access an ODBC datasource from Pro*C program?

[Quoted] On 11 Aug 1997 15:50:49 GMT, fool_at_ofb.net (Art Clarke) wrote:

[Quoted] This technique is apparently not supported by Oracle. If you want to access an ODBC datasource from a C program, make use of the ODBC API (there should be no problem having Pro*C code and ODBC code in one app).

-sm

>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 Tue Aug 12 1997 - 00:00:00 CEST