AGG Software Forums
September 20, 2024, 03:38:48 AM *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
News: Welcome on our forum!
 
  Home Help Search Login Register  
  Show Posts
Pages: [1]
1  Online Help Center / Data loggers and plug-ins / Re: ODBC connection: no data input into SQL DB... on: October 22, 2013, 11:54:36 PM
Thanks very much, Arthur, for your reply!

Your hints didn't work out as they should, but it lead me to the conclusion.
The ANMEADL service needs to be run in the same user account context as
you use to configure the ANMEADL configuration. Its a bit strange, though
the ODBC connection is configured as system DSN, not user DSN.
But anyway, it works now! Hope this may help someone else...

Cheers - sfl33
2  Online Help Center / Data loggers and plug-ins / ODBC connection: no data input into SQL DB... on: October 20, 2013, 12:25:43 PM
Hi folks,

i got the following situation:

Advanced NMEA Data Logger 2.7.3 build 526 (short reference ANMEADL)
Installed on a fully patched windows 7 x64, runs smoothly.

1 single configuration for port COM8 (USB GPS Device). No problem.

Data acquisition is perfect, GPS data logged into a local logfile on drive D:. So far perfectly.

Additionally ODBC configuration specified to only insert $GPRMC data into a SQL 2012 Express SP1 local database. Runs perfectly.

ANMEADL configured to run as a windows service, including option to allow interactive communication with the desktop/logged-on user activated (!!).

But now the problem:
--------------------
As long as i have the GUI opened and run (while the service is stopped), data insert into the SQL Database works perfectly.
But as soon as I close the GUI and start the service, there's no new data exported into the SQL Database, but still ANMEADL goes on protocolling into the local log-(txt)-file.

My assumption is that there's something wrong with the ANMEADL service selecting/reading the data export module (ODBC). Am i wrong? Any proposals or even solutions? Any help? why does the service not log into the SQL Database through the ODBC module...?

now please don't tell me that thats by design, that only the SQL Database Professional module is capable of doing so...

thanks for any advices!

sfl33, switzerland
Pages: [1]
Powered by SMF 1.1.21 | SMF © 2015, Simple Machines