[Cialug] odbc_connect

Adam Hill adam at diginc.us
Wed Apr 26 16:59:37 CDT 2017


What does odbc_connect do?  error out?

Have you tried this function to list data sources
http://php.net/manual/en/function.odbc-data-source.php ?  which I believe
should match your odbc.ini if it were reading from there.

On Wed, Apr 26, 2017 at 4:45 PM L. V. Lammert <lvl at omnitec.net> wrote:

> FYI, .. isql DOES connect properly:
>
> $ isql WebVam
> +---------------------------------------+
> | Connected!                            |
> |                                       |
> | sql-statement                         |
> | help [tablename]                      |
> | quit                                  |
> |                                       |
> +---------------------------------------+
> SQL> SELECT * FROM rem_pswd
>
> +-----------+-----------+-------------------------------+-----------+-----------+-----------+---------+
> | CCUSTNO   | CPASSWORD | CFULLNAME                     | LINVCASCII|
> NSUBSTATN | HMO_CUST  | CAP_CUST|
>
> +-----------+-----------+-------------------------------+-----------+-----------+-----------+---------+
> | 6369391400 <(636)%20939-1400>|      NOTSO| System Supervisor
>  |           | 0         |           |         |
> |     129356|     CONNIE| Connie England                |           | 0
>      |           |         |
> |     129345|     MORGAN| MARCY DICKSON                 |           | 0
>      |           |         |
> |     129345|      CATHY| CATHY BUSALACHI               | 0         | 0
>      |           |         |
>
> Any thoughts on why isql would work whereas odbc_connect does not?
>
>         TIA!
>
>         Lee
> _______________________________________________
> Cialug mailing list
> Cialug at cialug.org
> http://cialug.org/mailman/listinfo/cialug
>


More information about the Cialug mailing list