RE: No data in Sql server 2005
- From: "Andy Davis" <activecrypt@xxxxxxxxx>
- Date: Wed, 28 Dec 2005 20:36:04 -0800
Hi,
have you created a new database ! or attached it !?
:-)
Regards
--
Andy Davis
Activecrypt Team
--------------------------------------------
SQL Server Encryption Software
http://www.activecrypt.com
"den 2005" wrote:
> Thanks Andy for replying.
>
> The connection is ok. Able to connect and open the SqlConnection but no data
> is retrive, but teher is data on it. I used windows authentication in sql
> 2000 and try this in sql 2005.
>
> Dennis
> --
> MCP Year 2005, Philippines
>
>
> "Andy Davis" wrote:
>
> > Hi,
> > would you give some more insight !?
> > is it run on Windows Authentication !?
> > is their Guest User has access for DB / server !?
> > what is error message ?
> >
> > :-)
> > Regards
> > --
> > Andy Davis
> > Activecrypt Team
> > --------------------------------------------
> > SQL Server Encryption Software
> > http://www.activecrypt.com
> >
> >
> >
> > "den 2005" wrote:
> >
> > > Hi everybody,
> > > Happy Holidays to all. 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
.
- References:
- RE: No data in Sql server 2005
- From: den 2005
- RE: No data in Sql server 2005
- Prev by Date: Re: netstat on my server
- Next by Date: Re: No data in Sql server 2005
- Previous by thread: RE: No data in Sql server 2005
- Next by thread: Cannot login SQL Server with 'sa'
- Index(es):
Relevant Pages
|
|