Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 305 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
ODBC/c/front connection
PoweRoy
Member Posts: 43
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.
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.
0
Comments
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
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.