Actually, the code for the local server in the VB program is:

cn_FmcAgvdbOhio = "Data PROVIDER=MSDASQL;driver={SQL Server};server=EAGLE2k\ALLANA;uid=;pwd=;database=FmcAgvdbOhio;"

The VB program code is:

cn_FmcAgvdbOhio = "Data PROVIDER=MSDASQL;DSN=AGVS1_a;uid=sa;pwd=;database=FmcAgvdbOhio;"

Note that I have the same DSN setup for the production server on the network - just one says "AGSV1", and...

PLEASE DO NOT BOTHER TO RESPOND TO THIS. Apparently, I was food deprived . I transposed two characters. Problem solved.

Thanks anyway.

Allan

Thanks for the info, Lawrence. However, I was hoping that there would be a way to reproduce the diagram itself. It doesn't seem possible at the moment -...

What happens in similar systems (which we are trying to improve in this new app) is: 1)Data is modified in SQL Server table. 2) Either a) App polls SQL...

I have a similar need. In my case, I'm running SQL Server 2000, Visual Basic 6.0 (and others are using Visual C++, as well). I need to set...

Since SQL 2K can store dates as early as '1/1/1753', when I need to reset a date to NULL (I wish :-)), I set it to '1/1/1754' (so that I...

Thanks. Here's the final version that works for me:

SELECT TOP 100 PERCENT Client_StaffID, PhoneMailID, PhoneNumber_Email, Extension, PhoneTypeID

FROM dbo.t_PhoneMail...