Re: No data in Sql 2005 tehre is data in sql 2000
- From: "Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx>
- Date: Fri, 23 Dec 2005 09:29:07 -0500
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
.
- Follow-Ups:
- Re: No data in Sql 2005 tehre is data in sql 2000
- From: den 2005
- Re: No data in Sql 2005 tehre is data in sql 2000
- Prev by Date: Re: TCP Connectivity Issue - RESOLVED
- Next by Date: Re: connection to another server
- Previous by thread: can't insert data into DB2 via a linked server?
- Next by thread: Re: No data in Sql 2005 tehre is data in sql 2000
- Index(es):
Relevant Pages
|
