Re: different environment fails to fill a dataset

Are you sure that the login on the Test system has the database Planit as
one that it has access to and you have the correct permissions in that db
for that user to do what you want? I would drop the user and the login on
the system that is not working and then re-add the Login ensuring it has all
the right permissions in that db. If that doesn't work then I don't know
what to tell you.

--
Andrew J. Kelly SQL MVP


"rseedle" <rseedle@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1C22B152-8C84-43EE-852B-4352FBDEDB9D@xxxxxxxxxxxxxxxx
Andrew:
These are the connection strings. Effects is the data form that has
problems
on the test workstation but not my development station. Resources is a
data
form which which works correctly on both workstations.

Effects - development workstation
Provider=SQLOLEDB;Integrated Security=SSPI;Packet Size=4096;Data
Source=Randy-Other\RSeedle;Initial Catalog=Planit

Resources - development workstation
Provider=SQLOLEDB;Integrated Security=SSPI;Packet Size=4096;Data
Source=Randy-Other\RSeedle;Initial Catalog=Planit


Effects - test workstation
Provider=SQLOLEDB;Integrated Security=SSPI;Packet Size=4096;Data
Source=(local);Initial Catalog=Planit

Resources - test workstation
Provider=SQLOLEDB;Integrated Security=SSPI;Packet Size=4096;Data
Source=(local);Initial Catalog=Planit

I did check, there is a semicolon after the "Initial Catalog=Planit". Its
just outside of the string.

Also I have stepped through this code on my development workstation
multiple
times. It never fails. I haven't got a debugger on the test workstation.
Too
bad there isn't just a very minimal debugger that I could put on the test
workstation.

Randy

"Andrew J. Kelly" wrote:

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
    ... 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)