Gossamer Forum
Home : General : Perl Programming :

Accessing MS-SQL with Perl

Quote Reply
Accessing MS-SQL with Perl
I've looked everywhere but can't find out how to do it. I must be brain dead or something.

Anyway, I'm running windows and MS-SQL 7.0 and need to access the databases with perl. I don't know how to do it.

Thank you so much

Quote Reply
Re: Accessing MS-SQL with Perl In reply to
Basically, you have to identify the appropriate driver in your Perl scripts.

The reason that there are very few MS SQL Server/Perl scripts is that running ASP or Cold Fusion is more efficient in Windows servers that have MS SQL Server installed.

BTW: LINKS SQL does work with MS SQL Server among other database storage applications, like Oracle.

Regards,

Eliot Lee Wink
http://anthrotech.com/
Quote Reply
Re: Accessing MS-SQL with Perl In reply to
Thanks for you, but what is the driver in my perl script.

I have perl application made for mysql and want to put it on my system with mssql already running. I thought it would be stupid to have both installed and running.

What do you guys think?

Quote Reply
Re: Accessing MS-SQL with Perl In reply to
Hi,

You need to install DBD::ODBC perl module. Then, you need to add an ODBC data soure (in the control panel), and use that as the database name.

Hope that helps,

Alex

--
Gossamer Threads Inc.