I could be that the oracle 11 client is limited to Oracle 9.

*

Have to find my oracle support login as it is on metalink

not sure if there were servicenames in 7.2, it is probably a SID.

What are the results of oracle basic connectivity testing?

in command prompt:

tnsping myoldandtrusty

->shows location of the oracle tnsnames.ora location

->tries...

ALZDBA (9/18/2011)

---

SQLRNNR (9/18/2011)

---

ALZDBA (9/18/2011)

---

Lynn Pettis (9/18/2011)

---

bitbucket-25253 (9/17/2011)

---

Ninja's_RGR'us (9/17/2011)

---

Hey guys (als), I just got a bank offer for a 70% / 30% sql svr / oracle environement.

Now all I know about...

I would go with replication for the non-modified tables.

ETL (ssis?) for the modified.

Last kind was a weekly restore from live to dev.

Everything the developers wanted to be kept would be...

Congratulations Jeff! :smooooth:

Haven't heard of such.

What is the particular view name?

Is create view running inside a transaction? (perhaps rolled back by end of connection).

If you create a dummy view with the same...

Interesting opinion on moving things to the cloud.

I'm for keeping the current and historical separate for disaster-recovery situations (smaller database -> faster recovery, even other backup model (full vs differential)).

If...

Explanation:

I'm very new to tfs as it has been chosen as version-control environment for developers.

We are consolidating version control from ms sourcesafe and subversion to tfs in the hope to...

I would keep those separate in order to restore the live-db faster if the needs arise.

Take a picture of myself (historical moment) and throw a little party (don't invite Murphy).Update knowlegde on parameter technologies (.net/web,windows/network administration,ms access migration), checking the upcoming releases, having some polls....

As far I've read from the forums they aren't significantly different. (most was modified between 2000 & 2005). Check on the new features of 2008. (policy based management?, new types...

It is a paid update

Haven't got that problem yet (mix windows 2003 & sql server 2008).

Is windows 2003 fully up to date?

Have you tried sql server 2008 R2 service pack 1

For...

Also, which oracle-client did you install on the ms sql server?

Any clue where myFile comes from?

It looks like a databasecall (ToDatabase) passing up the connectionstring (Connect) and the sql to execute (MySQL). Or MySQL is a parameter/constant to indicate which...