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

You need to figure out, or specify whether you are using TCP/IP or named-pipes to connect to the SQL server. If named-pipes, and it is Local, you should not need any authentication.

You also need to figure out whether you are using SQL or NT authentication. Only NT authentication requires domain name.

Check this site for assistance with connection strings.

Offense, like beauty, is in the eye of the beholder, and a fantasy.
By guaranteeing freedom of expression, the First Amendment also guarntees offense.

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

Replies are listed 'Best First'.
Re: Re: How can I add a Domain into the UserName of a Provider String using Win32::OLE by Incognito (Pilgrim) on May 14, 2004 at 22:14 UTC
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.	[reply]
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]