in reply to Re: 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

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.
  • Comment on Re: Re: Re: How can I add a Domain into the UserName of a Provider String using Win32::OLE
  • Download Code

In Section Seekers of Perl Wisdom