I sent you my e-mail in your private messages section of your account.

If you are talking about a linked server then it's gonna be something like OracleServerName.DbName.Owner.Table.

How did you linked the tables?

I found another article but it seems to be only using linked server.

http://www.winntmag.com/Windows/Articles/ArticleID/22264/pg/1/1.html

BTW why can't you add a linked server to Oracle in your environement?

that's the only usefull information I found on oracle linked server in combinaison with the books online : http://www.sqlpass.org/Forums/messageview.cfm?catid=376&threadid=12178

near (provider='oraoledb';data source='oradbname', user id=scott;password=tiger)

I would help you further but...

Nice call cjensen... I missed that one.

This should do the trick (just removed First() and the having that didn't filter anything):

INSERT INTO Table1 ( [Application Field], CountOfApplication )

SELECT Software.Application AS [Application Field], Count(Software.Application) AS CountOfApplication

FROM Software

WHERE...

I don't understand what you are trying to accomplish, if you open notepad everytime the trigger fires it's gonna open notepad on the server (not the client's computer).

Why do you...

The only time you can use an aliased field name is in the order by clause... or if u are using it in a subquery

--order by

Select a*b-c as Calc1, SommeCol...

Maybe the length of one rows of the results goes over 8060 bytes (which is the maximum allowed by sqlserver). The data might be different from server to the...

This will do the trick (I posted this on another thread and that's exactly what you need since it's not dynamic SQL and it won't be limited by any number...

BOL = Books online (Microsoft help file for sql server).

If you can't use a linked server you can do something like this (this is for dbase IV but I'm sure...

I've been coding in asp with msaccess for quite a while and there's just no way of doing this task in SQL only with access. You really need the...

Do you mean that you want to open notepad everytime the trigger fires and write something in notepad?

Superfast set based query (0.093 sec for a table of 10000+ records of 40-50 characters):

CREATE TABLE [Numbers] (

[PkNumber] [int] IDENTITY (1, 1) NOT NULL ,

CONSTRAINT [Pk_Number] PRIMARY KEY...

I'm not sure I get your problem. Are you trying to use the same connection object to connect to another server or another DB and that isn't working or...