Web Service and VB6 COM Object using ADO 2.6

[Kumar]

I have a VB 6 COM object that uses ADO 2.6 to connect to a database. I have
a Web Service that references this COM object and calls a method in this
objects that uses ADO 2.6 to connect. The Web Service gives the error
"connected[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist
or access denied."

I am using Windows Integrated Security. The connection string looks like
this: "Provider=SQLOL EDB; Data Source=serverna me;Initial
Catalog=dbname; Integrated Security=SSPI;p ersist security
info=False;Trus ted_Connection= Yes"

Is there anything that I need to change in web.config? Do I have to move to
ADO.NET?

I have the following in web.config:

<authenticati on mode="Windows" />

<identity impersonate="tr ue"/>

Thanks,

Kumar

[Sam Santiago]

You might want to try logging in as an explicit user so that you can narrow
down whether it's an authentication problem or a connectivity problem. Is
SQL Server on the same machine as IIS? That is a requirement to use
integrated security. Check out this link:

Accessing SQL Server Using Windows Integrated Security
http://msdn.microsoft.com/library/de...edsecurity.asp
Thanks,

Sam

--
_______________ _______________ _
Sam Santiago
ss*******@n0spa m-SoftiTechture.c om
http://www.SoftiTechture.com
_______________ _______________ _
"Kumar" <ku***@nospam.i nteramerica.com > wrote in message
news:%2******** ********@TK2MSF TNGP11.phx.gbl. ..

I have a VB 6 COM object that uses ADO 2.6 to connect to a database. I have a Web Service that references this COM object and calls a method in this
objects that uses ADO 2.6 to connect. The Web Service gives the error
"connected[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist
or access denied."

I am using Windows Integrated Security. The connection string looks like
this: "Provider=SQLOL EDB; Data Source=serverna me;Initial
Catalog=dbname; Integrated Security=SSPI;p ersist security
info=False;Trus ted_Connection= Yes"

Is there anything that I need to change in web.config? Do I have to move to ADO.NET?

I have the following in web.config:

<authenticati on mode="Windows" />

<identity impersonate="tr ue"/>

Thanks,

Kumar

[Kumar]

Thanks for pointing me in that direction. I figured it out.

Kumar

"Sam Santiago" <ss*******@n0sp am-SoftiTechture.c om> wrote in message
news:Oo******** ******@TK2MSFTN GP10.phx.gbl...

You might want to try logging in as an explicit user so that you can narrow down whether it's an authentication problem or a connectivity problem. Is SQL Server on the same machine as IIS? That is a requirement to use
integrated security. Check out this link:

Accessing SQL Server Using Windows Integrated Security
http://msdn.microsoft.com/library/de...edsecurity.asp

Thanks,

Sam

--
_______________ _______________ _
Sam Santiago
ss*******@n0spa m-SoftiTechture.c om
http://www.SoftiTechture.com
_______________ _______________ _
"Kumar" <ku***@nospam.i nteramerica.com > wrote in message
news:%2******** ********@TK2MSF TNGP11.phx.gbl. ..

I have a VB 6 COM object that uses ADO 2.6 to connect to a database. I

have

a Web Service that references this COM object and calls a method in this
objects that uses ADO 2.6 to connect. The Web Service gives the error
"connected[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied."

I am using Windows Integrated Security. The connection string looks like
this: "Provider=SQLOL EDB; Data Source=serverna me;Initial
Catalog=dbname; Integrated Security=SSPI;p ersist security
info=False;Trus ted_Connection= Yes"

Is there anything that I need to change in web.config? Do I have to move

to

ADO.NET?

I have the following in web.config:

<authenticati on mode="Windows" />

<identity impersonate="tr ue"/>

Thanks,

Kumar