Search results for query: *

Hi Paul, The script is a cgi routine that connects to Oracle9i 64 bit. The same routine worked under 8i but I found a thread that pointed to a problem with 9i. Essentially, the LD_LIBRARY_PATH environment variable needs to be set to point at the 32bit oracle library. The script will fail at...

Hi There, I want to be able to set LD_LIBRARY_PATH in my perl script and have the use methods know that this is where they should look for libraries. But if I put $ENV above use, the use method still does not find what I am looking for. Obviously the way the script is parsed means that the...

Sorry about the delay in getting back but I have been very busy on other things. I will give a high level detail and if you need more, I promise to monitor the thread closely over the following week. First of all, you require the following components -> A Perl CGI-script to handle the access...

We have implemented this at our site using LDAP, and Perl CGI. If you are still interested send a post and I will give you more info. It is quite complex but once its set up, there are few problems

Hi There, Is it possible to have SQL Server try to sort in memory first before looking at tempdb as an option. I have a relatively small database table ( in comparison to RAM) and it hits tempdb with many sorts. I was hoping to be able to have it look at memory as an option similar to say...

Hi Ram, I will put something together tomorrow in detail. Is that OK. Regards Chris

Hi There, You need an Oracle ODBC driver AND the Oracle SQLNET installed on the client. The ODBC driver is usually on the SQLNET install disk. Once SQLNET is installed, set up your tnsnames to be the same as that of you Unix host. The ODBC connection is then the same as any...

Hi There, I have a 3rd party procedure that has a structure and an integer as a row_count. If I pass say 3 to the row_count, I am meant to get back an array of structures up to 3 rows. If I pass 1 and simply pass a structure, I get back 1 row. If I pass 2, my VB app dies. How...

Hi There, I have recently written a pilot application using PB6 and SQL Anywhere. PB does not cater for some lower level things I need to do now. I want to convert to C++ and a flat file database ( indexed if possible). Instead of a file for each table, I was hoping to do...