473,327 Members | 2,094 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

ADP revision numbers

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
Jul 20 '05 #1
2 1448
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

Jul 20 '05 #2
Thanks, turns out the problem machine did not have
all the Service Packs up-to-date. Fixed now.

On Mon, 17 Nov 2003 14:39:32 GMT, "Jerry Boone"
<je***@antech.biz.nospam> wrote:
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.


Jul 20 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Richard Joseph | last post by:
I am looking for a method to keep track of revisions. I have developed many engineering database applications. Keeping tack of changes to fields is often required and I have never implemented a...
0
by: chris-list-python | last post by:
I'm using rcslib.py to massage an RCS repo. The code uses a "name_rev" object which acts two ways: 1. if it's a string, represents the head version of the file 2. if a tuple (name, rev)...
1
by: Burghew | last post by:
Hi All, I have 2 fields called document & Revision which contains the titles for the documents to be stored in the databse it gets filled up as the user enters them and the revison numbers...
4
by: Burghew | last post by:
Hi All, I have 2 fields called document & Revision which contains the titles for the documents to be stored in the databse it gets filled up as the user enters them and the revison numbers...
13
by: IndianaJonesWB | last post by:
I have an Access Project as a front end for a SQL DB. I have a master copy and distribute copies of it to my other users. I would like to display a revision count on the first Main Form so that...
2
by: Mark | last post by:
In the AssemblyInfo.cs page of a ASP.NET project, there is a defaulted property of: It's my understanding that this indicates a Major Version of 1, a Minor Version of 0, and a Build and...
4
by: Pietro | last post by:
Thanks for the last answer, but now how can i restart the count of the Build and Revision numbers of a dll in VS.Net. Thanks Pietro
4
by: johnk | last post by:
I have a table of items, with revision numbers. I need to extract the items with highest revision number. The items may be listed several times and I don't know what the highest revision number...
6
by: Jean-François Michaud | last post by:
Hello, I'm having trouble figuring something out. I have to reproduce a PDF output and in the original document, "revision indicators" are used to show which parts of the document have changed...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.