in reply to Re: How can I add a Domain into the UserName of a Provider String using Win32::OLE
in thread How can I add a Domain into the UserName of a Provider String using Win32::OLE

I appreciate your reply. The account is an NT Account, so it requires NT authentication. I can get this to work with a local SQL account (basically the example above)...

The link you provided, while incredibly useful, was the one I originally got help from (and unfortunately mentions nothing about domains in a username).

As for the TCP/IP vs. Names-pipes, I'm not 100% sure what's going on, but I'm pretty sure we need authentication, because this is happening in a company intranet, and the SQL calls being made in the Perl app must be made as a specific NT domain user.

Thanks again for your response, and I hope someone out there has a suggestion on how to connect to the SQL database using an NT domain user.

  • Comment on Re: Re: How can I add a Domain into the UserName of a Provider String using Win32::OLE

Replies are listed 'Best First'.
Re: Re: Re: How can I add a Domain into the UserName of a Provider String using Win32::OLE
by NetWallah (Canon) on May 15, 2004 at 06:38 UTC
    Try adding this to your connection string: 
    "Network Library=DBMSSOCN;"

    [download]
    - "Network Library=DBMSSOCN" tells OLE DB to use TCP/IP rather than Named Pipes (Q238949).

    Include the parameters "UID" and "PWD" when you use ODBC, and "User ID" and "Password" when you use the SQLOLEDB provider.

    Offense, like beauty, is in the eye of the beholder, and a fantasy.
    By guaranteeing freedom of expression, the First Amendment also guarntees offense.
[reply]
[d/l]

In Section Seekers of Perl Wisdom