[THIN] Re: OT: question for you programmers - REVISITED
- From: "Shonk, Joe - Perot" <JShonk@xxxxxxx>
- To: thin@xxxxxxxxxxxxx
- Date: Fri, 12 Nov 2004 08:51:08 -0700
First off... The "..change a 'ton of code'" phrase should be your first
clue. If the guy knew how to program there wouldn't be a "ton of code" to
change. Only a few sub/functions would need to be modified to handle the
database connections.
Regardless if he is using DSN or DSN-less connections, he should NEVER
hardcode anything. That's what Registry settings and config files are for.
Joe
-----Original Message-----
From: Roger Riggins [mailto:roger.riggins@xxxxxxxxxx]
Sent: Thursday, November 11, 2004 2:01 PM
To: thin@xxxxxxxxxxxxx
Subject: [THIN] OT: question for you programmers - REVISITED
This is the problem I'm faced with:
I'd like to consolidate some of our servers and the programmers are
having a cow because they say it'll take three days to change a "ton of
code". I'm suggesting that from this point forward, we write our apps in
a way that will allow us to move apps/websites easily and without the
help of the programmers.
They are really fighting the idea of making any changes to the way they
code. This is a snippet from our discussion where he talks about
programming for his previous employer and used DSNs:
"Whether you have a DSN or DSN-less connection, those changes have to be
made in the code. We moved from one server to another, and they made the
DSN the same... However, we had to reset the include file to the new
DSN. In theory, it sounds good... It practicality, it doesn't work."
This seems like an inaccurate statement. Am I right in understanding
that as long as the system DSN is named the same and has the same path,
no change should have to be made in the code?
From my research, OLEDB connections offer a performance increase over
using system DSNs. At what point is it significant?
What about using .udl files? Is there a way to manage these? If so, it
seems this would be a good compromise.
Thanks for listening to my rambling... any help on this is appreciated.
Thanks,
R
-----Original Message-----
From: thin-bounce@xxxxxxxxxxxxx [mailto:thin-bounce@xxxxxxxxxxxxx] On
Behalf Of John Hardwick
Sent: Monday, November 01, 2004 3:37 PM
To: thin@xxxxxxxxxxxxx
Subject: [THIN] Re: OT: question for you programmers
Roger,
Both methods would accomplish your goal.
As a programmer their reference to DSN-Less connections allows for
easier machine portability as the connection information to the database
server is maintained within the program or an INI as they indicated.
Whereas a DSN probably system would make it easier for you to move the
destination SQL server. While it would also require you to create the
DSN on any machine the application would run on.
As a programmer I can understand their desire to control as much as
possible within their application while at the same time I can
understand your desire to make easy changes.
I've worked with applications that do both without any major problems...
it would be nice if someone developed a standard though.
But with that said either method should let you accomplish what you want
assuming that the connection string for the application can be modified
by you in an INI file.
- John.
John Hardwick
President
nXio, LLC.
913-754-8120 x125
www.nxio.net
-----Original Message-----
From: thin-bounce@xxxxxxxxxxxxx [mailto:thin-bounce@xxxxxxxxxxxxx] On
Behalf Of Roger Riggins
Sent: Monday, November 01, 2004 3:22 PM
To: thin@xxxxxxxxxxxxx
Subject: [THIN] OT: question for you programmers
Our programmers are writing web applications that connect to SQL
databases. We want it so that they can be moved to different IIS or SQL
servers as easily as possible. I thought that using either system of
file DSN's would be the way to go, but our programmers say:
" DSN is "hard wired" on the machine or server. DSN-less connections
mean I can access the database from any computer, anywhere. The
connection string is within the code, in an include file. The config
files will be used to put in database info, file locations and other
essential information so the info can be modified if required."
As a network administrator, I want to be able to move these apps without
any knowledge of the app itself or the code it was written in.
Can somebody please tell me what best practice is when writing these
apps?
Thanks,
R
********************************************************
This Weeks Sponsor Emergent Online ThinCity Conference
Join us at ThinCity 2004: The 1st Annual Emergent OnLine Technology
Conference
http://www.ThinCity.com
**********************************************************
Useful Thin Client Computing Links are available at:
http://thin.net/links.cfm
***********************************************************
For Archives, to Unsubscribe, Subscribe or
set Digest or Vacation mode use the below link:
http://thin.net/citrixlist.cfm
********************************************************
This Weeks Sponsor Emergent Online ThinCity Conference
Join us at ThinCity 2004: The 1st Annual Emergent OnLine Technology
Conference
http://www.ThinCity.com
**********************************************************
Useful Thin Client Computing Links are available at:
http://thin.net/links.cfm
***********************************************************
For Archives, to Unsubscribe, Subscribe or
set Digest or Vacation mode use the below link:
http://thin.net/citrixlist.cfm
********************************************************
This Weeks Sponsor Emergent Online ThinCity Conference
Join us at ThinCity 2004: The 1st Annual Emergent OnLine Technology
Conference
http://www.ThinCity.com
**********************************************************
Useful Thin Client Computing Links are available at:
http://thin.net/links.cfm
***********************************************************
For Archives, to Unsubscribe, Subscribe or
set Digest or Vacation mode use the below link:
http://thin.net/citrixlist.cfm
********************************************************
This Weeks Sponsor Emergent Online ThinCity Conference
Join us at ThinCity 2004: The 1st Annual Emergent OnLine Technology Conference
http://www.ThinCity.com
**********************************************************
Useful Thin Client Computing Links are available at:
http://thin.net/links.cfm
***********************************************************
For Archives, to Unsubscribe, Subscribe or
set Digest or Vacation mode use the below link:
http://thin.net/citrixlist.cfm
Other related posts:
