Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change

Re^5: connecting Perl with MS SQL Server on NT using ODBC

by poj (Monsignor)
on Dec 29, 2011 at 17:40 UTC ( #945534=note: print w/replies, xml ) Need Help??

in reply to Re^4: connecting Perl with MS SQL Server on NT using ODBC
in thread connecting Perl with MS SQL Server on NT using ODBC

Different error

SQL Server does not exist or access denied.

I suggest using Control Panel / Administrative Tools / ODBC Data Source Administrator to test your connection parameters


Replies are listed 'Best First'.
Re^6: connecting Perl with MS SQL Server on NT using ODBC
by Secalles (Initiate) on Dec 29, 2011 at 17:47 UTC

    I open it and i have no Data Source configured here.

    I configured a SQL Server called MSSQL (in System DSN) and it worked ( the test was successful )and i'm still getting "access denied"

    Should i change my code?

      Yes, it should use that System DSN with this

      my $DBH = DBI->connect("DBI:ODBC:MSSQL",$user,$pass) or die "Couldn't +open database: $DBI::errstr\n";
        Thanks it returned no error!

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://945534]
[LanX]: never liked it, but a friend of my mother was a big "fan" of Mr T xD
[LanX]: (talking about minority chicks)
[LanX]: Hollywood is built on stereotypes which sell, this includes stereotypes about English, French, russians and ... Americans
[Your Mother]: I think to some degree, maybe a large one, the stereotypes are purely products OF Hollywood and not what would sell best.
[LanX]: well those products which sold best are replicated
[Your Mother]: They get almost everything wrong on every level. I think they create and restrict the market and fundamentally misunderstand audiences.
[Your Mother]: Consider how long, for example, superhero movies were kept at bay because they weren't commercially viable. They always were, just Hollywood couldn't see it or understand how to make one because there is no management talent in the town.
[LanX]: Erich von Strohheim built his career on beeing the most hated guy (The man you love to hate)
[Your Mother]: You see these amazing set, costumes, performances, etc, etc, etc all ruined by production and script decisions from the top down.
[LanX]: well ... the traget audiance is 15-25

How do I use this? | Other CB clients
Other Users?
Others exploiting the Monastery: (13)
As of 2018-03-19 14:56 GMT
Find Nodes?
    Voting Booth?
    When I think of a mole I think of:

    Results (240 votes). Check out past polls.