Connection string for oracle 9i

[phita]

Hi,
I want to create a connection to an oracle database through code. I am able to achieve this using a DSN. Is it possible to create a connection string that refers to the database directly, without using a DSN?
I am using Oracle 9i and VFP7.
This is how I am creating the connection string. It works fine, but when I try to access a view, it opens the "Select Data Source" dialog box.

CREATE CONNECTION myconn ;
CONNSTRING "DBQ=MyDatabase;UID=User;PWD=Password"

Thanks in advance.

 

[Mike Lewis]

Phita,

Your approach is basically correct. The actual string you need will be something like this:

"Driver={Microsoft ODBC for Oracle};Server=OracleServer.world;Uid=Username;Pwd=asdasd;"

I obtained this information from the excellent website:

http://www.connectionstrings.com/

Mike


Mike Lewis
Edinburgh, Scotland

My Visual Foxpro web site:

http://www.ml-consult.demon.co.uk

My Crystal Reports web site:

http://www.ml-crystal.com

 

[phita]

Mike,
Thanks. Let me give this a try.

Thanks again.

 

[rgbean]

Another excellant source for connection strings is

http://www.able-consulting.com/ADO_Conn.htm.

Rick

 

[amy88]

Thanks,

Based on what you said, I took a closer look at the DSN configuration and discovered a slight difference in the data source name. The computer where the prog was not running had an inappropriate <space> in the data source name. The <space> was not in the data source name on other computers. So when the prog ran on the computer with the <space>, it didn't recognize it.

Obviously, I didn't see the <space> when I made the first comparison of the ODBC setup.

 

[amy88]

Sorry, I posted the last comment to the wrong thread -- duh!