[ale] Linux connecting to MS SQL

[Jeb Barger]

I will try it tomorrow.  This seems the simplest solution.

Thanks All

Christopher Bergeron wrote:

> Have you compiled php with ms-sql support?  If so, you should be able to 
> just use "mysql-like" function calls:
> 
> Ex:
> mysql_connect("host","uid","pwd");
> would be
> mssql_connect("host","uid","pwd");
> 
> it looks pretty ubiquitous, but I haven't used it personally (yet).
> 
> Best regards,
> Chris Bergeron
> Dashwerks, Inc.
> 
> 
> 
> Greg Freemyer wrote:
> 
>> On Mon, 2004-09-13 at 19:01, Jeb Barger wrote:
>>  
>>
>>> Ok, I was working on this most of the day today, and there has got to be
>>> a better way.
>>>
>>>
>>> I am converting a webapp to Mandrake 10 using php, however, it still
>>> needs to connect to the microsoft sql server.  Is there an easy way to
>>> do this?  Articles I have read, suggest using a piece that converts the
>>> odbc connection to xml, and using php to connect that way.  I am new to
>>> linux, and I know there has to be a better way.  Any suggestions?
>>>
>>> Jeb
>>>
>>>   
>>
>> I don't know the how to do it from PHP, but I know we have it working
>> from Java on SUSE to MS SQL.  We bought a JDBC connector for a few
>> hundred dollars.  It is a native Java type 4 driver, so it will run in
>> any compatible JVM (ie. it is OS independent), including the one that
>> comes with SUSE.
>>
>> So if no one else has any ideas, you could write some JSP code to link
>> to a Java type 4 JDBC driver.  Then somehow invoke the JSP logic.
>>
>> FYI: we bought the Sprinta JDBC driver from inetsoftware:
>>
>>     http://www.inetsoftware.de/
>>
>> Greg
>> -- 
>> Greg Freemyer
>>
>>
>> _______________________________________________
>> Ale mailing list
>> Ale at ale.org
>> http://www.ale.org/mailman/listinfo/ale
>> .
>>
>>  
>>
> 
> _______________________________________________
> Ale mailing list
> Ale at ale.org
> http://www.ale.org/mailman/listinfo/ale
>