[unixODBC-support] can not connect through php

jwan at ea.ucla.edu jwan at ea.ucla.edu
Fri Apr 23 02:17:02 BST 2010


forgot to mention that when I load the php page, the error as follow:

odbc_connect() [function.odbc-connect<https://eeweb.ee.ucla.edu/test/function.odbc-connect>]:
SQL error: [unixODBC][FreeTDS][SQL Server]Unable to connect to data source,
SQL state S1000 in SQLConnect

On Thu, Apr 22, 2010 at 6:01 PM, <jwan at ea.ucla.edu> wrote:

> Thank, I did not install the gui, how do I enable the driver manger
> logging?
>
> I found out that even though I can connect using osql, but it has some
> error before I am able to connect to.  After I connect, I was not able to
> read the same thing as I can from isql.  Can you please help?
>
> -bash-3.2$ ./osql -S srdbDSN -U elengr -P kkxx1555
> osql: error: /@.8 (from isql) is not a directory!
> isql strings are:
> + /@.8
> + /@.8
> + /@.8
> + /@.8
> ./osql: line 88: return: can only `return' from a function or sourced
> script
> looking for odbc.ini and odbcinst.ini in /@.8
>         reading "/u1/ee/eeweb/.odbc.ini"
> [srdbDSN] found in "/u1/ee/eeweb/.odbc.ini"
> found this section:
>         [srdbDSN]
>         Driver = /u1/ee/eeweb/freetds/lib/libtdsodbc.so
>         Description = Microsoft SQL Server
>         Trace = Yes
> .................................
>
>
>
>
> On Thu, Apr 22, 2010 at 12:19 PM, Nick Gorham <nick.gorham at easysoft.com>wrote:
>
>>  jwan at ea.ucla.edu wrote:
>>
>>> Hi  I have install freetds with unixODBC.  I have tsql and isql connect
>>> to the database fine.  With isql, I can see all the database objects that I
>>> have access to.
>>> My problem right now is I can not connect to this Microsoft SQL server
>>> through php.  I have the odbc.so installed previously with LAMP (apache2 and
>>> php5).  I have added the line in php.ini, extension=odbc.so, restart the
>>> apache server.  Now I still have the following error:
>>> SQL error: [unixODBC][FreeTDS][SQL Server]Unable to connect to data
>>> source, SQL state S1000 in SQLConnect in /w/web.02/...
>>>  Any idae?
>>>  Thanks
>>>  Jun
>>>
>>>
>> I would enable driver manager logging and see how the connect differs from
>> isql.
>>
>> --
>> Nick
>> _______________________________________________
>> unixODBC-support mailing list
>> unixODBC-support at mailman.unixodbc.org
>> http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.unixodbc.org/pipermail/unixodbc-support/attachments/20100422/40cd2bdb/attachment.html>


More information about the unixODBC-support mailing list