Re: No data in Sql 2005 tehre is data in sql 2000

Thanks for replying, Andrew.

Able to open SqlConnection but no data is returned or retrived, and no error
message either.

Dennis
--
MCP Year 2005, Philippines


"Andrew J. Kelly" wrote:

> What exactly does "unable to retrieve data" mean? Is it a problem
> connecting to SQL Server? Do you get errors when you run queries? Do you
> not get errors but no data? It could be a million things you have to help
> us out here.
>
> --
> Andrew J. Kelly SQL MVP
>
>
> "den 2005" <den2005@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:4CA57567-F7CD-42C0-B588-4609ADFB5730@xxxxxxxxxxxxxxxx
> > Hi everybody,
> > I developed a windows application that connects to Sql server 2000,
> > using
> > windows authentication and it works, able to retrive and other data
> > process.
> > But when I used it on Sql Server 2005 Express, it was unable to retrive
> > data.
> > What is wrong with it? How can I fixed this?
> >
> > Connecting String at 2000:
> >
> > "integrated security=SSPI;data source=localhost;persist security
> > info=False;initial
> >
> > catalog=Genesis;"
> >
> > Connection String at 2005:
> >
> > "integrated security=SSPI;data source=RITS-DENNIS\SQLEXPRESS;persist
> > security
> >
> > info=False;initial catalog=Genesis;"
> >
> > "user id=guest;password=guest123;data
> > source=RITS-DENNIS\SQLEXPRESS;persist
> > security info=False;initial catalog=Genesis;"
> >
> >
> > Thanks in Advanced.
> >
> > den2005
> > --
> > MCP Year 2005, Philippines
>
>
>
.

Relevant Pages

  • Re: No data in Sql server 2005
    ... > multiple newsgroups to the header and then all the answers appear as one. ... > Andrew J. Kelly SQL MVP ... >> MCP Year 2005, Philippines ...
    (microsoft.public.sqlserver.security)
  • 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)
  • Re: Bug in MCP exam scoring?
    ... I once had an empty bar in a section and called the MCP phone ... FAQs on the MCP web site. ... Installing and Configuring SQL Server ... The bar is empty implying that I ...
    (microsoft.public.cert.exam.mcse)
  • 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: High availability
    ... I agree with Andrew. ... Senior Database Administrator ... Microsoft SQL Server MVP ... Both scaling up and>>> out ...
    (microsoft.public.sqlserver.clustering)