Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Authentication via COM
Message
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
SQL Authentication via COM
Miscellaneous
Thread ID:
00647016
Message ID:
00647016
Views:
43
Is there any way to use the clients NT authentication to create a COM object on a different server, then have the COM object log into SQL server using the clients NT id.

Here's an example of what I'm trying to do from the COM server.
loConnection = CREATEOBJECT('ADODB.Connection')

WITH loConnection
	.Provider = 'SQLOLEDB'
	.Properties("Data Source").Value 		= 'BDGGISDEV'
	.Properties("Initial Catalog").Value	= 'bdggis'
	.Properties("Integrated Security").Value= "SSPI"	
	.Open()
ENDWITH
Thanks in advance
Next
Reply
Map
View

Click here to load this message in the networking platform