Re: Need help configuring ODBC Datasource for oracle on Unix

Check

1. ping <host_name>, if it's OK, go on
2. tnsping <oracle_server_name>, if it's OK, go on
3. Intersolv's testing program demoodbc or democonnect. If not working, check your odbc.ini, environment variables, and so on.

Sample odbc.ini can be reached at \\Informix\docuemnts(?)\INFORMIX_Open User Manual, page 1-10. File odbc.ini format should be the same for Oracle and Informix at UNIX.

Hope it helps.

Jinsong Qiu

Alexandre Savard <asavard_at_infomar.com> wrote in article <34ea0918.1057227552_at_news.total.net>...
> HI.
>
> I'm using Intersolv's ODBC driver for solaris, and I need to
> configure the datasource to make it to work with Oracle 7.3.3 (SQLNet)
> My problem is that i'm unable to understand what I have to write in
> each field of my odbc.ini file. When I run my test program in C, I
> allocate my henv and hdbc handles. This works fine. Then I try to
> use SQLConnect, and the program hangs.
>
> Does anyone ever made this work, cause i've spent the last 2 days on
> this mess and it never worked.
>
> Thanks
> -----------
> Alexandre Savard
> Infomar Marine Services
> asavard_at_infomar.com
>
> "Day after day, grain after grain,
> The sand slips through your fingers,
> While you uselessly try to stop it.
> Meanwhile, You don't realize,
> That behind your back, still shines the sun."
>
  Received on Wed Feb 18 1998 - 00:00:00 CST