Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Anders Altberg
  Where is Anders Altberg?
 Uppsala
 Sweden
 Anders Altberg
 To: Vicos Vicos
  Where is Vicos Vicos?
 Oltenita
 Romania
 Vicos Vicos
 Tags
Subject: RE: Oracle 11G ConnectionString
Thread ID: 345172 Message ID: 345200 # Views: 42 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: General VFP Topics
Date: Sunday, May 20, 2012 12:50:23 PM         
   


> Local cConnString As String
> nOracleHandle = SQLStringConnect([Provider=MSDAORA.1;Password=***;User ID=vicos;Data Source=localhost ;Persist Security Info=True])
>
> nOracleHandle return -1. Why?
>
>
> Vilciu Constantin
> http://expertsoft.eu

Because SQLSTRINGCONNECT() is a function that implements ODBC connectivity, and your string is for OLEDB connecrtivity, as I understand things.
Microsoft's OLEDB is an ObjectOriented version of the procedural ODBC industry standard.
Please re-read my previous post, slowly.

-Anders

ENTIRE THREAD

Oracle 11G ConnectionString Posted by Vicos Vicos @ 5/19/2012 1:58:48 PM
RE: Oracle 11G ConnectionString Posted by Anders Altberg @ 5/19/2012 2:54:54 PM
RE: Oracle 11G ConnectionString Posted by Vicos Vicos @ 5/19/2012 5:03:30 PM
RE: Oracle 11G ConnectionString Posted by Anders Altberg @ 5/20/2012 12:50:23 PM
RE: Oracle 11G ConnectionString Posted by tushar @ 5/19/2012 7:33:19 PM
RE: Oracle 11G ConnectionString Posted by David Kurniawan @ 5/21/2012 10:09:48 AM