probably simple - Pro*C, gcc, Solaris 2.8 and connect

Hi everybody,

I have two SUNs at home an Ultra 10 and a Blade 1000. I put 4Gb of RAM in the Blade installed oracle 9.2 on it and oracle client 9.2 on the U10.

Now what I don't get is that I can sqlplus from the U10 to the Blade and no problem. I can TNS ping it from the U10. And I swear that the definition in the tnsnames.ora looks perfect. I haven't tried toad but suspect it would work..

I have written a small C application compiled with gcc the using the -m64 flag and I no matter what I try I can not get it to connect..

In sqlplus I can do "sqlplus user_at_sid/password" but if I do:

char *connstr = "user_at_sid/password";
SQL EXEC
CONNECT :connstr;
END SQLEXEC I get the on error handler called and the error code with
"oerr ora" map to could not resolve service name..
I get -12154 and -3114 from the app...

I had a look at some code snipits of where I used to work and they had the just user name and password in the Pro*C... But they have the database on the same box and anyway that was AIX... And they have heaps of DBAs..

How does client/server work from C++ code ??? Please help, some pointers or something please, I have spent a fortune on oracle books but still can't work it out... Is Pro*C a secret, why is it never talked about in the
"complete reference" ??

I anaylse kernel crash dumps and hack around in driver code for a living and can't be seen reading groups like this at work.. Please respond to my hotmail account...

My user ID is regan_russell..

many, many thanks,

Regan Received on Sun Sep 11 2005 - 16:57:32 CDT