Topic: Connect an MSSQL db via ODBC from SME

[Walid Moghrabi]

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+

[Darius Zanganeh]

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

[Walid Moghrabi]

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.

[Darius Zanganeh]

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.

[Darius Zanganeh]

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

[Craig]

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