Hi

I have a question regarding ODBC.
We have some users who have installed Firebird ODBC 2.0.0.148.

We then have a 3. part program, which connects to the DB (which is version 2.1).
This program does one thing. It reads in some 20 tables and copy the content to a web server/homepage.
This routine runs every ½ hour.
This is a setup we have some 30 places I quess.

Besides the automatic routine I can start up an GUI, browse tables and see whats inside.

I have had a problem a one place.

I was able to start GUI and browse date.
But everytime the automatic routine should run, I got this error.

*************
24-09-2010 09:34:02 Openning connection to the database.
24-09-2010 09:34:02 Failed while connecting to the database: System.Data.Odbc.OdbcException: ERROR [08004] [ODBC Firebird Driver]unavailable database
at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)
at System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection connection, OdbcConnectionString constr, OdbcEnvironmentHandle environmentHandle)
at System.Data.Odbc.OdbcConnectionOpen..ctor(OdbcConnection outerConnection, OdbcConnectionString connectionOptions)
at System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.Odbc.OdbcConnection.Open()
at DWIWindowsService.DwiWindowsService.DoDataExchange()
*****************


The persons making this 3 part program tells me, that they connect the same way when I use GUI and browse tables or when the automatic routine is running.


Therefor I assumed that this was a problem inside there program.

They finally gave it a look and they told me is I use an ALIAS in the ODBC setup where I can type in the database instead of SERVER:PATH I wouldn't work.
This eventhough I could connect using TEST in the ODBC setup.


This to my sounds like pure BS.
Or is this me being wrong?

Regards
Michael