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

spam.sink_at_volcanomail.com wrote:
> Hi everybody,
>
>
> 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...
>

In our application the connect is done with:

	_b_fxuserid = "user/password";
	_b_oracle_sid = "sid";
	EXEC SQL CONNECT :_b_fxuserid USING :_b_oracle_sid;