Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Barbara Peisch
  Where is Barbara Peisch?
 Oceanside
 California - United States
 Barbara Peisch
 To: Vivek Deodhar
  Where is Vivek Deodhar?
 SANGLI
 India
 Vivek Deodhar
 Tags
Subject: RE: Oracle connection problems
Thread ID: 393239 Message ID: 393647 # Views: 40 # Ratings: 0
Version: Visual FoxPro 9 Category: ODBC, ADO and OLEDB
Date: Saturday, December 21, 2013 2:18:16 AM         
   


> > Hey everyone,
> >
> > I'm trying to use ODBC to connect to Oracle 11g. I was using DRIVER={Microsoft ODBC For Oracle} in my connection string, but apparently that doesn't work with newer versions of Oracle. My connection string now looks like this:
> >
> >
lnHandle = SQLStringConnect("Driver={Oracle in OraClient11g_home1};Port=1523;Server=99.999.999.999;Database=mydatabase;Uid=myid;Pwd=mypswd;")
> > 

> >
> > This is supposed to be a DSN-less connection, but I'm getting "Data source name not found and no default driver specified" as an error. Anyone have any suggestions?
> >
> > -BP
> > www.peisch.com
>
>
> May be a problem of 64 bit vis a vis 32 bit driver?
>
> Vivek
>
> Live wisely... because in real world, there is no Ctrl + Z!

I got this resolved. You had it right. They had installed the 64-bit client and VFP couldn't use it. After installing the 32-bit client, it now works.

There's just one remaining problem. Although I specify a SERVICE_NAME in the connection string, it's popping up a dialog asking for the service name when I try to connect.

-BP
www.peisch.com

ENTIRE THREAD

Oracle connection problems Posted by Barbara Peisch @ 12/17/2013 3:48:51 AM
RE: Oracle connection problems Posted by Dranreb @ 12/17/2013 4:34:26 AM
RE: Oracle connection problems Posted by Barbara Peisch @ 12/17/2013 4:53:21 AM
RE: Oracle connection problems Posted by Dranreb @ 12/17/2013 6:21:48 AM
RE: Oracle connection problems Posted by Vivek Deodhar @ 12/17/2013 4:40:24 AM
RE: Oracle connection problems Posted by David Mustakim @ 12/17/2013 4:44:26 AM
RE: Oracle connection problems Posted by Barbara Peisch @ 12/17/2013 5:00:26 AM
RE: Oracle connection problems Posted by David Mustakim @ 12/17/2013 5:26:04 AM
RE: Oracle connection problems Posted by Barbara Peisch @ 12/17/2013 5:38:14 AM
RE: Oracle connection problems Posted by David Mustakim @ 12/17/2013 5:41:57 AM
RE: Oracle connection problems Posted by Barbara Peisch @ 12/17/2013 5:47:14 AM
RE: Oracle connection problems Posted by David Mustakim @ 12/17/2013 5:50:17 AM
RE: Oracle connection problems Posted by Barbara Peisch @ 12/17/2013 4:56:36 AM
RE: Oracle connection problems Posted by Barbara Peisch @ 12/21/2013 2:18:16 AM
RE: Oracle connection problems Posted by Vivek Deodhar @ 12/21/2013 6:39:37 AM