Connecting to SQL Server with a VB6 DLL with Windows Authentication

Hi,

I am running a VB.net web service which connects to SQL Server while at the same time referencing a DLL created in VB6 that also attempts to connect to the same SQL Server (using a separate ADO connection).  For security reasons I need to use Windows integrated security on the SQL Server.

My .net connection string to connect is as follows:

"provider=sqloledb;Data Source=localhost;Initial Catalog=databasename;Integrated Security=SSPI;"

Everything works fine until I reach a point where I try to connect to the database with the VB6 DLL.  I have tried a various number of connection strings but usually get the "Data source name not found and no default driver specified" error.

Is it even possible to connect with the DLL using Windows authentication?  I am wondering if the DLL cannot properly pass the web service authentication to the database....Start Free Trial