Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Boudewijn Lutgerink
  Where is Boudewijn Lutgerink?
 Hoonaardstraat, Driel
 Netherlands
 Boudewijn Lutgerink
 To: Peter van Kooten
  Where is Peter van Kooten?
 ijMUIDEN
 Netherlands
 Peter van Kooten
 Tags
Subject: RE: Connections
Thread ID: 33294 Message ID: 34251 # Views: 3 # Ratings: 0
Version: Visual FoxPro 8 Category: Databases, Tables and SQL Server
Date: Thursday, December 11, 2003 8:12:28 AM         
   


> > > > > I have 2 databases DB1 and DB2 written in VFP8
> > > > > On DB1 is code written on the database events "OPENDATA"
> > > > >
> > > > > I want to create a connection from DB2 to DB1
> > > > > I receive the following message > Connectivity error: [Microsoft][ODBC Visual Foxpro driver]FIle was created in a later version of Visual Foxpro than the current version
> > > > >
> > > > > When I disable the database events on DB1 the connection is working fine
> > > > >
> > > > > I have Downloaded from MSDN the latest ODBC driver called VFPOLEDB.dll and installed in C:\Program Files\Common Files\System\Ole DB
> > > > >
> > > > > Who can help ????
> > > > >
> > > > WHat do you want to achieve? maybe you don't need a connection through OLEdB!
> > > >
> > > > Boudewijn Lutge®ink
> > > > Boudewijn.Lutgerink@foxite.com
> > > > A positive attitude may not solve all your problems, but it will annoy enough people to make it worth the effort.
> > > > Herm Albright (1876 - 1944)
> > >
> > > DB 1 is an employement /timeregistration database (User are logged in bij a card Reader)
> > > DB 2 is a task provider database
> > > So I want to create a view of Logged in user's and make it Visible in DB2 so that they can see all the task's
> > >
> > >
> > I guess that there is some field that can connect the two tables (logged and tasks in their respective DBC's).
> > What you can do is set a relation by hand between the two tables even though they are in different DBC's.
> > Use the "set relation to" command.
> >
> >
> > Boudewijn Lutge®ink
> > Boudewijn.Lutgerink@foxite.com
> > The music, played at a wedding, reminds me every time to music played when soldiers march to the frontier... (Heinrich Heine)
>
> Boudewijn,
> The promlem lies in the fact that I could not connect to DB1, I do not want to open the datyabase, but use a view from DB1
> When I have the view from DB1, I know that I can use Set relation to, but the error comes when I tray to make a connection to DB1
>

I got the feeling you make things harder for yourself then neccesary. But in the situation you describe you might consider using a cursoradapter.
In that case you retrieve the data directly through oledb (without the use of ODBC).
As said, I believe you make things harder then absolutely neccesary, if it is a spec for the app not to open db1 I would consider reviewing it.
Ask yourself WHY the DB1 may not be opened.

Boudewijn Lutge®ink
Boudewijn.Lutgerink@foxite.com
It's better to drive safely in five o'clock traffic than be featured on the six o'clock news.

ENTIRE THREAD

Connections Posted by Peter Kooten @ 11/24/2003 10:28:17 AM
RE: Connections Posted by Boudewijn Lutgerink @ 11/24/2003 10:46:57 AM
RE: Connections Posted by Peter Kooten @ 11/24/2003 2:16:51 PM
RE: Connections Posted by Boudewijn Lutgerink @ 11/27/2003 2:04:14 PM
RE: Connections Posted by Peter van Kooten @ 12/10/2003 3:28:53 PM
RE: Connections Posted by Ken Blum @ 12/10/2003 3:47:31 PM
RE: Connections Posted by Toms @ 12/11/2003 2:12:35 AM
RE: Connections Posted by Boudewijn Lutgerink @ 12/11/2003 8:12:28 AM