Re: different environment fails to fill a dataset

Andrew:
Well I recreated the login but it didn't make any difference. The form that
didn't work before still doesn't work and the forms that did work before
still work. Any other suggestions ?

Randy


"Andrew J. Kelly" wrote:

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: problem to connect sql server 2005 from localhost (W2k3)
    ... Andrew J. Kelly SQL MVP ... Solid Quality Mentors ... It's possible to connect the sql server via telnet? ...
    (microsoft.public.sqlserver.connect)
  • Re: different environment fails to fill a dataset
    ... You might have lost the relationship of the Login to the user in the db. ... 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: limit connections option
    ... individual users or dbs within a single SQL Server app. ... > Thanx Andrew, is there any other way or tools to limit data trasnfer. ... >> Andrew J. Kelly SQL MVP ... >>> This is a shared server with 150 databases belonging to different ...
    (microsoft.public.sqlserver.tools)
  • Re: different environment fails to fill a dataset
    ... can't access the SQL Server and the Resources winform can access SQL Server ... They both work fine on my development workstation. ... Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.clients)