Database Discussion Boards

Tom Wright22-Mar-04 7:14

22-Mar-04 7:14

I'm a little confused. How do I know what's being returned to me from a stored procdure when I call it from my C++ app?

For instance I want to write a program that returns back all users accessing a database. I found the stored procedure called "sp_who". I think I understand how to call it but I'm unsure how I find out what is returned to me. Is there not a way to do this on the fly in the code?

Thanks

Tom Wright
tawright915@yahoo.com

Re: Need some understanding on SP

OMalleyW25-Mar-04 2:41

OMalleyW

25-Mar-04 2:41

SELECT loginame, hostname FROM Master.dbo.sysprocesses
WHERE loginame != 'sa'

this should give you all the users loged on the server

Will

Foxpro (free) Tables and ADO.NET

ArnieA21-Mar-04 19:56

ArnieA

21-Mar-04 19:56

I am preparing to migrate a legacy system using foxpro tables (.dbfs) to VB.NET. During the transition stage, some of the new system needs to access data inside foxpro tables. I am now coding the data access component to handle these tasks. My initial code testing revealed, that the time to transfer records from foxpro tables to a ADO.NET's dataset table took a lot of time.

I am connected with a pre-need company (similar to insurance) so we basically keep track of planholders and their premium payments (montly, quarterly, semi-annual, annual. payment term is up to 10 years)

The code is the basic dataset creation and fill. The SQL statement is "SELECT * FROM premiumpayments WHERE account = planholderaccountnumber". My test data reads 84 records representing 7 years of monthly preimiun. It took 3-5 seconds to complete from my local drive.

I searched the archive but did not found any related postings. Is there a way to speed up this process? I would really appreciate any help. Thanks!

Backup/Restore Database in ISP

Click^ok20-Mar-04 15:02

Click^ok

20-Mar-04 15:02

I learn the follow commands to backup and restore of SQL Server:

backup database northwind to disk = 'c:\northwind.bak'
restore database northwind from disk = 'c:\northwind.bak'

Ok, but my database is in server of my ISP... How I do to perform backups and restores? I need contact them? Confused | :confused:

And how I do to download the backups???

Thanks for all by the help.

Re: Backup/Restore Database in ISP

Mike Dimmick22-Mar-04 4:55

Mike Dimmick

22-Mar-04 4:55

I suggest contacting them. Remember that the path you specify in the BACKUP DATABASE command is relative to the database server machine, i.e. the above command will backup to the root of the server's c: drive.

If you don't specify a path, the backups will go to the server's default backup directory.

Stability. What an interesting concept. -- Chris Maunder

Inserting Soap formatted XML into SQLServer2K table

atan_ban20-Mar-04 7:26

atan_ban

20-Mar-04 7:26

Hi :
I am a starter in .NET technology and just trying to save this soap formatted XML serialized from Account class, mentioned below.
========================================================
<SOAP-ENV:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:clr="http://schemas.microsoft.com/soap/encoding/clr/1.0" SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
<SOAP-ENV:Body>
<a1:Account id="ref-1" xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Accounts/Accounts%2C%20Version%3D0.0.0.0%2C%20Culture%3Dneutral%2C%20PublicKeyToken%3Dnull">
<Name id="ref-3">Atanu</Name>
<Balance>500</Balance>
</a1:Account>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>
==========================================================
Account table in SQLServer2K, has 2 fields: Name & Balance and currently has no data. When trying to insert using usual method (DataAdapter, CommandBuilder, DataSet), it is inserting NULL in the Name col and 500 in the Balance column.
Then I removed the (id="ref-3") from (<Name id="ref-3">Atanu</Name>) of the above generated XML and now the value "Atanu" is correctly inserted in the Name col? But then I should not have done this.
Could you please tell me how to insert the above XML into Account table. Also could you please tell meaning of the phrase "<Name id="ref-3">Atanu</Name>" found in the above XML, generated using serialize method and soap-formatter - I mean meaning of "id=ref-3" attrb. in the name element and is there any way to get rid of the attrb. while the XML was generated.

Thanks very much.
Atanu

Re: Inserting Soap formatted XML into SQLServer2K table

Mazdak20-Mar-04 21:00

Mazdak

20-Mar-04 21:00

What is your code? You don't need to insert the whole XML, SQLServer 2000 can do it for you and return results from a table in a XML format. For start point see sp_xml_preparedocument in SQLServer Online Book to see how to insert XML file ito your database.

Mazy

"Man is different from animals in that he speculates, a high risk activity." - Edward Hoagland

Sending Data to URL

SamAmman19-Mar-04 20:47

SamAmman

19-Mar-04 20:47

Hello
this is sam, and I have a big problem with ASP !!!!

I want to retrieve data from a database and then send this data to a url as a query string.

ex: http://77.125.192.120:1428/Recieve.asp?tel=20123335357&Msg=Misssshhhhh%20this%20is%20this?&CC=20&user=SMS&pass=Ed3kWKad&enc=1

enc:
Encoding: if message is ucs2 =0;
if message is plain Text =1

and if the Msg is in arabic so it is encoded and then sent.
Please help me with this. how can i do it in VBScript, ADO ?
I want the application to be run without stopping, to send data to the url without stopping. any new data comes, is sent to the url directly.

yours
sam.

Sam2004

Updating cells in datagrid base off another cells input value

Anonymous19-Mar-04 7:05

Anonymous

19-Mar-04 7:05

I have a datagrid bound to a sqlserver table. It has 2 columns. how can i write a statement that will evaluate when i change data in a cell of column 1 and trigger the data in column 2 to change base off of the column 1 change?

ODBC join

Ganesh Ramaswamy19-Mar-04 6:35

Ganesh Ramaswamy

19-Mar-04 6:35

hello,
i am in need of ODBC(C++) code that performs join (natural or inner) between 2 tables based on some condition.But i dont know where to look for. Can someone please give me some pointers or source.
(this is not my assignment!! i need to it for someother purpose and unfortunately i dont have time to learn ODBC c++ interfaces).
thanks a lot

-Ganesh.M.Ramaswamy

Re: ODBC join

Mike Dimmick19-Mar-04 11:40

Mike Dimmick

19-Mar-04 11:40

I'm not sure the ODBC library has this feature. Normally you join tables using SQL, in the statement that you pass to SQLExecDirect or SQLPrepare, or within a stored procedure (which you call using a suitable {call=procname} syntax with either of the above functions).

Stability. What an interesting concept. -- Chris Maunder

SQL Server 7 to 2000

hxxbin19-Mar-04 4:31

hxxbin

19-Mar-04 4:31

Hi
Someone knows if it's possible replicate data from a SQL Server 7 to a SQL Server 2k. I try but it's no possible. There is not a third part software to make this??.

Thanks

----
hxxbin

Re: SQL Server 7 to 2000

Rob Graham19-Mar-04 10:53

Rob Graham

19-Mar-04 10:53

you are sorta trying to make water run uphill, why not upgrade the SQL7 server to 2K?

Power corrupts and PowerPoint corrupts absolutely. - Vint Cerf

Re: SQL Server 7 to 2000

Jeff Varszegi20-Mar-04 4:48

Jeff Varszegi

20-Mar-04 4:48

Er, maybe because of the horrendous pricing model of SQL Server 2000? Most companies that use 2000 (like mine) have a mixture, and that won't change any time soon.

Regards,

Jeff Varszegi

How to use SQL server CE in embedded visual c++?

P_JAYAPRAKASH19-Mar-04 0:53

P_JAYAPRAKASH

19-Mar-04 0:53

Hey
I couldn't find out the exact procedure to use sql server ce in embedded visual c++. If u have any tutorials or weblink, Plz help me.

Thanks
JP

ALL THINGS ARE POSSIBLE UNTIL THEY ARE PROVED IMPOSSIBLE-AND EVEN THE IMPOSSIBLE MAY ONLY BE SO,AS OF NOW

Locale of DataSet effects datetime values?

JackDotNet18-Mar-04 8:41

JackDotNet

18-Mar-04 8:41

Hi, gurus

I have a web method, getting DataSet with locale property set to "en-GB". My local settings are different. DataSet has columns of datetime type and I was suprised that when I get data using

DataSet myDS = goToWebMethod(...);
and
Inserting data into local DB from myDS as is

I've got permanent 6 hr difference in time !
Any ideas?

JackDotNet

Re: Locale of DataSet effects datetime values?

Mazdak18-Mar-04 22:26

Mazdak

18-Mar-04 22:26

Your server time is different from your local time?

Mazy

"Man is different from animals in that he speculates, a high risk activity." - Edward Hoagland

Re: Locale of DataSet effects datetime values?

JackDotNet24-Mar-04 22:31

JackDotNet

24-Mar-04 22:31

Yes, the server is remote one and client application that requests data is local one with 6 hr time difference and different locale too

JDotNet

Re: Locale of DataSet effects datetime values?

Mazdak24-Mar-04 23:18

Mazdak

24-Mar-04 23:18

So web method return time in server local. Thats all.

Mazy

"Man is different from animals in that he speculates, a high risk activity." - Edward Hoagland

Re: Locale of DataSet effects datetime values?

JackDotNet25-Mar-04 8:25

JackDotNet

25-Mar-04 8:25

That's nice, but it modifies the data!!!
This action is taken without asking, on the background. And what if I don't care about this fantastic feature? I just want to get what was sent to me, as is.
This looks ridiculous, don't you agree?

CRecordSet and CDatabase.ExecuteSQL

pnpfriend18-Mar-04 5:21

pnpfriend

18-Mar-04 5:21

Hello all.. i need your help again.
I'm use CDatabase and CRecordSet to access to my access database.

forexample myTable have two rows, row1 and row2. row1 contains texts, row2 contain numbers
as shown below.

r1 | r2
___________
a | 1
a | 1
b | 2
c | 1
a | 1
c | 5
d | 5
d | 9
a | 3

I want only a,b,c,d from row1 not entire column, so I wrote the following code to get select the data that I want. but it still giving me entire column instead of only a,b,c,d
could you please point me out that what am i doing wrong?

<br />
CDatabase db;<br />
MyCRecordSet rs(&db);<br />
db.open.....<br />
rs.open...<br />
<br />
//some more code here then<br />
CString qstr = "SELECT DISTINCTROW r1 FROM myTable";<br />
rs.m_pDatabase->ExecuteSQL(qstr);<br />
if(rs.ReQuery())<br />
{<br />
  while(!rs.isEOF())<br />
  {<br />
    MessageBox(rs.rOneData);<br />
  }<br />
}<br />
<br />

thank you

Re: CRecordSet and CDatabase.ExecuteSQL

Rob Graham18-Mar-04 5:39

Rob Graham

18-Mar-04 5:39

pnpfriend wrote:
CString qstr = "SELECT DISTINCTROW r1 FROM myTable";

should be "SELECT DISTINCT r1 FROM myTable";

pnpfriend wrote:
myTable have two rows, row1 and row2

I think you meant myTable have two Columns, r1 and r2
and you want one row for each unique value in column r1
"select distinct" will do that. select distinctrow retuns all the rows that are not duplicates (all column vaues equal).

Power corrupts and PowerPoint corrupts absolutely. - Vint Cerf

Re: CRecordSet and CDatabase.ExecuteSQL

pnpfriend18-Mar-04 6:47

pnpfriend

18-Mar-04 6:47

yes.. i meant myTable have two columns, r1 and r2
i think i have to use distinctrow, since you said that
distinctrow returns all the rows that are not duplicates meaning
if i use distinctrow i will get a,b,c,d from r1 as I wanted.

anyway i tried both and it is not giving me the answer i wanted.

<br />
CString qstr = "select distinctrow r1 from myTable";<br />
rs.m_pDatabase->ExecuteSQL(qstr);<br />
if(rs.ReQuery())<br />
{ <br />
while(!rs.IsEOF())<br />
{<br />
 MessageBox(rs.r1Data);<br />
 rs.MoveNext();<br />
}<br />
}<br />
<br />

keeping giving me entire r1 column data.
is it because of rs.IsEOF() while loop??
is is CRecordSet will have the record of whatever record set of sql query statement executed and return??

Re: CRecordSet and CDatabase.ExecuteSQL

Roger Wright18-Mar-04 7:00

Roger Wright

18-Mar-04 7:00

The DISTINCTROW only eliminates duplicate records from the query result; it does nothing to qualify the selection. You need to include a WHERE clause in the query to define what records you want returned. Adding the clause WHERE r1 >= 'a' AND r1 <= 'd' (or whatever is syntactically correct for Access) will filter the resulting recordset so that it contains only records that meet the specified criteria. Also, specifying r1 as the only value returned is probably not what you intend - try SELECTing * to return entire records.

Will Build Nuclear Missile For Food - No Target Too Small

Re: CRecordSet and CDatabase.ExecuteSQL

DiWa25-Mar-04 8:41

DiWa

25-Mar-04 8:41

ExecuteSQL lets you send SQL-Commands to the Database directly, but it doesn't change the recordset (you can prove by examining the m_strSQL member)

to use aggregate functions and the like (sum, count, distinct, ...) you have to modify the DopFieldExchange-function:

void
CDPDCount::DoFieldExchange(CFieldExchange* pFX)
{
pFX->SetFieldType(CFieldExchange::outputColumn);
RFX_Long(pFX, _T("COUNT(*)"), m_lCount);
}

hope it helps Smile | :)

dirk

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