Re: different environment fails to fill a dataset

You might have lost the relationship of the Login to the user in the db. It
may be able to connect but not get to the db itself. Try dropping the login
and readding it making sure to specify the database access when you do.

--
Andrew J. Kelly SQL MVP


"rseedle" <rseedle@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:58084FB0-43E4-480D-B328-E2633EEF4CCE@xxxxxxxxxxxxxxxx
I am using "Integrated Security=SSPI;" (Windows login info) in all of the
connection strings used in the various forms. Will it still be necessary
to
do something with sp_change_users_login ?

Randy

"Andrew J. Kelly" wrote:

Did you resync the logins to the users in that db after you attached it?
If
not check out sp_change_users_login in BooksOnLine.

--
Andrew J. Kelly SQL MVP


"rseedle" <rseedle@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C298B6AF-C57D-40EE-905C-CB50F29126F3@xxxxxxxxxxxxxxxx
I have a C# client application that uses SQL Server as a backend. It
works
fine on my development workstation. But when I moved it to another test
workstation four out of the five winforms worked fine but one doesn't.
The
one that doesn't can open the connection and return the server version
as
a
test of whether the open worked right. I does. But when you run the
oledbadapter.fill command to fill the dataset it fails. It acts as if
it
can't open the server. Further reading shows that the fill command can
actually open a connection on its own if necessary without the open
command.
Is there anything in the environment or SQL Server that could be
causing
this
rejection. The SQL Server database was detached, copied, and then
reattached
on the test workstation. SO it should be a duplicate.

Randy





.

Relevant Pages

  • Re: different environment fails to fill a dataset
    ... successfully ran the select command with no problems. ... Andrew J. Kelly SQL MVP ... Is there anything in the environment or SQL Server that could be ...
    (microsoft.public.sqlserver.clients)
  • Re: different environment fails to fill a dataset
    ... Well I recreated the login but it didn't make any difference. ... Andrew J. Kelly SQL MVP ... Is there anything in the environment or SQL Server that could be ...
    (microsoft.public.sqlserver.clients)
  • Re: different environment fails to fill a dataset
    ... Andrew J. Kelly SQL MVP ... oledbadapter.fill command to fill the dataset it fails. ... Is there anything in the environment or SQL Server that could be ...
    (microsoft.public.sqlserver.clients)
  • Re: restore a bakup database on MSDE
    ... OSQL:- MSDE comes with command line utility OSQL. ... > login to SQL Server and execute any TSQL command. ...
    (microsoft.public.sqlserver.msde)
  • Re: Drop User Command
    ... In SQL Server you will be having Login and Users. ... Command to drop Login ...
    (microsoft.public.sqlserver.mseq)