problem in calling a sp using sql native client provider for SQLServer 2005

i am facing a problem in calling a sp using sql native client
provider for SQL Server 2005. I have a stored procedure which return
some rows as output. I am calling this sp through my vb application
using "DSN=MyDSN; UID=MyUID; PWD=MyPWD" as connection string, in this
case i am getting output (row returned from sp). But if i change the
connection string and used sql native client provider (Provider :
SQLNCLI.1) and specifying server, database name, by calling same sp i
am not getting any output.
Please note here that the sp has some insert/delete/update statement
before the last select and return statement.

can somebody tell, if anything needs to be modified in connection
string, so that above problem will get solved.

Regards,
Sandip

What .NET library are you using to connect? Are you using
System.Data.SqlClient?

Chuck Heinzelman

"sandip patil" wrote in message
news:3f44d801-2b70-4516-851e-7a1981dba6c0-at-u36g2000prf.googlegroups.com...
> i am facing a problem in calling a sp using sql native client
> provider for SQL Server 2005. I have a stored procedure which return
> some rows as output. I am calling this sp through my vb application
> using "DSN=MyDSN; UID=MyUID; PWD=MyPWD" as connection string, in this
> case i am getting output (row returned from sp). But if i change the
> connection string and used sql native client provider (Provider :
> SQLNCLI.1) and specifying server, database name, by calling same sp i
> am not getting any output.
> Please note here that the sp has some insert/delete/update statement
> before the last select and return statement.
>
> can somebody tell, if anything needs to be modified in connection
> string, so that above problem will get solved.
>
> Regards,
> Sandip

Check http://www.connectionstrings.com/ may shed some light on different
types of options you can try. I also alwasy use SET NOCOUNT ON so that rows
returned never interferes with my recordset.

- Rich


"Chuck Heinzelman" wrote:

> What .NET library are you using to connect? Are you using
> System.Data.SqlClient?
>
> Chuck Heinzelman
>
> "sandip patil" wrote in message
> news:3f44d801-2b70-4516-851e-7a1981dba6c0-at-u36g2000prf.googlegroups.com...
> > i am facing a problem in calling a sp using sql native client
> > provider for SQL Server 2005. I have a stored procedure which return
> > some rows as output. I am calling this sp through my vb application
> > using "DSN=MyDSN; UID=MyUID; PWD=MyPWD" as connection string, in this
> > case i am getting output (row returned from sp). But if i change the
> > connection string and used sql native client provider (Provider :
> > SQLNCLI.1) and specifying server, database name, by calling same sp i
> > am not getting any output.
> > Please note here that the sp has some insert/delete/update statement
> > before the last select and return statement.
> >
> > can somebody tell, if anything needs to be modified in connection
> > string, so that above problem will get solved.
> >
> > Regards,
> > Sandip
>
>
>