Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: Walid Moghrabi on August 02, 2002, 01:58:16 PM

Title: Connect an MSSQL db via ODBC from SME
Post by: Walid Moghrabi on August 02, 2002, 01:58:16 PM

Hi,

We are working with a big Win2k box there and MSSQL 2000 as db server for our business.
I am trying to build an Extranet server using e-smith (it does the job just great for that and many other things) but I need to connect to my MSSQL server and for that, I would really prefer using ODBC which is very simple to use and which will help me make my code as portable as possible ...

Does anybody has any information on how to setup and odbc link from within Linux/SME ?

I don't mean accessing the SME db from a Win box but the contrary.

Thank you in advance.

A+

Title: Re: Connect an MSSQL db via ODBC from SME
Post by: Darius Zanganeh on August 03, 2002, 04:27:29 AM

What are you using to create your extranet?  Look up DSN-less connections for that product like dreamweaver etc..

Title: Re: Connect an MSSQL db via ODBC from SME
Post by: Walid Moghrabi on August 05, 2002, 12:46:36 PM

Darius Zanganeh wrote:
>
> What are you using to create your extranet?  Look up DSN-less
> connections for that product like dreamweaver etc..

I am using the SME box as my Extranet with Apache/PHP and I want to connect to a MS SQL Server using an ODBC link because of portability and simplicity (and also because I can't find a f****g already compiled mssql.so for PHP as it is not supplied with SME 5.5 ...)

This what I asked for, don't tell me not to use DSN stuff as it is what I need to use, just tell me if it is possible with SME or not,  and if it is possible, just tell me how, that's all I want.

Thanks.

Title: Re: Connect an MSSQL db via ODBC from SME
Post by: Darius Zanganeh on August 05, 2002, 09:35:59 PM

Use Dream weaver MX with PHAkt to create the PHP pages and connections to the database, Upload pages and all should work fine.  As the SME 5.5 comes with PHP abilities.

Title: Re: Connect an MSSQL db via ODBC from SME
Post by: Darius Zanganeh on August 05, 2002, 09:39:20 PM

YOU DON"T HAVE TO USE DSN AND IN FACT IT WILL SLOW DOWN YOUR PAGES!!!  GO HERE FOR MORE INFO>
http://php.weblogs.com/odbc

Title: Re: Connect an MSSQL db via ODBC from SME
Post by: Craig on October 11, 2002, 01:28:56 PM

Walid

This may be of some help to you.

You can use Perl DBD::Sybase module with TDS (Tabular Data Stream) libraries to connect to a M$ SQL 2000 server. When compiled and configured correctly you will be able to connect to the SQL server and query away using perl scripts.

If this is what you are trying to acheive then let me know and I will emails you off list that article on how to get this working on a standard Redhat 7.1/7.2 system. You may have to modify the document to work with SME.

Hope this helps.

Regards
Craig