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

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Andrew,
Transaction? I did not use them, I used the query window and put insert
statements and execute by pressing F5. Is there a automatic transaction mode
at the back of this operation? I used sa account, why i did not lose the data
same as before, the change I did is only the account I used to login.

Thanks for reply.

dennis
--
MCP Year 2005, Philippines


"Andrew J. Kelly" wrote:

> The reason you seemed to have lost the data was probably due to the
> connection setting it in IMPLICIT TRANSACTION mode. This means when the
> first command is issued a BEGIN TRAN automatically gets issued behind the
> scenes. That means all of your inserts were wrapped in a transaction. If
> you didn't issue a COMMIT when done they would have been rolled back when
> you ended the connection.
>
> --
> Andrew J. Kelly SQL MVP
>
>
> "den 2005" <den2005@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:B01C3A0C-6F8E-40DF-BCF6-2E137D78EE13@xxxxxxxxxxxxxxxx
> > 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
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>
.

Relevant Pages

  • Re: DataBase
    ... Andrew J. Kelly SQL MVP "Andrew J. Kelly" wrote in message ... Sorry I don't know anything about> dbase being supported with windows other than there are odbc and possibly> oledb drivers for it now, ... What I actually need to>> know>>>> is it posible to create this as a database and create tables in it, ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: DataBase
    ... Andrew J. Kelly SQL MVP ... > And do you know something a databse that comes directly with windows. ... >> Andrew J. Kelly SQL MVP ... >>> database, but I need it not to use any SQl server. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Binary data into File.
    ... > Windows file... ... >> Andrew J. Kelly SQL MVP ... >>> Is there any way to save the image data into one file..... ...
    (microsoft.public.sqlserver.clients)
  • Re: SQL Server 2000 memory scalability
    ... >> Andrew J. Kelly SQL MVP ... >>> How about Windows 2003 Enterprise?? ...
    (microsoft.public.sqlserver.setup)
  • Re: Extremely high % Disk Time .. How is this possible??
    ... Andrew J. Kelly SQL MVP ... > Slicing them into logical drives may look better but it does not increase ... I prefer to look at disk queue ... >>> Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.clustering)