After running openlink.sh and the set command the
following variables or set:
ODBCINI=/usr/local/src/bin/odbc.ini
ODBCINSTINI=/usr/local/src/bin/odbcinst.ini
OLDPWD=/home/httpd/html/ronsdev
OPTERR=1
OPTIND=1
ORACLE_HOME=/home/oracle/OraHome1
ORACLE_SID=data1
However when odbctest I still get the following error:
Enter ODBC connect string (? shows list):
DSN=[pc963];UID=test;PWD=test
OpenLink: RPC: Unknown host
[OpenLink][ODBC]RPC: Unknown host, SQLSTATE=08004
[OpenLink][ODBC]Connection rejected by data source,
SQLSTATE=08004
Have a nice day.[tbaker@PC963 tbaker]$
/usr/local/src/odbcsdk/examples/odbctest
OpenLink ODBC Demonstration program
This program shows an interactive SQL processor
Enter ODBC connect string (? shows list):
DSN=[pc963];UID=scott;PWD=tiger
OpenLink: RPC: Unknown host
[OpenLink][ODBC]RPC: Unknown host, SQLSTATE=08004
[OpenLink][ODBC]Connection rejected by data source,
SQLSTATE=08004
Any ideas as to what may be the problem.
--- Andrew Hill <[EMAIL PROTECTED]> wrote:
> Toni,
>
> You need to enter a string of the syntax:
>
> DSN=[name of your dsn]
>
> Since nothing shows up with a "?" I bet you haven't
> set your ODBCINI
> environment variables.
> Running the openlink.sh against the current shell
> should do this: .
> openlink.sh
> If you are doing it by hand, you need to set:
> ODBCINI (pointing to the odbc.ini)
> ODBCINSTINI (pointitng to the odbcinst.ini)
> LD_LIBARARY_PATH (pointing to the lib directory that
> contains the
> libiodbc.so file)
>
> DSNs need to be configured in the odbc.ini
>
> Best regards,
> Andrew Hill
> Director of Technology Evangelism
> OpenLink Software http://www.openlinksw.com
> Universal Data Access & Data Integration Technology
> Providers
>
> > -----Original Message-----
> > From: toni baker [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, October 26, 2001 11:11 AM
> > To: [EMAIL PROTECTED];
> [EMAIL PROTECTED]
> > Subject: RE: [PHP] php/Oracle db connection
> >
> >
> > When I run odbctest I get the following prompt:
> >
> > OpenLink ODBC Demonstration program
> > This program shows an interactive SQL processor
> >
> > Enter ODBC connect string (? shows list): ?
> >
> > DSN | Description
> >
>
---------------------------------------------------------------
> >
> > Enter ODBC connect string (? shows list):
> >
> > What ODBC connet string should I enter here?
> >
> > Thanks Toni.
> >
> > --- Andrew Hill <[EMAIL PROTECTED]> wrote:
> > > Toni,
> > >
> > > Note the "Unknown host".
> > > Check your odbc.ini for the Host field of the
> DSN
> > > you are using.
> > > Ensure it's resolvable. Try an IP address
> instead
> > > maybe.
> > >
> > > Also, set the variables in the environment and
> see
> > > if your DSN works in
> > > odbctest without PHP in the mix.
> > >
> > > Best regards,
> > > Andrew Hill
> > > Director of Technology Evangelism
> > > OpenLink Software http://www.openlinksw.com
> > > Universal Data Access & Data Integration
> Technology
> > > Providers
> > >
> > > > -----Original Message-----
> > > > From: toni baker [mailto:[EMAIL PROTECTED]]
> > > > Sent: Thursday, October 25, 2001 4:56 PM
> > > > To: [EMAIL PROTECTED]
> > > > Subject: [PHP] php/Oracle db connection
> > > >
> > > >
> > > > I have successfully compiled php with linked
> iODBC
> > > > driver manager as an Apache shared module.
> > > However
> > > > when trying to connect php to the Oracle
> database
> > > I
> > > > get an error. The error and the sample
> connection
> > > > code is below.
> > > >
> > > > Warning: SQL error: [OpenLink][ODBC]RPC:
> Unknown
> > > host,
> > > > SQL state 08004 in SQLConnect in
> > > > /home/httpd/html/ronsdev/putenv.php on line 9
> > > > can not connect to DSN: data1.tsl.state.tx.us
> > > >
> > > > <?
> > > >
> > >
> >
>
putenv("LD_LIBRARY_PATH=/usr/local/src/odbcsdk/lib");
> > > >
> > >
> >
>
putenv("ODBCINSTINI=/usr/local/src/bin/odbcinst.ini");
> > > > putenv("ODBCINI=/usr/local/src/bin/odbc.ini");
> > > > $dsn="data1.tsl.state.tx.us";
> > > > $user="scott";
> > > > $password="tiger";
> > > > $sql="SELECT * FROM scott.emp";
> > > > if($conn_id=odbc_connect("$dsn","","")) {
> > > > echo "connected to DSN: $dsn";
> > > > if($result=odbc_do($conn_id, $sql)) {
> > > > echo "executing '$sql'";
> > > > echo "Results: ";
> > > > odbc_result_all($result);
> > > > echo "freeing result";
> > > > odbc_free_result($result);
> > > > }
> > > > else {
> > > > echo "can not execute '$sql'";
> > > > }
> > > > echo "closing connection $conn_id";
> > > > odbc_close($conn_id);
> > > > }
> > > > else {
> > > > echo "can not connect to DSN: $dsn";
> > > > }
> > > > ?>
> > > >
> > > > Can someone help with this?
> > > > Thanks Toni
> > > >
> > > >
> __________________________________________________
> > > > Do You Yahoo!?
> > > > Make a great connection at Yahoo! Personals.
> > > > http://personals.yahoo.com
> > > >
> > > > --
> > > > PHP General Mailing List (http://www.php.net/)
> > > > To unsubscribe, e-mail:
> > > [EMAIL PROTECTED]
> > > > For additional commands, e-mail:
> > > [EMAIL PROTECTED]
> > > > To contact the list administrators, e-mail:
> > > [EMAIL PROTECTED]
> > > >
> > > >
> > > >
> > >
> > >
> > >
> > > --
> > > PHP General Mailing List (http://www.php.net/)
> > > To unsubscribe, e-mail:
> > > [EMAIL PROTECTED]
> > > For additional commands, e-mail:
> > > [EMAIL PROTECTED]
> > > To contact the list administrators, e-mail:
> > > [EMAIL PROTECTED]
> > >
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Make a great connection at Yahoo! Personals.
> > http://personals.yahoo.com
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail:
> [EMAIL PROTECTED]
> > For additional commands, e-mail:
> [EMAIL PROTECTED]
> > To contact the list administrators, e-mail:
> [EMAIL PROTECTED]
> >
> >
> >
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail:
> [EMAIL PROTECTED]
> For additional commands, e-mail:
> [EMAIL PROTECTED]
> To contact the list administrators, e-mail:
> [EMAIL PROTECTED]
>
__________________________________________________
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
