Perl and microsoft sql server

I heard that a very powerful boss came. He left his last company and his salary has reached the medium level. Notes on how to configure your system to connect to a SQL server with Perl 2 stars 0 forks. Branches Tags. Could not load branches. Could not load tags. Latest commit. Git stats 5 commits. Failed to load latest commit information.

View code. Additional links that helped me get this running: Author, Copyright and License. Active 1 year, 7 months ago. Viewed 51k times. Improve this question. John Saunders k 25 25 gold badges silver badges bronze badges. Bharanikumar Bharanikumar Add a comment. Active Oldest Votes. Improve this answer.

Secondly it is not exactly correct to say everything after 'dbi:ODBC' is passed to the driver and certainly not the database. Hope it is more correct now. For example:. Refer to the following example to see what you need to install on your client and server machines:.

This is the machine where you want to run your Perl. You need to have installed:. This is the machine where you have or can install an ODBC driver for the database you want to access. The data source tells the driver manager which ODBC driver to load and which connection attributes to use.

You do not have to create data sources, as DSN-less connections provide an alternative way to connect, and you will find details on this in the first tutorial. We will describe these attributes in the following sections. This is sometimes called trusted connections. In this scenario, MS SQL Server requires a database user name and password that your database administrator will have set up.

At this stage, an example might help illustrate SQL Server authentication. Your database administrator has set up the SQL Server instance with SQL Server authentication active, and has set you up an account for the database with username "dbuser" and password "dbpassword". This is not the port your database engine is listening on. Separate the server machine from the port with a colon : in the ServerPort attribute value.

Then test that you can access your data source from Perl. All rights reserved.