RE: No data in Sql server 2005



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
.



Relevant Pages

  • Re: netstat on my server
    ... >>> Andy Davis ... >>> Activecrypt Team ... >>> SQL Server Encryption Software ...
    (microsoft.public.sqlserver.security)
  • Re: netstat on my server
    ... >>> domain is taking up all the ram. ... >> Activecrypt Team ... >> SQL Server Encryption Software ...
    (microsoft.public.sqlserver.security)
  • NetLib Encryptionizer still available?
    ... I've been trying to get details of the SQL Server encryption software ... from them with no response. ... Failing that, is there another comparable product available? ...
    (microsoft.public.sqlserver.security)