HELP: VB DAO app reading from wrong database? 
Author Message
 HELP: VB DAO app reading from wrong database?

Hi All,

We've got a real puzzler at my current client site. Here's the problem:

Environment: VB 5 both Pro and Enterprise, DAO 3.6, Sql Server 6.5 with
latest SP, NT 4.0 sp 5.

Multiple databases: Test, Production, Development, Pilot, etc. and they
all have mostly the same tables and stored procedures on each. All are
Sql Sever 6.5.

Say application 1 pulls information from database 1, and app. 2 pulls
information from database 2.  Each database has the same tables with
different data (i.e. Test vs. Prod.).  Everything works fine until
nightly batch processing jobs (application 1 - FOXpro) are running
(several hours) on database 1 and then application 2 (VB5) is executed
during this time.  Now application 2 will return results from database
1 instead of database 2, where normally it does return information from
database 2?

Any ideas how this is happening. The obvious has been checked and fully
qualified table names including the database names don't fix the
problems.  This has happened with more than one application.

Does anyone know if this is a known problem with DAO and VB 5 (prof or
Ent. vers)?  I was hoping for some insight on a known problem and not
just 'upgrade to ADO' which may have to be done to fix this as a last
resort.

Any help...greatly appreciated!!

--
Mark H.,
-DBSolutions

Sent via Deja.com http://www.***.com/
Before you buy.



Thu, 03 Oct 2002 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Reading/Read MS Distributed Apps for VB 6?

2. help converting vb app from dao to ado

3. Help - Urgent - ADO Error in VB App with DAO

4. Help - Urgent - ADO Error in VB App with DAO

5. Help vb5 app to read/write access database under application control

6. Using dbase MDX Files in VB Apps w/DAO

7. VB DAO app needs SQL Server now....

8. VB 4 app using dao 3.5 slow on xp

9. (309)944 ISO help with VB database apps

10. Problem with VB/DAO app on localized version of Windows

11. Jet Error 3170 with DAO 3.5 and Access 95 in a VB app

12. New to VB: Best Database for VB app?


 
Powered by phpBB® Forum Software