Luis Cazares (11/4/2016)

---

Don't think of tables. You need to start by thinking on entities, attributes and relationships. Create an ER model before even thinking about tables.

Designing a DB is not...

Have a look at trace flags 1200, 1204 and 1222. For your post you will find them extremely useful....

crk5070 (12/20/2014)

---

TNSNames..... I feel bad for you. There are a couple things to try.

-Make sure tnsping works.

-The tnsnames.ora file needs to go in the network/admin folder. If it's in another...

g.britton (5/15/2015)

---

Alas, I don't think you can run DESC over OPENQUERY, since it is not a SQL command. I think you can only do that with the SQLPLUS command....

There is no osql -L for Oracle but you can use TNSPING to check connectivity if you know...

Hi,

the question is more than a little vague to be honest.

if you use the SSMA to migrate the EXAMPLE Schema from Oracle to SQL Server 2016 it performs the process...

Hi,

if you Google "Oracle Data Access Components" you get exactly the link you need.

Since I have been able to convince the developers that OLE-DB is a vast improvement over ODBC...

FridayNightGiant (10/3/2016)

---

ZZartin (10/3/2016)

---

Hmm... the interface for oracle is pretty primitive and very similar to mysql, I hope you like command line 🙂 But on the back end in terms of...

Eric M Russell (5/20/2015)

---

Mr Corn Man (5/20/2015)

---

...

In addition to this query, part of the solution required me to add a registry DWORD value for the OraOLEDB.Oracle provider. That registry value...

Hi,

SSRS is not Cluster capable and as far as I know never was.

The only way of installing it on existing Cluster nodes has been explained here:

1. Install SSRS on...

Hi Sue,

thanks.....the tip was perfect.

I had opened the RS Configuration Manager with "Run As Administrator" and foolishly assumed that selecting the links would open up Explorer accordingly.

Many, many thanks!

Now...

Hi,

thanks for the tip but I have tried that. I have also tried opening the browser in Edge, IE and Firefox but nothing seems to be working.

Regards,

Kev

Hi,

The Problem is resolved.

The SQL Agent User had a different language Setting to that in the database. It was resolved by inserting SET LANGUAGE ENGLISH at the start of...

NorthernDBA (7/4/2016)

---

sometimes the easiest things...

do you have checked if the database engine service is running?

Do you have changed the TCP Port?

Have you changed any configuration in db Config?

Windows Firewall...

Consider as well that if you have a named instance installed and not a Default instance you Need to Suffix the Server Name with the instance.....

In SQL2014 TCP/IP is enabled...