Re: different environment fails to fill a dataset

What exactly is different about that form from the rest? Have you tried
running profiler to see what is actually happening on the sql server side?

--
Andrew J. Kelly SQL MVP


"rseedle" <rseedle@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:51D13828-57D3-4375-9F6B-AA23BC9C738C@xxxxxxxxxxxxxxxx
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: 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: 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
    ... 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: 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)
  • Re: Determine Disk Block Size ?
    ... As always, thanks Andrew. ... Most of the documentation for 2000 is wrong in that it may state you need multiple files to spawn multiple threads. ... >> The MS SQL Server Operations Manual makes a recommendation of using 64-KB>> cluster sizes. ... We have done so with a dramatic total disk I/O>> throughput. ...
    (microsoft.public.sqlserver.server)