Reply to: Has Oracle always been this naff?

[TheFaQQer]

Yes, I had that "problem" myself.

In suity's defence, SQL Developer now ships with the 11g R2 client installer which is what he's actually using. I do need to install that myself later so I'll have an experiment and see if I can balls it up as much as he has.

Didn't realise that it was now part of the 11g client as well - I didn't install it from there when I did the client install in January.

[TheFaQQer]

Yes, I had that "problem" myself.

In suity's defence, SQL Developer now ships with the 11g R2 client installer which is what he's actually using. I do need to install that myself later so I'll have an experiment and see if I can balls it up as much as he has.

Some of the features in 3.1 look quite tasty as well, but I daren't try that in case I have problems with installing it and I don't know what to do.

[doodab]

I pointed it to java.exe and it ran fine.

Yes, I had that "problem" myself.

In suity's defence, SQL Developer now ships with the 11g R2 client installer which is what he's actually using. I do need to install that myself later so I'll have an experiment and see if I can balls it up as much as he has.

[Mich the Tester]

In Suity's defence, I've just tried installing SQL Developer 3.

I downloaded the version which didn't come with the JDK, and unzipped everything.

I ran sqldeveloper.exe and it asked me for a path to java.exe





















I pointed it to java.exe and it ran fine.

Ah, I see the problem here; you should always get a female assistant to 'unzip everything'.

[TheFaQQer]

In Suity's defence, I've just tried installing SQL Developer 3.

I downloaded the version which didn't come with the JDK, and unzipped everything.

I ran sqldeveloper.exe and it asked me for a path to java.exe





















I pointed it to java.exe and it ran fine.

[TheFaQQer]

There's instructions? It was just the win32 client install. Click setup.exe, next, next, next, done. Alles. Kaput.

FWIW, SQL Developer doesn't have a "Client install".

That said, the downloads page gives you a few options. Looks like you downloaded the one that says:

Oracle SQL Developer for 32-bit Windows (This zip does not include a JDK)
(147 M)

To install and run:
- Ensure you have a JDK installed, if not, download here
(click the Download for JDK 6 Update <xx>, where <xx> is the latest update)
- Download the file above
- Extract sqldeveloper.zip into any folder, using folder names
- Within that folder, open the sqldeveloper folder
- Double-click sqldeveloper.exe

I can understand that from that you might not realize that you need a JDK. I blame Oracle for hiding it in plain sight.

[suityou01]

It does say in the instructions that you need the JDK. Did you read the instructions?



Just saying like

There's instructions? It was just the win32 client install. Click setup.exe, next, next, next, done. Alles. Kaput.

[doodab]

Dear Twunt,

You need more than just the JRE, you need the JDK. And when you install it, and point SQL Developer at the relevant java.exe it then falls over saying MSVCRT100.dll is missing.

So you have to manually copy that from the java/bin to the SQL Developer folder.

Shoddy product IMHO. Hey ho. You never have to arse around looking for the releveant .Net DK and move dlls around to run a .Net app. Just saying like.

Oh and FOAD.

TIA

Suity

It does say in the instructions that you need the JDK. Did you read the instructions?

Before you install SQL Developer, look at the remaining sections of this guide to see if you need to know or do anything else first.

Just saying like

[d000hg]

Isn't your DLL error telling you you need the MSVC runtimes installed? Or is that a slightly different DLL?

[suityou01]

No most people will already have a Java runtime installed and you really don't want multiple Java runtimes on computer.

Either way another tulip statement from SY.

As a contractor toad is great I've used it for 10 years. I doubt however that SY could afford to buy it.

Dear Twunt,

You need more than just the JRE, you need the JDK. And when you install it, and point SQL Developer at the relevant java.exe it then falls over saying MSVCRT100.dll is missing.

So you have to manually copy that from the java/bin to the SQL Developer folder.

Shoddy product IMHO. Hey ho. You never have to arse around looking for the releveant .Net DK and move dlls around to run a .Net app. Just saying like.

Oh and FOAD.

TIA

Suity

[TheFaQQer]

Sounds familiar but I'm not sure - it basically does a kind of "remote-desktop"/thin-client link to the DB? Is this the one which is a Java app?

SQL Developer is written in Java so it's platform agnostic. I run it on Windows in a VM and also natively on Linux Mint and on Oracle Enterprise Linux.

There is also a public site where you can file enhancement requests, which shows how many they have implemented and (I think) what they think about the requests. There's lots of resources and tips as well.

And it's free.

[russell]

They don't connect using ODBC so no

Visual Studio 2010 can connect through the server explorer to Oracle or any ODBC datasource.

[Spacecadet]

Out of interest... do the MS dev tools let you work against non-MS DBs? Obviously you can hook your code to any ODBC DB, but their dev tools were pretty nice when I tried the express version of 2005/2008.

They don't connect using ODBC so no

[d000hg]

SQL Developer - which Suity can't get to work.

Sounds familiar but I'm not sure - it basically does a kind of "remote-desktop"/thin-client link to the DB? Is this the one which is a Java app?

Out of interest... do the MS dev tools let you work against non-MS DBs? Obviously you can hook your code to any ODBC DB, but their dev tools were pretty nice when I tried the express version of 2005/2008.

[Freamon]

I'll have a look at SQL Developer. We use Toad here. Frankly though I think Oracle is a piece of tulipe.

In the process of replacing it with Netezza.

Poor man's Teradata.