ODBC connction to Visual FoxPro files impossible?

Classic Servoy
21

Sorry,I made an error when copying files from win32.

Now I’m able to open the database and to see remote server tables.

But I have to know 3 things:

  1. exactly what files I need from win32? I don’t want to copy all of them to end user machine.
  2. Servoy license permit to copy these files?
  3. How can I add all tables from my odbc source to remote server without the need to add proxy tables one by one?
22

What about my last questions?

23

a.mariottini:
Sorry,I made an error when copying files from win32.

Now I’m able to open the database and to see remote server tables.

But I have to know 3 things:

  1. exactly what files I need from win32? I don’t want to copy all of them to end user machine.
  2. Servoy license permit to copy these files?
  3. How can I add all tables from my odbc source to remote server without the need to add proxy tables one by one?
  1. We have created a support request with Sybase to find this out.
  2. Once we have 1) resolved we will post a package for this
  3. You can consider creating SQL statements (see documentation of iAnywhere for syntax) that do this.
24

Nothing new for questions 1 and 2?

25

We will soon post a download package with the additional files you need.

26

try this method:

CREATE SERVER madeleine //(replace madeleine by your remote server name)
CLASS ‘aseodbc’ //(replace by your remote server class)
USING ‘ase_madeleine’ // (replace by your user DSN used to connect to your remote)

CREATE EXTERNLOGIN DBA
TO madeleine // (replace madeleine by your remote server name)
REMOTE LOGIN sa

CREATE EXISTING TABLE “DBA”.“ess2” AT ‘madeleine;pubs2;dbo;ess2’

select * from “DBA”.“ess2”