ODBC/c/front connection

PoweRoy · 2006-01-26

well first post after searching the forum for a week

In the company we have a Navision server (c-side). The database is atm 5.5GB.
A lot of users use Acces and Business Objects to gather info from the database (reports/forms) and use the ODBC driver given.
But the problem is that it takes 30sec to do 1 SQl statement.
We got a couple of old handterminal's wich connect to the database with
ODBC but the connect closes after 1 statement. To have a-work-around, after each closing, 1 new one opens. Trying to get a minimum of 3 connections open. With the new handterminals theres a c/front VB connection implemented and this goed fast

The suggestion is try to tune the ODBC driver (is that possible) or/and to make a c/front driver on ur own.

I looked on the net and tried to find some example ODBC driver's but it isnt clear how to make one.
Meanwhile i have made a prog in visual c# .net with the cfront.dll to get information from the database. But to make a program like Business Objects... not have that much time.

so do u guys have any tips about making a c/front driver on ur own or how to tune a ODBC driver

edit:
navision 3.60
the program ExSion (addon for Excel) got a fast connection to the database (i believe own ODBC connection) but the lack of usefull things to make report in Excel and the size of the database isnt that a good choice.

kriki · 2006-01-26

[Topic moved from Navision forum to Navision Attain forum]

kine · 2006-01-27

The C/ODBC driver is slow by design. If you need to get data faster, use C/Front. Of course, you can still migrate to MS SQL and use MS SQL ODBC (of course, without flow fields etc.)

PoweRoy · 2006-01-27

thx for the reply

the migration to SQL is only as backup.

i found some topics here on this forum with these url's:
http://demiliani.com/blog/archive/2005/09/19/2965.aspx
http://www.codeproject.com/csharp/CSComTemplate.asp?df=100&forumid=76093&exp=0&select=905084
http://www.mibuso.org/forum/viewtopic.php?t=8156&postdays=0&postorder=asc&highlight=dll&start=0&sid=36947955f34e4e62bba5f6e4d3a5490b

i only have a sample c/front driver. i made in c# a project with the cfront.dll given. Load all the procedures/functions and call them in code for example listing all the company's this works.
but how can i make a c/front driver, so that i can connect from any software with the driver to the navision database? Only the 2nd url is for making a global Com driver. the 1 and 3rd are for making drivers inside navision atain to make some procedures for the data, not for making a connection.

ODBC/c/front connection

Comments

Categories