Bruce,
I feel your pain. I know exactly what your are talking about but can't
remember what I did that broke and fixed it for sure.
Hmm, this may be a long shot, but you might want to run "cliconfg" and see
if your using the same default protocol on the client as it is on your dev
unit. Using Named Pipes might be what is causing it. If it is, you can
actually go into the Server Network Utility on the SQL Server and set your
default protocol to TCP/IP and your clients will follow that.
Also, I use integrated/domain security so I can deploy generic ADE's to my
users. Then, when they open, their windows credentials are used to auth
with Sql.
--
Jerry Boone
Analytical Technologies, Inc.
http://www.antech.biz
"Bruce Loving" <BR***@LOVINGSCENTS.COM> wrote in message
news:2c********************************@4ax.com...
I have an ADP connected to an SQL 2000 database that works fine on my
machine,
Opening the ADP show lists of stored procedures ala
up_ListPrograms
but, when I copy it to another computer, and open the ADP with the
same connection properties
all of the stored procedures and views have a ?revision? number after
them ala
up_ListPrograms,1
this breaks all my forms, reports etc.
anyone know if this can be controlled somehow?
Thans