Re: No data in Sql 2005 tehre is data in sql 2000
- From: "den 2005" <den2005@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 27 Dec 2005 15:37:32 -0800
Hi Andrew,
Thanks for reply. Well, I have found what is wrong, and able to retrive
data. There ia one strange incident involving storing data, I inserted a lot
of records in SQl server 2005 using Windows authentication to log on the sql
server, the other day, I look into the data and it's gone, seems the data has
been erased or was not all inserted permanently.
Yesterday, I used the sa account to do the same, today, I check the data
inserted yesterday was still here. Why does that happens? Using windows
authentication to insert data is not ok. I am doing this in sql 2000, and it
is working.
Solved Problem Codes: (This is not exact code, Basically this is what trying
to do)
Dim sqlConn As New SqlConnection(constr)
Dim sqlText = "Select * From Topics"
Dim sqlAdapter As new SqlDataAdapter(sqlText, sqlConn)
Dim ds as new DataSet
sqlAdapter.Fill(ds,"Topics')
Dim dtObj as Datatable
dtObj = ds.Tables("Topics")
return dtObj
dennis
--
MCP Year 2005, Philippines
"Andrew J. Kelly" wrote:
> 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
> >>
> >>
> >>
>
>
>
.
- Follow-Ups:
- Re: No data in Sql 2005 tehre is data in sql 2000
- From: Andrew J. Kelly
- Re: No data in Sql 2005 tehre is data in sql 2000
- References:
- Re: No data in Sql 2005 tehre is data in sql 2000
- From: Andrew J. Kelly
- Re: No data in Sql 2005 tehre is data in sql 2000
- From: den 2005
- Re: No data in Sql 2005 tehre is data in sql 2000
- From: Andrew J. Kelly
- Re: No data in Sql 2005 tehre is data in sql 2000
- Prev by Date: Can't connect from ASP app
- Next by Date: Re: Can't connect from ASP app
- Previous by thread: Re: No data in Sql 2005 tehre is data in sql 2000
- Next by thread: Re: No data in Sql 2005 tehre is data in sql 2000
- Index(es):
Relevant Pages
|
