Steve: It has nothing to do with 1 through 8. It has to do with getting your application approved, who is going to own and maintain your file server and setting up user permissions when new users are added. Have your ever tried to have something restored from a backup in a very large corporation?
My applications serve a very small group within large corporations. They need to be flexible in that I need to be able to make business rule changes and update all of the sites in less than a day. It is interesting that you mention my value to the team. I AM considered part of the team for a majority of my customers. Many of the users don't even know that I am a contractor because I have been around longer than most of them. The teams I am part of are not IT teams, but the people that hire me and they really don't care about programs or databases. They just want the program to work so that people get paid properly or the accounting department gets their reports on time. I have a particular problem with one customer and I was asking advice from the best technical community and I got it. I do work with dba's and MSSQL Server for one customer but I would not survive if my arrangement with all of my customers was like theirs. Jeff Jeff Johnson [EMAIL PROTECTED] SanDC, Inc. 623-582-0323 Fax 623-869-0675 Stephen Russell wrote: > On Thu, Apr 10, 2008 at 9:50 AM, Jeff Johnson <[EMAIL PROTECTED]> wrote: > >> Gureumi and Bill gave me useful information - thank you! I have >> described the environment where my application lives and that I can't >> change it. I have a job because I can work in these environments. One >> of two major problems is that I can't install any data servers on the >> data file servers and I don't want to deal with the corporate dba's in >> order to use MS SQL Server. The second major problem is a 256k network >> with five to ten users on an intranet. During peak use the network can >> be very slow. >> > ----------------------------------------------------- > > I find this a standard out there as a hurdle "and I don't want to deal with > the corporate dba's in > order to use MS SQL Server. " > > I don't get why, is it that you don't > 1) Want to talke to them > 2) Understand what they are saying > 3) Understand the implications > 4) Know how to write change scripts > 5) Know how to index data properly > 6) How to fix broken queries > 7) how to update data that isn't xBase > 8) heck I could go on....... > > If they have a REAL database then it is in your better interest (financially > that is) to learn how to work with the people that are doing that for the > company today. I'm sure that if you told them the first part of this thread > they would seriously look at your value to the team. Sorry but any news > that you "can't do what others are doing" just puts a target on your back. > > the network could be slow because of DBF and CDX traffic. I remember > putting a sniffer on our network at Baker Donnelson when my reporting app > was putting together huge reports, 1400 page average at the time. My good > friend was the CNE so he could talk to me directly on how brutal the FPW app > was. That was 95-98 but I don't think that much has changed in reality for > dbf usage when tables are stored on the network, and the exe is run > locally. > > > > > >> Reasonable size files work just fine in this environment and this is >> just for one customer that does everything on a monthly basis. They are >> planning on upgrading their network connections in the future but I >> can't wait for that because they are dependent on the application now. >> > ---------------------------------------------- > > Can you tell us what a reasonable size file is in megs please. That will > help us all in aiding you. > > If you need some pointers on working with M$ Sql data I'll do whatever I can > to assist you. I did this a number of times from FPD, FPW, VFP5,6,7 > > I can help you work with your dba(s) so your stuff is usable as well as > performing at it's best. > _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

