Re: DTS and C# - Database Discussion Boards

mhmoud rawas25-Sep-04 22:22

25-Sep-04 22:22

I have a problem with triggers and transactions I need to create a trigger after insert on a table but I would like to fire that trigger only after committing the transaction not before the and on the transaction, any body can help me with this problem I will be thankful for that

regards

Mhmoud Rawas
------------
Software Eng.

Re: Trigger / Transaction problem

Bill Dean29-Sep-04 7:09

Bill Dean

29-Sep-04 7:09

Mhmoud,

As far as I know triggers cannot be made to work this way. They fire. Period.

I would take you logic in the trigger and make a stored procedure out of it. Then call the new stored procedure after you commit the original transaction. You will not have access to Inserted and Deleted but this is the only way I know to do what you describe

Hope this helps
Bill

Remote Data Access with MSDE?

Utku KAYA24-Sep-04 23:38

Utku KAYA

24-Sep-04 23:38

Hi all,
I could not find in or understand the
tutorials about MSDE,
Does anyone know if RDA's possible with MSDE?

I am planning to use SQL CE synchronizing with SQL database.

Thanks in advance.

Determining DATETIME durations

Den2Fly23-Sep-04 21:38

Den2Fly

23-Sep-04 21:38

Hello buddies,
How can I determine the time distance between two DATETIME values and compare the result with various time units like seconds, minutes, days, ... ?

I guess it has a standard method that I prefer, but anyway my target SQL is MS SQL Server 2000.

Thank you so much for your note

---
"Art happens when you least expect it."

Re: Determining DATETIME durations

David Salter24-Sep-04 5:13

David Salter

24-Sep-04 5:13

You need to use the DATEDIFF function. Full details are in the BOL.

store your internet favourites online - www.my-faves.co.uk

Re: Determining DATETIME durations

Den2Fly24-Sep-04 11:12

Den2Fly

24-Sep-04 11:12

Thank you, Thank you, Thank you

and once more, Thank you Wink | ;-)

---
"Art happens when you least expect it."

DTS and C#

stan2823-Sep-04 5:44

stan28

23-Sep-04 5:44

Hi gurus.
I've also post this in the C# forums, but responds weren't that helpfull.
Hope someone here can help me on this.

During the execution process of the DTS Package, I sometimes encounter this error:-

<br />
Event Source  : SomeStepsNameHere <br />
Error Code : -2147024882 <br />
Source : Microsoft Data Transformation Services (DTS) Package Description : Not enough storage is available to complete this operation.<br />
HelpFile : sqldts80.hlp <br />
HelpContext : 1100 <br />
InterfaceError {10020306-EB1C-11CF-AE6E-00AA004A34D5}.<br />

Now, that interfaceError is actually the DTS.dll COM Component.
This error was thrown by the com exceptions in c#.

Here's what got me puzzle. It's definately not a memory or HD issue because I have 4GB of Ram and 200GB of HD Space. I have verify my transactional log and set it to auto-growth.

Have anyone ever encountered such problems before ?

What my DTS Package do is to connect to Access mDB files and port all the data over to SQL Server 2000. And of cource, if I have 10 MDB files, it will spawn 10 threads within the DTS SQL server. (This is all done programmatically).

Could this be the issue where DTS Com Components are running in Single-Threaded Apartment while CLR is running in Multi-Threaded Apartment ?

Hope you can help me out on this. It has got me thinking night and days...

Here's my sample code trying to force it running in STA, but when i check it in the onStart Method, threads are still running in MTA mode.

<br />
static void Main()<br />
{<br />
Thread t = new Thread(new ThreadStart(WorkerThread));<br />
t.ApartmentState = ApartmentState.STA;<br />
t.Start();<br />
}<br />
<br />
static void WorkerThread()<br />
{<br />
ServiceBase.Run(new System.ServiceProcess.ServiceBase[] { new TestSvc() });<br />
}<br />

Note:- this is a window services that use a FileWatcher Component/Timer Component. It basically detects any activities in the folder and then picks up the mdB files and start processing and saving it as a DTS Package, then executes it.

But I'm not even sure if Threading Apartment State is the issue here.
Hope to hear back from all the dts gurus out there.

Stanley

Re: DTS and C#

stan288-Oct-04 2:44

stan28

8-Oct-04 2:44

Hi Gurus,

I managed to solve this mystery puzzles.
I just want to share with the c# community as to how this problem is fixed.

Now first of all, the problems described aboved has nothing to do with not having enough memory or hd space. The reason why this is happening is due to DTSLookups. Now, my production server is running on w2k Advance Server, and my testing server is on windows 2003 (since we're moving in this path).

On the w2k environment, the dts code works. But, it doesn't work with the w2003 environment. To workaround this issue, I have basically, removed all the DTSLookups and introduce another extra steps (stor procedure) to do what the lookups was doing. Up to this point, no more com exception errors, once the workaround has been implemented. Roll eyes | :rolleyes:

Note:- The error description thrown here is meaningless.

Stanley

Where to start database programming

Bob Stanneveld23-Sep-04 5:38

Bob Stanneveld

23-Sep-04 5:38

Hello,

For a project of mine, I need a database. I installed SQL server 7, and created the database in it.

Now I need to acces the database in my application. I quickly decided that it would be best if I used a class to represent the database in my application. My knowledge about programming a database ends here...

My program is written in C++ (and a part of it uses MFC). The application is a NT Service and needs to be connected to the database.

I would like to know wich classes I should use to create my own database interface (class that handles the connection and such with the actual database). I would like a general approach so that it is easy to build support for other databases as well.

Thanks in advande.

Multiply it by infinity and take it beyond eternity and you'll still have no idea about what I'm talking about.

Re: Where to start database programming

David Salter23-Sep-04 11:52

David Salter

23-Sep-04 11:52

Have a look at these ODBC classes. Hopefully they'll help.

http://www.codeproject.com/database/caaodbcclass.asp

store your internet favourites online - www.my-faves.co.uk

Re: Where to start database programming

Bob Stanneveld24-Sep-04 0:01

Bob Stanneveld

24-Sep-04 0:01

Thanks alot, this is just what I need.

Multiply it by infinity and take it beyond eternity and you'll still have no idea about what I'm talking about.

Convert SQL server database to script file

Mekong River23-Sep-04 1:30

Mekong River

23-Sep-04 1:30

Hi, i usually create a script file in SQL query analyzer to create database, create table... in SQL server. But now I have design my database in SQL server using wizard (interface). I would like to know, how could I convert my structure of my database in to a script file that could be use in SQL query analyser? if it is possible it is very easy for me to distribute my database via a diskette.

A thousand mile of journey, begin with the first step.

APO-CEDC
Save Children Norway-Cambodia Office

Re: Convert SQL server database to script file

Colin Angus Mackay23-Sep-04 3:17

Colin Angus Mackay

23-Sep-04 3:17

In the Enterprise Manager navigate to your database. Then right click the database entry in the tree on the left and select All Tasks-->Generate SQL Script...

Follow the wizard to ensure that all the elements you want to script are output.

Do you want to know more?

Not getting the response you want from a question asked in an online forum: How to Ask Questions the Smart Way!

Re: Convert SQL server database to script file

Mekong River24-Sep-04 4:39

Mekong River

24-Sep-04 4:39

Thank you very much, I will try it latter. Smile | :)

A thousand mile of journey, begin with the first step.

APO-CEDC
Save Children Norway-Cambodia Office

hello

Asha Rams22-Sep-04 20:44

Asha Rams

22-Sep-04 20:44

hai i am working a project where i have to get a excel format on my VC++ dialog based application from the database by a click of a button. please help in this

Re: hello

sreejith ss nair23-Sep-04 2:01

sreejith ss nair

23-Sep-04 2:01

hi,

Please be little more specific. D'Oh! | :doh:

**************************
S r e e j i t h N a i r
**************************

Re: hello

Asha Rams23-Sep-04 16:08

Asha Rams

23-Sep-04 16:08

hai nair, let me explain ,that what i want to do . I have a dialog based application which has to get data from the database in an excel format by a click event . which is similar to the datagrid Active X control where we can ADD , DELETE and UPDATE the record .
My project is related to a call center where they have a shift roster , in this the key is the shift time , So I have to get data from the database in a excel format , for a particular shift time the number agents working and there area of stay , the shift roster that is the [ Date working and leaves details]

Backing a DataBase up

BanksySan22-Sep-04 16:00

BanksySan

22-Sep-04 16:00

Hi,

I have a database which is being developed as the application which uses it is and so is being changed very regularley. How can I copy the database into another location on the server to back it up?

Dave Banks

Re: Backing a DataBase up

David Salter22-Sep-04 23:03

David Salter

22-Sep-04 23:03

What database?

I imagine you would need to shut the database down temporarily if you want to copy it elsewhere.

store your internet favourites online - www.my-faves.co.uk

DataTableMapping problem. Don't get return values

3sL22-Sep-04 4:15

3sL

22-Sep-04 4:15

Having made an app with a type-safe dataset. In this set there are two datatables 'Contract' and 'Contract1' which are identical. When I insert a record from the second DataTable with my stored procedure into the database, it results two result-sets 'Table' and 'Table1'. This is correct, but the only not working thing is that I don't get one column ie ContractNummer. This is made read-only in the DataTable. It is filled in the database with a after-insert-trigger and returned from the insert-procedure. Why cannot I get this value? When it comes from the first DataTable 'Contract', it strangeally works fine. Al the names and the amount of names are correct. Can you tell give me a clue? Thanks very much. Here is my code for the TableMapping-section:

DataTableMapping dtm1, dtm2;
dtm1 = oDa.TableMappings.Add("Table", "Contract");
dtm2 = oDa.TableMappings.Add("Table1", "Contract1");

dtm1.ColumnMappings.Add("ContractID", "ContractID");
dtm1.ColumnMappings.Add("Contractnummer", "Contractnummer");
dtm1.ColumnMappings.Add("Titel", "Titel");
dtm1.ColumnMappings.Add("BeginDatum", "BeginDatum");
dtm1.ColumnMappings.Add("EindDatum", "EindDatum");
dtm1.ColumnMappings.Add("BUID", "BUID");
dtm1.ColumnMappings.Add("TyperingID", "TyperingID");
dtm1.ColumnMappings.Add("KlantID", "KlantID");
dtm1.ColumnMappings.Add("Omschrijving", "Omschrijving");
dtm1.ColumnMappings.Add("MantelID", "MantelID");
dtm1.ColumnMappings.Add("PDF", "PDF");

dtm2.ColumnMappings.Add("ContractID", "ContractID");
dtm2.ColumnMappings.Add("Contractnummer", "Contractnummer");
dtm2.ColumnMappings.Add("Titel", "Titel");
dtm2.ColumnMappings.Add("BeginDatum", "BeginDatum");
dtm2.ColumnMappings.Add("EindDatum", "EindDatum");
dtm2.ColumnMappings.Add("BUID", "BUID");
dtm2.ColumnMappings.Add("TyperingID", "TyperingID");
dtm2.ColumnMappings.Add("KlantID", "KlantID");
dtm2.ColumnMappings.Add("Omschrijving", "Omschrijving");
dtm2.ColumnMappings.Add("MantelID", "MantelID");
dtm2.ColumnMappings.Add("PDF", "PDF");

try
{
oDa.Update(oDs);
oTrn.Commit();
}

Dries

ADO dBase: get delete status

Friedhelm22-Sep-04 3:48

Friedhelm

22-Sep-04 3:48

Hi Is it possible to have information about the delete status (marked as deleted or not) of a dBase record using ADO?

Friedhelm

default value

TehMedic20-Sep-04 23:41

TehMedic

20-Sep-04 23:41

I define a default value for my filed in SQL server.
but when i drag and drop thats table on my form, and then generate DataSet from its DataAdapter, its DataSet have not Default Value.
I can define a default value for it in xml schema, but i want do it automatically .
please help . thanks.

Re: default value

tdciDoug21-Sep-04 10:24

tdciDoug

21-Sep-04 10:24

I'm pretty sure you can define default values using table styles.

Re: default value

TehMedic26-Sep-04 23:08

TehMedic

26-Sep-04 23:08

i want to define default value in sql server table , without redefining it in dataset.

changing RowState of DataRow

TehMedic20-Sep-04 23:36

TehMedic

20-Sep-04 23:36

I want to change a RowState property of a DataRow from a DataTable manually.
in example , i want to change from "Unchanged" state to "Added" state.
thanks.

Last Visit: 31-Dec-99 18:00 Last Update: 29-Sep-24 22:28

Refresh

ᐊ Prev 1...2201 2202 2203 220422052206 2207 2208 2209 2210 Next ᐅ

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