Citadel databse query problem

[gcrowell]

I am having trouble with querying data from a Citadel DB on a remote computer.  I set up the OBDC data source and tested the connection.  Everything works good up to that point. 

When I create a new query in Excel, the connection to the remote Citadel DB times out.  It works fine when I query a Citadel DB on the local machine. 

I have turned off the firewall on both machines and have no trouble browsing to the files on the remote machine.  It seems to me to be a networking issue or a services issue.

Does anyone have any ideas?

[Brinoceros]

Hi gcrowell,

What you need to do to make standard SQL queries to a remote Citadel database depends on which version of Citadel you are running.  For more information on this, we a have a great article that goes through all of the considerations (see the first section for information on Citadel 4):

Citadel 5 Remote Database Access Using COM+ and ADO

I hope this helps!

[mikeporter]

Is there a reason that you are using ODBC? ADO is more efficient. Can you create a UDL that defines a connection to the database? Also, for what its worth, the "Citadel" database is actually running the free version of SQL Server. Does the instance of SQL Server of the remote machine have remote connections enabled?

Mike...