Multi Connections via C/ODBC ?

Comments

• Options

  BennyGiebens Member Posts: 43

  1999-12-16

  The only solution to my knowledge is to go via C/front.
  We have made a VB program for internal use, that uses any odbc source as an input and a navision table as output.
  
  Its the same as a dataport, with the exception that we can import directly from excel, access, Notes etc..... without having to convert to ascii file first.
  
  Rgds
  Benny Giebens

  Rgds
  Benny Giebens

  0
• Options

  db Member Posts: 82

  1999-12-16

  I don't think that good idea connect databases using ODBC, becouse it is slow. Did you can write to database by ODBC ?
  
  If you need connect two databases once per mounth:
  Create new databese & using copy/paste transfer data. This is cheepest & simplest way.
  
  If you need funcionality & speed or joining every day use replicating soft. There is a lot of choises. I have maded solution like this in C++.

  0
• Options

  Jem_Ahmet Member Posts: 27

  1999-12-16

  I have a database (with data) and other database (empty) but with renumbered objects -
  want to transfer data from db with OLD numbers to db with new numbers.

  0
• Options

  db Member Posts: 82

  1999-12-16

  If renubered only obj not fields there no problems from my program view. If renumbered fields this or field type there can by some problems. That for you are using new db ?

  0
• Options

  hreinn Member Posts: 8

  1999-12-16

  Is this a one off project ?
  If so just use a Dataport.

  0
• Options

  db Member Posts: 82

  1999-12-16

  You can't connect to db, because then your connection runs dbm.dll it locks API (fin.exe, ODBC or CF) to fdb. This is maded by NF for forbiding fdb share. Simple example:
  Try to run two fin.exe with diferent db. You can run same install, you need two installs of fin. The same thing with CF & ODBC.
  
  In your case I think the best solution can be:
  In new db make table with the same fields.
  Transfer to this table data from old db.
  Use C/AL make data transfer / conversation to others tables. If you will try to use CF you will meet trouble doing operations with some data types. Keep in mind that CF not strong in error detection, you must care about it by self. Don't forget all in win32 API all API's uses the same copy of dll, all NF dll's is one API oriented, they don't care that you calling from diferent API. Everywhere where you entering NF dll use mutexes or semaphores. There are many thin things.
  
  The best result I was received then used structure & used two PC:
  [fdb connector]<->[own TCP module]<- WAN /LAN ->[own TCP module]<->[fdb connector]

  0
• Options

  Jem_Ahmet Member Posts: 27

  1999-12-17

  I have Objects renumbered and Fields renumbered too.
  
  I cannot use dataport because existing fields are reordered - i have to manually design each tables data fields in first and in second database - very complex solution.
  
  I have tried using ODBC connection and CFRONT connection together - but same problem occured when connecting to 2 different databases, caused exception in dbm.dll.

  0