Re: No data in Sql 2005 tehre is data in sql 2000

Again we need as much info as you can give us. Your initial post shows only
a connection string. There is no example of what you are doing after that.
Just opening a connection does not return data, you need to issue a
statement. Can you post the exact code you are using to issue the command
and how you are determining it does not return anything?

--
Andrew J. Kelly SQL MVP


"den 2005" <den2005@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4867BFEF-7E1E-4C73-9033-9001EAAA90F7@xxxxxxxxxxxxxxxx
> Thanks for replying, Andrew.
>
> Able to open SqlConnection but no data is returned or retrived, and no
> error
> message either.
>
> Dennis
> --
> MCP Year 2005, Philippines
>
>
> "Andrew J. Kelly" wrote:
>
>> 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
>>
>>
>>


.

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: SQL Server 2000 sporadic connectivity errors
    ... Andrew is on the right track. ... Consider that the connection pool will attempt to reuse a connection that has been dropped by the server due to a severe error. ... connection it will be logged in one form or another, most commonly in the event logs or SQL Server error logs. ...
    (microsoft.public.sqlserver.connect)
  • Re: authentication error
    ... this account is not given access to SQL Server; ... Adding "Integrated Security=false" to your connection string will turn this ... > I've been having a problem connecting to my sql 2000 server database. ... > Under the defaults menu I've set the database to Andrew. ...
    (microsoft.public.sqlserver.connect)