Re: different environment fails to fill a dataset

Are you sure the connection string are identical? Do they specify a catalog
(default database)? If not you may want to add it to the connection string
to ensure it is pointing to the correct db after it connects. Have you
tried stepping thru the code with the debugger?

--
Andrew J. Kelly SQL MVP


"rseedle" <rseedle@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7468B2A8-98A0-4E7E-9239-B90303EEEA5F@xxxxxxxxxxxxxxxx
Andrew:
All the forms are data forms generated by Visual Studio using C#. The
difference between them is that they access/update a different tables
within
a single database. All the connection strings in all the forms are the
same.

I ran the profiler as requested. The one data form that doesn't work never
runs the select command. As if it never got it to begin with while the
others
successfully ran the select command with no problems. I could email the
trace
files to you if it would help you understand this better.

Randy

"Andrew J. Kelly" wrote:

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: Performance really poor if calling data from sql clients
    ... Andrew J. Kelly SQL MVP ... The TCP connection is running from the client ... On a computer running the test which is not the database hosting ...
    (microsoft.public.sqlserver.clients)
  • Re: Performance really poor if calling data from sql clients
    ... Andrew J. Kelly SQL MVP ... The TCP connection is running from the client ... On a computer running the test which is not the database hosting ...
    (microsoft.public.sqlserver.clients)
  • Re: Fill Factor
    ... Well the only way it would go back to 90 is if someone or something is reindexing with a different fill factor. ... Andrew J. Kelly SQL MVP ... > database, i deployed a database to a client and sit the Fill Factor for ...
    (microsoft.public.sqlserver.setup)
  • Re: DataBase
    ... Andrew J. Kelly SQL MVP "Andrew J. Kelly" wrote in message ... Sorry I don't know anything about> dbase being supported with windows other than there are odbc and possibly> oledb drivers for it now, ... What I actually need to>> know>>>> is it posible to create this as a database and create tables in it, ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: different environment fails to fill a dataset
    ... Are you sure that the login on the Test system has the database Planit as ... Andrew J. Kelly SQL MVP ... on the test workstation but not my development station. ...
    (microsoft.public.sqlserver.clients)