Updating a database from a dataset - Database Discussion Boards

Updating a value in a Recordset using Find

Mr. Bill12-Jul-02 11:38

12-Jul-02 11:38

I have a text file that I am reading in from and want to store the information in a recordset until all the values in the text file are read in. I am using find to find the row to put the value into but once I update a value and do a movefirst I get an unspecified error.

//while
m_pRecs->MoveFirst();
m_pRecs->Find(strTemp.AllocSysString(),0,ADODB::adSearchForward);
if (!m_pRecs->adoEOF)
m_pRecs->Fields->Item["Value"]->Value = strValue.AllocSysString();
//end while loop

I have also tried filtering without success. Clearing the filter gives me problems. I don't want the db that I am using to change so this recordset is essentially just a place holder until the text file is read in and the values are pulled back out of the recordset. Any help will be greatly appreciated.

Bill

Re: Updating a value in a Recordset using Find

Carlos Antollini12-Jul-02 11:58

Carlos Antollini

12-Jul-02 11:58

You need to update the recordset...
Or may be you need to test if you can update the recordset...

Regards

Carlos Antollini.
Sonork ID 100.10529 cantollini

Re: Updating a value in a Recordset using Find

Mr. Bill12-Jul-02 12:01

Mr. Bill

12-Jul-02 12:01

I put a m_pRecs->Update() and it caused the same unspecified error as the MoveFirst(). Just for my info. Doesn't the movefirst call update if the recordset has changed, I could be wrong that is why I am asking.

Thanks for replying,
Bill

Re: Updating a value in a Recordset using Find

Mr. Bill12-Jul-02 12:06

Mr. Bill

12-Jul-02 12:06

Could it possibly be the way I am assigning the value.

m_pRecs->Fields->Item["Value"]->Value = strValue.AllocSysString();

That is a general field in an excel spreadsheet. I have changed it to text and it acted the same.

Bill

Re: Updating a value in a Recordset using Find

Carlos Antollini12-Jul-02 12:22

Carlos Antollini

12-Jul-02 12:22

What cursor are using you?

Carlos Antollini.
Sonork ID 100.10529 cantollini

Re: Updating a value in a Recordset using Find

Mr. Bill12-Jul-02 12:23

Mr. Bill

12-Jul-02 12:23

I am currently using static, but have tried dynamic.

Bill

Object Oriented DB

Joshua Nussbaum9-Jul-02 18:39

Joshua Nussbaum

9-Jul-02 18:39

Hi cpians.

Can you recommend any OO databases? Have you used any with .NET?

Updating a database from a dataset

Alexandru Savescu8-Jul-02 22:19

Alexandru Savescu

8-Jul-02 22:19

Hello,

I have some data in a XML format. I have successfully read the data in a dataset. Now I want to add that data in the database. Anybody have a clue?

I can succesfully do the other way (reading from the database and populate a dataset).

Best regards,
Alexandru Savescu

Re: Updating a database from a dataset

Mazdak9-Jul-02 8:59

Mazdak

9-Jul-02 8:59

Check Update() function of OleDbDataAdapter and GetChanges() of DataSet.

Mazy

"If I go crazy then will you still
Call me Superman
If I’m alive and well, will you be
There holding my hand
I’ll keep you by my side with
My superhuman might
Kryptonite"Kryptonite-3 Doors Down

Re: Updating a database from a dataset

Alexandru Savescu9-Jul-02 9:08

Alexandru Savescu

9-Jul-02 9:08

Thanks! I'd already discovered that, but didn't want to answer my own post Smile | :)

Best regards,
Alexandru Savescu

help! Simple problem with Log Shipping in SQL server 2k

devvvy8-Jul-02 17:41

devvvy

8-Jul-02 17:41

Example from SQL Server Books Online: To bring a standby server up after the primary goes down:

-- Restore the initial database backup on the standby server.
USE master
GO
RESTORE DATABASE MyNwind
FROM MyNwind_1
WITH STANDBY = 'c:\undo.ldf'
GO
-- Apply the first transaction log backup.
RESTORE LOG MyNwind
FROM MyNwind_log1
WITH STANDBY = 'c:\undo.ldf'
GO
-- Apply the next transaction log backup.
RESTORE LOG MyNwind
FROM MyNwind_log2
WITH STANDBY = 'c:\undo.ldf'
GO
-- Repeat for each transaction log backup created on the
-- primary server.
--
-- Time elapses.. .. ..
--
-- The primary server has failed. Back up the
-- active transaction log on the primary server.
BACKUP LOG MyNwind
TO MyNwind_log3
WITH NO_TRUNCATE
GO
-- Apply the final (active) transaction log backup
-- to the standby server. All preceding transaction
-- log backups must have been already applied.
RESTORE LOG MyNwind
FROM MyNwind_log3
WITH STANDBY = 'c:\undo.ldf' -- QUESTION 1: Why not just use "WITH RECOVERY" here??
GO
-- Recover the database on the standby server,
-- making it available for normal operations.
RESTORE DATABASE MyNwind
WITH RECOVERY
GO

Question 2:
I dont understand the use of the "undo" file. I mean, before u bring the standby online, u're going to apply the last transaction log anyway. And I presume u BACKUP the last log WITH NO_TRUNCATE - so, all uncommitted transaction will be backed up.
And in this case, why do we need the "undo" file?

QUESTOIN 3:
I really dont understand:

>Database Maintenance Wizard
>"Specify Log Shipping Destination"
>Add
>"Allow database to assume primary role", and Database Load State: "NORECOVERY", "STANDBY".

I tried different options, and all resulting destination database became "Read only" whether i put them on "NORECOVERY" or "STANDBY".
I thought NORECOVERY and STANDBY assumes the same meaning as in RESTORE DATABASE WITH NORECOVERY/STANDBY.
In NORECOVERY case, I expect that I cannot even READ from the destination database (but, problem, I could read from it using SELECTs, in my little test?). In case of STANDBY, only read permitted, no write (okay, this has been confirmed and i have no problem)

And documentation for "Allow database to assume primary role" is as follows:

"Specify if the destination server should be setup to be able to function as a primary server."

what da?? All destination database has been marked "secondary" and "read-only" under database properties even after i checked the "Allow database to assume primary role" checkbox!?
what lousy documentation..

Help! Been reading on this all day and toying with it, but still havent found a clue as to why...

thanx, any help will be appreciated!

norm

How do you autoprompt for ADO connection in C++?

Bill Ferreira8-Jul-02 8:12

Bill Ferreira

8-Jul-02 8:12

How do you autoprompt for an ADO connection in Visual C++?

The code below shows how it is done with VB.

Set DBConn = New ADODB.Connection
With DBConn
.Properties("Prompt") = adPromptAlways
.Open ("driver={SQL Server};server=" & gServer & ";database=" & gDatabase)
End With

Thanks in advance for you help
Bill Ferreira

Re: How do you autoprompt for ADO connection in C++?

Steven Szelei8-Jul-02 15:18

Steven Szelei

8-Jul-02 15:18

if you are working with MFC use CDatabase. Call Open and pass the following for the parameters: Open("", false, false,"ODBC;" ,TRUE)

Programmatical Jet Database Replication with C++

Steven Roberts8-Jul-02 2:52

Steven Roberts

8-Jul-02 2:52

Hi
I'm using an Access database with the Jet engine for my application. There is a requirement for the user to take the database home (sounds like a job for database replication I here you say) and that would be great... However, the only documentation I have seen is in VB... DAO and JRO are the tools that the MSDN suggests but gives not examples.

I would like to provide this replication facility within my app and not have to force the user to open access and do it from there. can anyone help?

Thanks in advance
Steve Big Grin | :-D

Re: Programmatical Jet Database Replication with C++

Andres Manggini12-Jul-02 10:47

Andres Manggini

12-Jul-02 10:47

I've done that programatically in Visual C++ a few years ago. But don't have the code with me (I'll look for it, can't promise you anything)

There is an article un MSDN:

Implementing Database Replication with JRO

Wich is pretty good, the downside: is in VB, but you should be able to translate it.
Is totally doable.

Andres Manggini.
Buenos Aires - Argentina.

DB2 Connection

5-Jul-02 9:21

Hi,

Any body can guide on how to connect to AS400 DB2 files using C#?

Many Thanks,
Jassim Rahma

Jassim Rahma

Protected DBF

5-Jul-02 9:20

I need to develop an application for multi user (8 users / time) which MSDE will not allow me to do because it allows max 5 users/time. I personally like DBF files but I have a problem in saving the user's prefrences & password. Can any one guide me please?

Jassim Rahma

Reading an XML file to a Dataset and then from Dataset to SQLServer

Alexandru Savescu4-Jul-02 22:54

Alexandru Savescu

4-Jul-02 22:54

I am doing the folowing operations:

1. Export some tables (that have unique IDs and foreign keys) to an XML file using a DataSet object in .NET. This works file.

2. I want to be able to import that XML file into another SQLServer server that has the same database architecture, but of course, different data.

3. When reading the XML file into a Dataset and then updating the database, some key violations or duplicate records may occur because I exported some unique IDs from one databse server and am trying to import them into another server. Thus, when importing a master table, I must read the XML file and give the corresponding records new IDs accordingly. Since my master table will have several slave tables with foreign keys involved I would have to udpate the slave tables also to maintain the integrity.

I could do all that manually by having lots of structures and maps and hash tables. Is there a change .NET Dataset would take care of everything automatically for me?

Best regards,
Alexandru Savescu

sql server 2000: protocol and encryption

devvvy4-Jul-02 16:30

devvvy

4-Jul-02 16:30

hi, i have 3 questions regarding communication protocols used by sql servers... hope someone can give me some direction, i read the "help" and some books, didnt find anything...

QUESTION 1: how can u ping a sql server instance?

for example:

ping www.myserver.com:1433 (for default instance)
ping www.myserver.com:3333 (some designated port for a named instance)

is this correct? any why do i have to configure thru both?
a. client network utility (i thought communication protocol used by an application is really up to the client application itself? why do we need to configure it thru sql server)
b. server network utility (this i understand, but one more question. let's say we installed a few protocols, when a client connection comes in, is it SQL server that's responsible for detecting the protocol used by the client connection? and it's SQL server that pick the matching protocol - if available/installed?)

QUESTION 2: "force protocol encryption" in "server network utility"

a. what does it mean? to encrypt "out-going traffic"? or "incoming traffic"? How does this work between server and client?
b. If this checkbox is available on the main dialog, then why can i also configure "Enable Encryption" under "multi-protocol" encryption?
c. And how can i enable SSL for TCP/IP? Under "properties" for TCP/IP (in SQL Server Network Utility), i cant find any "Enable SSL encryption" checkbox?
d. "protocol encryption": which layer? I presume they just encrypt application layer header rite?

QUESTION 3:
what about named pipe? I have no idea what name piped really means... Can i type the "named pipe" from a command prompt and "ping" the resource as if I am using TCP/IP?

I know it's a protocol used by SQL server, but is this all i need to know?

Thanx!! Confused | :confused:

norm

Re: sql server 2000: protocol and encryption

Richard Deeming16-Jul-02 6:08

Richard Deeming

16-Jul-02 6:08

norm wrote:
ping www.myserver.com:1433

Ping only works at IP address level. If you need to connect to a specific port, try Telnet.

norm wrote:
a. client network utility
norm wrote:
b. server network utility

SQL Server needs to know which protocols are enabled. The Server Network utility is used for that. The Client Network utility is used to configure which protocols are enabled on the client. If the client app specifies a network library to use, as long as it is enabled on the client and the server, everything should be OK. AFAIK, if the client doesn't specify a protocol, it will try the available protocols until it finds one that works.

norm wrote:
QUESTION 2: "force protocol encryption" in "server network utility"

a. AFAIK, it encrypts both ways.
b. Confused | :confused:

I can't see that option.
c. The protocol encryption is SSL encryption.
d. No idea.

norm wrote:
QUESTION 3:
what about named pipe?

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpic/html/msdn_npipes.asp:
A pipe is a simple data transfer mechanism that works, well, pretty much like a pipe: You stuff things in one end and the things come out the other end. You can establish a pipe both locally (using either so-called anonymous pipes or named pipes) and to a remote machine (a named pipe). In order to be able to utilize a named pipe over a network, one machine must have created the pipe (the server), and another machine that wants to use the pipe (the client) must know both the name of the server machine and the name of the pipe on the server machine.

How to add a Record ID column?

4-Jul-02 4:03

Hi, all.
a table named Employees, which has one column named "Name" and 3 records, like below:

Name
-----
Mike
Tom
Jacky

now i wanna display one more column named ID, which is a continuous integer, let the result like:

ID Name
------------
5 Mike
6 Tom
7 Jacky

how to write this query can make this result(using ms sql)? thanks a lot.;)

Re: How to add a Record ID column?

SimonS5-Jul-02 10:32

SimonS

5-Jul-02 10:32

Do the Name values have to tie up with a specific integer value in the resultant table?
If not, why not give this a try:
1. Move Employees data into temp table
2. drop Employees table (or backup)
3. recreate new Employees table with ID and Name field
4. Iterate thru temp table and fill new Employees table.

...done. Poke tongue | ;-P

Does the ID field have to be a PK?

Cheers,
Simon

"Sign up for a chance to be among the first to experience the wrath of the gods.", Microsoft's home page (24/06/2002)

Get n records starting from...

Luca Leonardo Scorcia2-Jul-02 0:16

Luca Leonardo Scorcia

2-Jul-02 0:16

Hi! This is my first post here - hope you'll help me easily! Smile | :)

First of all, I'm using ASP with an Access DB. I need the SQL expression or some ADO instructions to get only n records starting from a record of which I have the primary key value.

If I had the record number it would be easy, but I don't have it, I only have the random primary key...

Thank you in advance

Luca Leonardo Scorcia
http://zip.to/kojak (only in Italian)

Re: Get n records starting from...

SimonS2-Jul-02 2:25

SimonS

2-Jul-02 2:25

You're probably going to have to use a client-side cursor with Access.

But, here are couple of questions:
1. how many rows are there?
2. are you sorting the resultset?

Cheers,
Simon

"Sign up for a chance to be among the first to experience the wrath of the gods.", Microsoft's home page (24/06/2002)

Re: Get n records starting from...

Luca Leonardo Scorcia2-Jul-02 3:04

Luca Leonardo Scorcia

2-Jul-02 3:04

Mhhh... what's a client-side cursor with Access? Smile | :)

The rows are ~2000, but they will grow maximum to 10000, I think...
Yes, the results are sorted.

This is the code I use to display the messages from record M to record N...

Sub WriteMessages(startAt, nEndAt)
  Dim indent_level, strSQL

  strSQL = "SELECT TOP " & nEndAt - 1
  strSQL = strSQL & " id_msg, id_thread, placement, reply_count, date, id_autore, author, subject, text"
  strSQL = strSQL & " FROM Bacheca"
  strSQL = strSQL & " ORDER BY id_thread DESC , placement"

  Dim rstThreads
  Set rstThreads = Server.CreateObject("ADODB.Recordset")

  rstThreads.Open strSQL, adminDBConnString
  rstThreads.Move(startAt - 1)
	
  do until rstThreads.EOF
     indent_level = (Len(rstThreads("placement")) - 1) / 4 + 1
     WriteMessage indent_level, rstThreads("id_msg"), 'Lots of parameters here
     rstThreads.MoveNext
  loop

  rstThreads.close
  set rstThreads = nothing
End Sub

I want to do the same thing, but starting from a certain record, whose number I don't know, but that has a certain value as primary key.

Luca Leonardo Scorcia
http://zip.to/kojak (only in Italian)

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.