No data in Sql server 2005

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 wa
s
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 securit
y
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, PhilippinesHi,
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 retriv
e
> 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 secur
ity
> info=False;initial catalog=Genesis;"
> "user id=guest;password=guest123;data source=RITS-DENNIS\SQLEXPRESS;persis
t
> security info=False;initial catalog=Genesis;"
>
> Thanks in Advanced.
> den2005
> --
> MCP Year 2005, Philippines|||Please don't post independently in separate newsgroups. You can add
multiple newsgroups to the header and then all the answers appear as one.
See my reply in the other newsgroup.
Andrew J. Kelly SQL MVP
"den 2005" <den2005@.discussions.microsoft.com> wrote in message
news:B4D11A55-9CB7-4ACE-9F4E-91524D4E58D9@.microsoft.com...
> 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|||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:
[vbcol=seagreen]
> 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:
>|||Sorry for that, don't know how to do that.
dennis
--
MCP Year 2005, Philippines
"Andrew J. Kelly" wrote:

> Please don't post independently in separate newsgroups. You can add
> multiple newsgroups to the header and then all the answers appear as one.
> See my reply in the other newsgroup.
>
> --
> Andrew J. Kelly SQL MVP
>
> "den 2005" <den2005@.discussions.microsoft.com> wrote in message
> news:B4D11A55-9CB7-4ACE-9F4E-91524D4E58D9@.microsoft.com...
>
>|||You simply include the other newsgroups in the "NewsGroups" (addressed to
part of the header) section and it will be posted to all of them at once,
including replies. If you have Outlook Express you can simply click on the
"Newsgroups" icon to the left of the textbox and select as many as you need.
Andrew J. Kelly SQL MVP
"den 2005" <den2005@.discussions.microsoft.com> wrote in message
news:08CE0F6F-5D4F-4152-8E4C-45DA8366E681@.microsoft.com...[vbcol=seagreen]
> Sorry for that, don't know how to do that.
> dennis
> --
> MCP Year 2005, Philippines
>
> "Andrew J. Kelly" wrote:
>|||In the headers of den2005's messages it says that the Newsreader is
"Microsoft CDO for Windows 2000", so it seems to not be Outlook Express. I
think it is probably an online Newsreader.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:%23oI1TyuCGHA.724@.TK2MSFTNGP10.phx.gbl...
> If you have Outlook Express you can simply click on the "Newsgroups" icon
> to the left of the textbox and select as many as you need.|||Hi Andrew and Sam,
I am using the Microsof Online Newsgroup to post topics and not using
Outlook.
den2005
--
MCP Year 2005, Philippines
"Sam Hobbs" wrote:

> In the headers of den2005's messages it says that the Newsreader is
> "Microsoft CDO for Windows 2000", so it seems to not be Outlook Express. I
> think it is probably an online Newsreader.
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:%23oI1TyuCGHA.724@.TK2MSFTNGP10.phx.gbl...
>
>|||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:
[vbcol=seagreen]
> Thanks Andy for replying.
> The connection is ok. Able to connect and open the SqlConnection but no da
ta
> 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 Den
The Web based newsgroups such as
http://www.microsoft.com/technet/co...server/sql.mspx do not
allow you to post in multiple groups. You should choose the most appropriate
group and post there. Before posting it is also worth checking for similar
posts made in the past, e.g. search google (which would cover multiple
groups) or using the search facility in the online groups.
John
"den 2005" <den2005@.discussions.microsoft.com> wrote in message
news:21A14991-A08A-4A51-B2CE-D48A6C51FDA0@.microsoft.com...[vbcol=seagreen]
> Hi Andrew and Sam,
> I am using the Microsof Online Newsgroup to post topics and not using
> Outlook.
> den2005
> --
> MCP Year 2005, Philippines
>
> "Sam Hobbs" wrote:
>