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: 345174 # Views: 57 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: General VFP Topics
Date: Saturday, May 19, 2012 2:54:54 PM         
   


> I did connect to Oracle 11g server with DataExplorer.app
>
> DataExplorer connection string is:
> [Provider = MSDAORA.1, Password = ***; User ID = vicos; Data Source = 127.0.0.1; persist Security Info = True].
>
> I tried to use with SQLStringConnect, but return -1 with the error:
> Connectivity error: [Microsoft] [ODBC Driver Manager]
> Data source name not found and no default driver specified.
>
> Can someone help me?
>
> Vilciu Constantin
> http://expertsoft.eu

If 127.0.0.1 doesn't work as a reference to your own computer try localhost or your Computername, as returned in SYS(0).
And remove spaces at = and ; in the string.

'Provider' is for OLE DB, and is used with a VFP CursorAdapter object or directly with
oDBConn = CREATEOBJECT('ADODB.Connection') 
oDBConn.ConnectionString=...


For ODBC connection strings see www.connectionstrings.com/oracle. VFP's ODBC is implemented in VFP's 15 SQL~ functions. See Help.
oConn=SQLSTRINGCONNECT(...)

VFP's remote views use an ODBC connection.

-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