Search results for query: *

The reason is I'm using outer joins both right and left. The requirement is have SQL database independent, ie this SQL needs to work on any database. SQL Server uses this syntax *= or =* for Outer Joins Oracle uses +. These are very specific syntax. No that is not the requirement that they...

Hi All, I have an issue with an SELECT statement: I'm using ANSI SQL with a lot of outerjoins and they need to be compatible with SQL Server and Oracle. The problem is there a criteria screen that contains multiple parameters that need to be passed. Using the "Where" for the...

Managed to get the connection up and running. Here's how I did it: Installed the Oracle client-created a DSN name and point through my global.asa ConnDB.OPEN APPLICATION("DSN"), APPLICATION("Username"), APPLICATION("Password") Thanks

Hi, Did you have to installed the Oracle Client on your web server? I know it's different for SQL Server. But I want to make sure before I do anything on the Web Server. Thanks

In order to access an Oracle Server, you need the client stored on the Web Server? or SQL*Net is it different for Oracle9i? Thanks

Thanks I'll let you know what happens! Nice statement at the bottom!

Hi Everyone, I seem to be having some issues with connecting to Oracle9i. Usually I use the following syntax to connect to Oracle and it works fine. Syntax: strConnection = "Driver={Microsoft ODBC for Oracle};SERVER=servername;UID=username;Pwd=password;Database=pubs" However now...

I finally got everything to work fine. Thanks for all your help.

Hi Thanks for the response. I did forget to put the form enctype and also forgot the Uploader.Upload. I have the saving of the file section working pretty good. However now I have to save data to the database. Specifically the file name I just uploaded. My database is outside the For loop...

File Upload - How Did you get this to work? I'm running into the same binary problems however when I ran the Uploader.Form("") nothing appeared. and the file was not recognized.