RE: No data in Sql server 2005

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: asp.net sql trusted connections between machines
    ... > connect to a remote SQL Server instance w/ Read-Write permissions. ... > connection string in the web.config. ... > Windows Authentication setting for access via IIS doesn't seem pass the ... is this impersonation behavior with IIS and Windows Authentication ...
    (microsoft.public.dotnet.framework.aspnet)
  • ASP + SQL 2000 + Win2k SP4
    ... SQL Server connection. ... OS is Windows 2000 and SP4 on both the IIS server and SQL server, ... enable Integrated windows authentication. ... There is a role for domain users to use giving them execute permissions ...
    (microsoft.public.sqlserver.odbc)
  • Re: More on that login problem - found the logs -
    ... I see that I'm using both SQL Server and Windows authentication; ... "Startup service account" startup runs the ... Should I try to make a new SQL server registration? ... Not associated with a trusted SQL Server connection"). ...
    (microsoft.public.sqlserver.connect)
  • Re: Blocking MS Access from linking tables...
    ... Does connection pooling work the same way? ... database that was converted from Access to SQL Server. ... I know that using an Access form can create multiple SPIDs on SQL Server ... If you're using Windows authentication, ...
    (microsoft.public.sqlserver.security)
  • Re: More on that login problem - found the logs -
    ... Verify that you are using both SQL Server and Windows authentication using ... Not associated with a trusted SQL Server connection"). ... Which account are you using to connect to the database? ...
    (microsoft.public.sqlserver.connect)