Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot
 
PerlMonks  

Re: Re: Re: Connecting to a MS SQL 2k Server

by dragonchild (Archbishop)
on Jul 24, 2003 at 22:13 UTC ( [id://277715]=note: print w/replies, xml ) Need Help??


in reply to Re: Re: Connecting to a MS SQL 2k Server
in thread Connecting to a MS SQL 2k Server

To communicate with a database, you have to have a client that speaks that database's language. The various DBD:: modules communicate with those clients. The model looks something like:
Perl code <-> DBI <-> DBD:: <-> Database client <-> Database
In other words, if they want to connect to database XYZ, they have to have the client for XYZ installed and the appropriate DBD::. Then, you have to support XYZ's connection string.

Those connection strings do differ between databases, as do the files necessary to support them. For example, DBD::Sybase (which is used to connect from Unix to SQL Server) can use freetds, which uses a file called freetds.conf. However, DBD::Oracle uses an oracle client which requires (usually) a file called tns.ora. It's not as simple as installing the right DBD:: module.

In other words ... either you have to control the database choices on your server or you have to provide a mechanism for people who install your stuff to be able to connect to their DB of choice. Good luck! :-)

------
We are the carpenters and bricklayers of the Information Age.

Don't go borrowing trouble. For programmers, this means Worry only about what you need to implement.

Please remember that I'm crufty and crochety. All opinions are purely mine and all code is untested, unless otherwise specified.

Replies are listed 'Best First'.
Re: Re: Re: Re: Connecting to a MS SQL 2k Server
by Eagle_f90 (Acolyte) on Jul 24, 2003 at 22:17 UTC
    We are controlling the choices, they will only be able to connect databases we allow them to, so far it is a flatfile and mySQl databes, I am working on the MS SQL 2k database. I have created scripts to connect though the ODBC and the ADO but want to creat a script that does not use thouse, I know in ASP you can do it (it's called a DNS-less connection). And was hoping that there is something like that in perl.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://277715]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others examining the Monastery: (4)
As of 2024-04-25 16:31 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found