perl dbi driver for microsoft sql?

[gavino]

where do i find dbi driver for micrsoft sql?

 

[Paul Lalli]

where do i find dbi driver for micrsoft sql?

The same place you find all Perl Modules - http://search.cpan.org

Is
http://search.cpan.org/~jwied/Msql-Mysql-modules-1.2219/mysql/lib/DBD/mysql.pm
what you're looking for?

Paul Lalli

 

[Sherm Pendley]

The same place you find all Perl Modules - http://search.cpan.org

Quite right.

Is
http://search.cpan.org/~jwied/Msql-Mysql-modules-1.2219/mysql/lib/DBD/mysql.pm
what you're looking for?

Actually, no. mSQL is not Microsoft SQL Server, it's a different product:

<http://www.hughes.com.au/products/msql/>

I couldn't find a MS-SQL specific DBD module - I think most people use
DBD::ODBC.

sherm--

 

[Paul Lalli]

Actually, no. mSQL is not Microsoft SQL Server, it's a different product:

<http://www.hughes.com.au/products/msql/>

Whoops. Sorry about that. Thanks for the catch, Sherm.

Paul Lalli

 

[MarkRat]

Quite right.


Actually, no. mSQL is not Microsoft SQL Server, it's a different product:

<http://www.hughes.com.au/products/msql/>

I couldn't find a MS-SQL specific DBD module - I think most people use
DBD::ODBC.

You can also use DBD::ADO or DBD::Sybase to connect to MS SQL databases.

 

[Ben Morrow]

Quite right.


Actually, no. mSQL is not Microsoft SQL Server, it's a different product:

<http://www.hughes.com.au/products/msql/>

I couldn't find a MS-SQL specific DBD module - I think most people use
DBD::ODBC.

I've had success in the past using DBD::Sybase (it took me a long time
to figure that one out). AFAIK, this is the only way to connect to MSSQL
from a non-MS machine (which I needed to do at the time).

Ben

 

[Sherm Pendley]

I've had success in the past using DBD::Sybase

I hesitated to mention it, because a quick glance at the docs mentioned only
a few specific versions of MS-SQL, and was in general not very confidence-
inspiring. I'll keep it in mind in the future.

(it took me a long time to figure that one out)

Yeah, it's not very obvious unless you know the history. As I understand it,
MS-SQL is more or less a fork of Sybase, so that the network protocol is more
or less the same.

AFAIK, this is the only way to connect to MSSQL
from a non-MS machine (which I needed to do at the time).

Another approach would be to set up a DBD:roxy server on the Windows box
that's running MS-SQL, and connect to that from just about anything. I've
gotten good results with that approach in the past - although I was writing
for "classic" MacPerl clients connecting to a MySQL server on Solaris.

sherm--

 

[Brian Helterline]

where do i find dbi driver for micrsoft sql?

You need the ODBC driver to connect to MS SQL

http://search.cpan.org/search?query=ODBC&mode=all

-brian

 

[John Bokma]

where do i find dbi driver for micrsoft sql?

http://www.google.com/search?q=site:johnbokma.com+odbc

If you're going to use LWP::UserAgent as well, read the second link in
that result.

 

[gavino]

Quite right.


Actually, no. mSQL is not Microsoft SQL Server, it's a different product:

<http://www.hughes.com.au/products/msql/>

I couldn't find a MS-SQL specific DBD module - I think most people use
DBD::ODBC.

sherm--

how id DBD::ODBC set up?
I was trying sybase and freeTDS and have headache

 

[gavino]

Quite right.


Actually, no. mSQL is not Microsoft SQL Server, it's a different product:

<http://www.hughes.com.au/products/msql/>

I couldn't find a MS-SQL specific DBD module - I think most people use
DBD::ODBC.

sherm--

HOW?

 

[Sherm Pendley]

how id DBD::ODBC set up?

What have you tried? What was the result? Is there some part of the
documentation you're having trouble with?

sherm--

 

[John Bokma]

By first creating a workable ODBC client environment on your system
and then installing the DBD::ODBC module. Then you can use the
facilities of the DBI module to access your database through the ODBC
layer.

Odd, I never did the client environment thingy. I installed the Desktop
edition (MSDE?) of MS SQL (the free version) and IIRC it worked out of the
box when I installed DBD::ODBC:


use DBI;

my $dbh = DBI->connect(

"dbi:ODBC:driver={SQL Server};"
. "Server=$ENV{ COMPUTERNAME };database=SomeDataBaseName;",
'',
'',
{
RaiseError => 1,
AutoCommit => 1
}
);

has been quite some time, but I can't recall any kind of magic required