RDC With OLE DB (SQL Server 2000) 1

[pemarsh9999]

I'm trying to logon to a SQL Server database using the
RDC Application.LogOnServer or LogOnServerEx methods.
I need to do it using the SQL OLE DB driver, but the
documentation regarding the parameters for this call
is next to useless. Has anyone attempted this???

I was managing it before quite happily using the native
drivers, but I've had to swap to OLE DB for a number
of reasons. As far as I can make out it seems to be a
difference in the way you pass the uid and password
information. ( I'm using Standard Security in SQL Server
by the way). Any information or pointers to documentation
would be gratefully received.

Thanks in advance,
Paul.

 

[balves]

There's a Crystal support document that says the OLE DB driver and .LogonServer do not work together. Sorry.

http://support.crystaldecisions.com/kbase/c2006666.asp?AJID=9144C71E99F0CA4E894258171967B5EF

I would still pick the OLE DB driver as the data source and just use .SetLogonInfo instead.