You can also specify this connection string directly in the AVG TCP Server configuration file 

(avgtcpsv.ini), modifying the setting DatabasePath. 

Restart the AVG TCP Server for the changes to take effect 

Should there be any problems with the connection to the MS SQL Server, you can inspect the 

Application Event log or the log file named avglog.log in the AVG TCP Server program directory. 

d)

ODBC access from workstations 

It is also possible to access the AVG DataCenter in MS SQL Server directly from workstations without 

using the AVG TCP Server. However, this will require that all workstations have MDAC installed and 

configured. The configuration is same as for the AVG TCP Server.  

The AVG clients will then use connection string in the form of 

DSN=AVGAdmin;UID=;PWD= 

rather than the standard HTTP connection string. 

7.12 AVG DataCenter on Firebird SQL Server 

By default, the AVG TCP Server uses a special embedded version of the Firebird SQL Server database 

engine. If there is a standalone Firebird SQL Server already installed in the network, it is also possible to 

connect to it, using existing infrastructure and tools. Again, either AVG TCP Server can connect to the 

Firebird server, or the AVG clients can connect directly using the native access libraries. The latter option 

requires that all AVG clients have already all Firebird client access libraries installed, and properly 

configured. Therefore we strongly recommend configuring the AVG TCP Server only, and having all AVG 

clients connected to the AVG TCP Server via HTTP. 

The default AVG database AVGDB.FDB can be used in this mode too. This database is created during AVG 

TCP Server installation. On the other hand, you can create all needed tables with SQL scripts included in 

your AVG Anti Virus distribution. This way you can create tables also within an existing database. 

Firebird database installation script is created during the installation (once this option is activated). For 

script execution and corresponding tables creation, any SQL client applications (such as ISQL) can be 

used. We recommend restricting AVG TCP Server (or clients') access rights for the database part 

containing the AVG DataCenter only. 

For AVG TCP Server to connect to an existing Firebird server it is necessary to modify the database path 

in the AVG TCP Server configuration. Open the configuration within the AVG TCP Monitor using the 

Configuration button, and modify the Database path to: 

: 

where server_name is name of the server with Firebird SQL Server and database_path is full path to 

the database file. Please note that Firebird SQL Server requires the path specification without spaces. 

Generally, the so called  short pathname  should be used. 

For example, if the Firebird SQL Server is running on a server named dbserver, and the database file is in 

c:\avgdb\avgdb.fdb, the database path string would be 

dbserver:c:\avgdb\avgdb.fdb 

If the Firebird SQL server runs on a same computer as the AVG TCP Server, a special server name 

localhost can be used, too: 

localhost:c:\avgdb\avgdb.fdb 

If all workstations have the Firebird SQL client library installed, AVG clients can also connect directly to 

the Firebird SQL Server. In this case it is only necessary to change the connection string in AVG clients 

to 

Copyright (c) 1992 2005 GRISOFT, s.r.o. All rights reserved. 

85