Connecting to oracle 10g using OCI
530361Aug 28 2006 — edited Sep 7 2006Hi
i have oracle 10g installed on my server and oracle 10g client installed on my machine. i want to connect to my server database using OCI. i have written a program that accesses oracle database if i run it on server itself. but i want to write a simple c program (not c++) which will connect to the database at my server and execute sql statments. i think that server program with some amendments should work. May be the connection string i am giving in server attach is wrong. because when i run the program i get following error:
Error - ORA-24327: need explicit attach before authenticating a user
Error - ORA-03114: not connected to ORACLE
please help me. thanx