Database Discussion Boards

storage of images into oracle database as blob using vc++.net or ADO.net

Shaffiq7-Jul-03 7:57

7-Jul-03 7:57

hi all,

I am VC++ Programmar. We are facing Problem of Storing Images into oracle as Blob data type.Did VC++.Net oR ADO.net Helps to Store Images in Oracle Database as
Blob Datatype.
I need Help
NB:Very Urgent
Thanks In Advance

Re: storage of images into oracle database as blob using vc++.net or ADO.net

Not Active7-Jul-03 9:04

Not Active

7-Jul-03 9:04

It's for Sql Server but maybe it will help
http://www.codeproject.com/cs/database/albumviewer.asp[^]

Re: storage of images into oracle database as blob using vc++.net or ADO.net

Shaffiq7-Jul-03 18:45

Shaffiq

7-Jul-03 18:45

hi Mark,

Thanks For Replying.
Really I check That Article.It is Storing Images in C Sharp
I want To Store Images in Oracle Database Using VC++.Net
I am VC++ Progrmmar. I am Unable To Store The Images IN Oracle Database Using VC++ 5.0 So I need To Know and Conform
From any Dot.Net Programmars That Through VC++.Net Or VB.Net
WE can Store Images.Then I Can Recommend Company To Buy VC++.Net Or Related.

Re: storage of images into oracle database as blob using vc++.net or ADO.net

Not Active8-Jul-03 2:42

Not Active

8-Jul-03 2:42

Just because it was written in C# doesn't change the underlying techniques.

Create a file stream, read the the image bytes into the steam, assign stream to store procedure variable, execute the procedure.

Need to Export Records to Remote Terminal

Leon van Wyk7-Jul-03 0:24

Leon van Wyk

7-Jul-03 0:24

I need to Export Fields in a table into another Database Table on a Remote machine, at the moment I Export the records one by one and delete the records as I go along. This is very slow over a 28k connection that I need to use.(3 records per second or so, I am dealing with 1000s of records)
I would love to take all the records at once, dump the on the remote machine and then delete the lot!

I can make use of a Dataset to get all the records but how do I specify what and how to export this to another connection??? Confused | :confused:

Leon v Wyk

Re: Need to Export Records to Remote Terminal

basementman7-Jul-03 4:31

basementman

7-Jul-03 4:31

Option 1: write a program to do it.
Option 2-n: depends upon the database platform you are using. For example, SQL Server has very powerful data transfer mechanisms built in, such as DTS and RPC which can run on a scheduled basis.

onwards and upwards...

Re: Need to Export Records to Remote Terminal

Gaurav Bindlish8-Jul-03 9:38

Gaurav Bindlish

8-Jul-03 9:38

These are the steps in script that u'll be needing-

- BCP out the data into a text file.
- FTP the file to the remote location.
- Insert the file in remote database using remote stored procedure.
- Delete the records from source database.

Hope this helps.

Gaurav

Re: Need to Export Records to Remote Terminal

MrGlover1-Aug-03 13:12

MrGlover

1-Aug-03 13:12

This is a fairly old thread, but I just stumbled across it looking for an answer to a distributed transaction question I have.

Anyway, does your export procedure need to be transactional? i.e. Do you want to ONLY delete the source records once they are in the remote system? And do you want the destination records to ONLY be valid once they are deleted from the source?

I have architected many systems like this where the data needs to be in one place OR the the other but not both, and not get lost, like in this example.

while (there are more records to export)
{
begin transaction;

try
{
export record to remote system;
delete record from local system;

commit;
}
catch ()
{
rollback;
}
}

These systems are hard to accomplish, sometimes you are better off assuming that the 2 systems are only going to communicate asychronously and then revisit the problem you are trying to solve.

If that doesn't help you one iota I won't be too suprised.

JBoy

Tree view style data...

theJazzyBrain6-Jul-03 11:24

theJazzyBrain

6-Jul-03 11:24

I have a table as such:

rowID - rowParentID - rowTitle

rowID = Indentifier
rowParentID = is the parent of the row. Means that it belongs below the row that has rowID = rowParentID.

I need to show all rows in a tree view style in ASP.NET

I am new to SQL so any help will be usefull. I have no idea how to do this in stored proceedure..

|---------------|
| theJazzyBrain |
|---------------|

Re: Tree view style data...

theJazzyBrain8-Jul-03 4:48

theJazzyBrain

8-Jul-03 4:48

I have no idea about C++/MFC but I think that I shoulf be able to understand the logic at least...

Yeah, please send it to jason@skc.gr

Thanx alot

|---------------|
| theJazzyBrain |
|---------------|

ADO connection pooling

Jahangir Badar5-Jul-03 8:22

Jahangir Badar

5-Jul-03 8:22

I made an application in Visual C++ that uses ADO to connect to SQL server. My application is multiple threaded, there are five threads and each thread has its own connection object.

Someone told me that this way of making connection is not too good and that i should use connection pooling.

Can anyone tell me what is connection pooling in ADO ? How can i use it ? Is there any resource from where i can learn how to use ADO connection pooling ?

Has anyone found a workaround for VC++ 6.0 when using Access 2K?

WREY4-Jul-03 0:36

WREY

4-Jul-03 0:36

VC++ 6.0 and Access 2000 don't go hand in hand. IOW, you cannot develop an application using VC++ 6.0 AppWizard if the application will be using Access 2000. (Microsoft saw to that!!!!)

If you have a database application that already exists, there is some hope for getting it to use Access 2000, but if you are just developing it, AppWizard will NOT do it for you (meaning, you will bomb out where it asks for a Data Source.)

Has anyone gotten this experience and found a way of creating a new application and then somehow get it to work using Access 2000? Confused | :confused:

Thanks.

William

Fortes in fide et opere!

Re: Has anyone found a workaround for VC++ 6.0 when using Access 2K?

basementman7-Jul-03 4:34

basementman

7-Jul-03 4:34

If you use the standard ODBC driver, then you shouldn't have any problems. I have not used the MFC CDatabase/CRecordset classes in years because they are limiting and crappy. You may consider using your own ODBC class wrappers.

onwards and upwards...

Re: Has anyone found a workaround for VC++ 6.0 when using Access 2K?

Giles11-Jul-03 0:05

Giles

11-Jul-03 0:05

I've used Visual C++ 6 with Access 2000, and it works really well. I was using ADO though over DAO.

If you do use ADO, try out Carlos' classes - I recommend them.

http://www.codeproject.com/database/caaadoclass1.asp[^]

"Je pense, donc je mange." - Rene Descartes 1689 - Just before his mother put his tea on the table.

Shameless Plug - Distributed Database Transactions in .NET using COM+

if else

pnpfriend3-Jul-03 10:43

pnpfriend

3-Jul-03 10:43

does sql has if else statement like c++, vb..?
I have following statement
SELECT [k1] & ';' & [k2] & ';' & [k3] AS AllK FROM TEST;

That Query Statement combine strings of k1,k2,and k3 as k1;k2;k3 and insert it into AllK.
However when K1 field has nothing in it, then the result is ;k2;k3
again, when k2 field is emtpy then the result is k1;;k3
so how can i detect whether the field is empty or not to get the result as k1;k3 but not k1;;k3???

Thank you

Re: if else

Bo Hunter3-Jul-03 18:13

Bo Hunter

3-Jul-03 18:13

I do this quite offen COALESCE function

COALESCE( @BarrowDate, GetDate() )

If BarrowDate is null then GetDate() is called.
It returns the first non null value
I am sure there are others ways

Bo Hunter

Re: if else

Alexandru Savescu4-Jul-03 1:26

Alexandru Savescu

4-Jul-03 1:26

Try using CASE .

Best regards,
Alexandru Savescu

P.S. Interested in art? Visit this!

Re: if else

Gaurav Bindlish8-Jul-03 9:43

Gaurav Bindlish

8-Jul-03 9:43

Write Query like this-

Select ISNULL([K1] + ';', '') + ISNULL([K2] + ';', '') + ISNULL([K3] + ';', '') AS AllK FROM TEST

Ofcourse I am using the property of SQL that sum of a NULL string with another string is NULL. So if any of the K1, K2 or K3 field is NULL, [K1] + ';' will give NULL.

HTH.

Gaurav

sql query question

pnpfriend3-Jul-03 8:40

pnpfriend

3-Jul-03 8:40

hi all i have the table like

[ number ] [ name ] [ k1 ] [ k2 ] [ k3 ] [ h1 ] [ h2 ] [ h3 ] [ allK ] [ allh]
[ 1 ] [ pp ] [ 2 ] [ 3 ] [ 4 ] [ 5 ] [ 6 ] [ 7 ]
[ 2 ] [ dd ] [ a ] [ b ] [ c ] [ d ] [ e ] [ f ]

how should i do to get following table?? from each and every single record, take k1,k2,k3 and put into allk as k1;k2;k3
similarly, take h1,h2,h3 and put into allh as h1;h2;h3

<br />
  [ number ][ name  ] [   k1  ] [   k2 ] [   k3   ] [ h1  ] [   h2  ] [  h3  ] [   allK    ] [ allh ]  <br />
[1 ]      [ pp][2  ] [   3   ] [  4    ] [  5   ] [  6   ] [  7    ] [  2;3;4   ] [ 5;6;7 ] <br />
 [ 2       ] [  dd     ] [  a  ] [   b   ] [  c    ] [  d    ] [ e   ] [  f    ] [  a;b;c   ] [ d;e;f ] <br />

Re: sql query question

Daniel Turini3-Jul-03 9:32

Daniel Turini

3-Jul-03 9:32

Well, the way to go would definitively be by creating a computed column. See MSDN for details on how to do this with the CREATE TABLE command. The expression you need is something like this:

k1 + ';' + k2 + ';' + k3

so, the column on the create table would be defined as:

allk as k1 + ';' + k2 + ';' + k3

Doing things this way, you won't need storage space for allk, and it will be calculated as needed.
Another (better, in most cases) way is by using a view.

ORACLE One Real A$#h%le Called Lary Ellison

Re: sql query question

pnpfriend3-Jul-03 10:01

pnpfriend

3-Jul-03 10:01

Thank you very much for your reply..
I'm totally new to SQL. I'm using Access. I have the form, the user select all the fields as neccessary, and insert to the table by clicking next. I dont' want to create the new table but getting the some coloumn fields data ( information ) and insert it to another column of the same row. I dont' even know if I have to use SQL.
similar to this table

<br />
[num][k1][k2][k3][h1][h2][h3][allK][allH]<br />
[001][aa][bb][cc][dd][ee][ff]<br />
<br />
<br />
updated table<br />
[num][k1][k2][k3][h1][h2][h3][allK][allH]<br />
[001][aa][bb][cc][dd][ee][ff][aa;bb;cc][dd;ee;ff]<br />
<br />

and I have 1000s of record in the same table.
Can you please tell me how to do it, can you also give me some SQL code if i need it.

Thank you Daniel

Re: sql query question

pnpfriend3-Jul-03 10:32

pnpfriend

3-Jul-03 10:32

SELECT [k1] & ';' & [k2] & ';' & [k3] AS AllK FROM TEST;
this is the query statement that I got the table..
I have another problem.. how can I not entrying anything to the ALLK fields if the fields k1,k2,k3 contain empty text?
anyway of saying is how can i check whether k1,k2,and k3 contain emtpy text?

SQLOLEDB Driver and Transactions

Jörgen Sigvardsson2-Jul-03 5:10

Jörgen Sigvardsson

2-Jul-03 5:10

I just found out that the OLEDB driver for SQL Server 2000 does not support nested transactions. I've solved this by applying a small "hack" in a "helper" class of mine.

However, I feel that my hack isn't robust enough (I'm relying on an error code returned by CSession/ITransactionLocal::StartTransaction()). Surely, this is a problem many have bumped into. Do you have any favorite workarounds for this?

I have a couple of ideas up my sleeve, but I'm too tired to deal with this now (at the end of the day). So I figured you'd have some ideas which I could consider and compare to what I have in (my currently dizzy) mind tomorrow morning while sipping some tea. Smile | :)

--
Now we live in a world of uncetainty
Fear is the key - to what you want to be
You don't get a say, the majority gets it's way
You're outnumbered by the bastards till the day you die...

Can anyone Help?

Itanium1-Jul-03 20:26

Itanium

1-Jul-03 20:26

Hi All!!

I have binded my text fields to DataColumns of table at runtime.In data navigation mode, all text fields of my application are disabled. When I press the 'Add New' button, all fields are enabled and cleared.
Problem is that when I focus to next control, all the data of current record is again loaded in all textboxes. While I want to remain them clear.

plzzzzzzzzzzzzzzzzz help me.
Thanx in Advance

sorry for my bad English.

@@IDENTITY and OleDbType

Bo Hunter1-Jul-03 17:54

Bo Hunter

1-Jul-03 17:54

Is there a way to get the last created identity column from access mdb
and what does the memo type map to in the OleDbType enum for access mdb
and the max length?

Thank You
Bo Hunter

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