VisualWorks and Oracle DB

Hi,

Does anyone know the minimal steps to access a remotely situated Oracle DB from VW?
I think that the last time I tried, at that time from a Windows XP box, I had to install several different dll:s and configure a lot. But it was like four years ago so I don't remember the details.
I just want to experiment a little and I am not able to spend a lot of time on this issue and preferable I want to avoid installing the Oracle DB on my own box.

Best Regards,
Björn

_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc

_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc

There is a package from Oracle called "Oracle Instant Client" for several platforms and OS versions. It contains a set of DLLs that you can copy into your application directory, one of them the oci.dll. So you don't need to install anything, just copy these files.
If the current directory is in your search path this should work.

HTH

Thomas


Am 20.06.2012 10:21, schrieb Björn Eiderbäck:

Hi,

Does anyone know the minimal steps to access a remotely situated Oracle DB from VW?
I think that the last time I tried, at that time from a Windows XP box, I had to install several different dll:s and configure a lot. But it was like four years ago so I don't remember the details.
I just want to experiment a little and I am not able to spend a lot of time on this issue and preferable I want to avoid installing the Oracle DB on my own box.

Best Regards,
Björn

_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc

_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc

If you do that it'll find the libraries yes but it still doesn't get you connected. See my june 12 threat on the same subject.

I manage to get connected to Amazon's RDS services from a Windows box where I have a full Oracle XE installed but not from OSX where I installed the latest instant client.

Did you tested this ?

 

Regards,

@+Maarten,

 

 

-----Original Message-----
From: "Thomas Brodt" <[hidden email]>
Sent: Wednesday, 20 June, 2012 11:34
To: [hidden email]
Subject: Re: [vwnc] VisualWorks and Oracle DB

There is a package from Oracle called "Oracle Instant Client" for several platforms and OS versions. It contains a set of DLLs that you can copy into your application directory, one of them the oci.dll. So you don't need to install anything, just copy these files.
If the current directory is in your search path this should work.

HTH

Thomas


Am 20.06.2012 10:21, schrieb Björn Eiderbäck:

 

Hi,

Does anyone know the minimal steps to access a remotely situated Oracle DB from VW?
I think that the last time I tried, at that time from a Windows XP box, I had to install several different dll:s and configure a lot. But it was like four years ago so I don't remember the details.
I just want to experiment a little and I am not able to spend a lot of time on this issue and preferable I want to avoid installing the Oracle DB on my own box.

Best Regards,
Björn

_______________________________________________ vwnc mailing list [hidden email] http://lists.cs.uiuc.edu/mailman/listinfo/vwnc

_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc

We mostly use the instant client for our deployed application at many sites because it doesn't (theoretically) interfere with installed oracle software. As we deploy on windows only, I only can speak about this, and it works quite well.

I tried to connect to your database using your connect information from windows (vw7.6) and it worked, it returned the message "invalid password" ;-).

the exception log in your blog for your OSX logon attempt seems to miss a the first function (init) in the DLL, which may be a version mismatch or a dll load dependency problem with required libraries which results in this error.
The raised exception doesn't seem to have a parameter, but the error handler assumes one. So it's hard to say anything without live stack information.

Thomas



Am 20.06.2012 16:26, schrieb [hidden email]:

If you do that it'll find the libraries yes but it still doesn't get you connected. See my june 12 threat on the same subject.

I manage to get connected to Amazon's RDS services from a Windows box where I have a full Oracle XE installed but not from OSX where I installed the latest instant client.

Did you tested this ?

 

Regards,

@+Maarten,

 

 

-----Original Message-----
From: "Thomas Brodt" [hidden email]
Sent: Wednesday, 20 June, 2012 11:34
To: [hidden email]
Subject: Re: [vwnc] VisualWorks and Oracle DB

There is a package from Oracle called "Oracle Instant Client" for several platforms and OS versions. It contains a set of DLLs that you can copy into your application directory, one of them the oci.dll. So you don't need to install anything, just copy these files.
If the current directory is in your search path this should work.

HTH

Thomas


Am 20.06.2012 10:21, schrieb Björn Eiderbäck:

 

Hi,

Does anyone know the minimal steps to access a remotely situated Oracle DB from VW?
I think that the last time I tried, at that time from a Windows XP box, I had to install several different dll:s and configure a lot. But it was like four years ago so I don't remember the details.
I just want to experiment a little and I am not able to spend a lot of time on this issue and preferable I want to avoid installing the Oracle DB on my own box.

Best Regards,
Björn

_______________________________________________ vwnc mailing list [hidden email] http://lists.cs.uiuc.edu/mailman/listinfo/vwnc

_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc

On 20.06.2012 10:39, Nowak, Helge wrote:

You need to install the local Oracle client (oci.dll) and use the OracleEXDI/OracleThapiEXDI for SQL. And Glorp or ObjectLens for OO-relational mapping.

 

HTH

Helge

I'd say as a usable minimum in addition to installing InstantClient, you also need to ensure a few environment variables have been set:
- TNS_ADMIN, pointing to where your tnsnames.ora file is located (unless you want to use basic connection info)
- NLS_LANG, with a valid Oracle locale.encoding which is compatible with VisualWorks. (at least a numerical format which uses . as delimiter, like AMERICAN_AMERICA, and an encoding such as UTF8 (which may or may not actually work correctly, VW does not understand AL32UTF8, which is the canonical Oracle name for "real" UTF8)).
- PATH, if you don't install oci in an automatically discoverable location of course.

Cheers,
Henry
_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc