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


> > > > 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




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