Unspecified Error while trying to Generate Dataset

  • Thread starter Thread starter debjani sarkar
  • Start date Start date
D

debjani sarkar

Hi All,
I am requesting all you Gurus for help on this!
In my Visual Studio .NET project, I get "Unspecified Error" when I try to do
"Generate Dataset" or "Preview Data" by right clicking on any
SqlDataAdapter.I am connecting to a Sql Server database lying on the same
box.
This project was working for days and has just stopped working now....and I
am without a clue.I found posting on this error at several places , however
didn't find any answer.
I would appreciate any suggestion/help on this one as I am completely stuck
with it.
Thanks
Debjani
 
Is the SQL Server started? Did you try to create a new Data Link to it?

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
MVP, hRD
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Bill,

Yes, Sql Server is up and running. I tried with new and existing (and
previously functioning) SqlDataAdapters and I only get the same
error("Unspecified Error").
Thanks
 
But did you try to create a new Data Connection with the Server Explorer?

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
MVP, hRD
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
I just did that too(create new data connection using server explorer) , and
it does not work either and gives me the same "unspecified error".
Just to check, I created a new solution and tried to connect to the same
database and tables and that worked.
So could there be something wrong at the project/solution level that is
creating this error?

Thanks
Debjani
 
Nope, I suspect that the credentials you are using to connect are wrong, the
permissions on the database you're trying to access have changed or the
server itself cannot accept any further connections. Try restarting the
server.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
MVP, hRD
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Back
Top