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

sm (sm_at_nowhere.com) wrote:
> On 11 Aug 1997 15:50:49 GMT, fool_at_ofb.net (Art Clarke) wrote:
 

> 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).

There should be no problem having Pro*C code and ODBC mixed, but last I checked, using Pro*C to access ODBC data sources did work (I'll check with support to see why they say it isn't supported. I can attest to fixing two Pro*C related bugs in the past year in this product. Curious).

However, I have to admit that using ODBC for your ODBC data source and Pro*C to store the data in your Oracle database is probably the best way if you already know ODBC -- You can avoid the overhead of the Open Client Adapter that way.

• Art

> -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
> >
> >--

--