| What the HELL have I gotten myself INTO with this JOB!!! :)
I ask myself the same thing every day ;)
| ------------------------------------------------------------
| "Well, whatever the latent intention here, please allow me to assist in
| whatever meager way I can.. While I was initially pleased by your opinion
| that "He seems to have very easily and simply found a solution"
| ,unfortunately in this case the problem is not directly addressed. The
| issue is not so much having the databases served at the same time, the
issue
| is having the database clients active at the same time. The database
| clients are the agents that retrieve data for web applications or any
other
| ODBC connection. Whether the databases are stated from a separate command
| on a single command, from the service manager or from the command prompt
| makes no difference. Therefore if I were to "action this now", nothing
| would change"
| ------------------------------------------------------------
I have no idea what he is on about.
| Todd, you mentioned that the database clients aren't even necessary to run
| on the server in order for an ODBC connection to work. But when I was
there
| and tried getting them to run without the database clients running, the
ODBC
| connection refused to connect. I don't know if this was because there was
| something wrong with the values I entered into the DSN settings or not.
Well .. I was speaking from an overly simplified standpoint and was also
talking more about 7.0 than 5.03. Anyway .. the point is, you CAN run 2
different clients from the same machine that connect to 2 different
databases that are either running on 2 different database engines, or the
same engine (as long as the database files are named differently). I know
you can because I just did it 2 minutes ago using an old copy of 5.05 that I
found still running on a machine. Like I said, on our *real* database
server, we have 14 databases all running at once under the same engine and
we have about 8 different web apps that connect to those 14 databases from 3
different machines. Also, I have 2 different web apps connecting to 2
different databases running under the same database engine on the machine I
am typing this e-mail from. I am staring right at the SQL server window and
it is showing me tha both databases are running. I am even able to connect
to both databases at the same time using Sybase Central and edit them at the
same time easily. I'm just not understanding where this guy is finding a
problem.
Maybe if you explained your setup to me, I could tell you exactly how to do
what you are trying to do.
| For a hoot..here is the DBA's "alternative solution" rofl.
| ----------------------------------------------------------------
| "As promised, I have another alternative to resolve the database issue.
| We can decide to stop the database client/requester on the media
| database and just run the client for the virtual agency.
|
| What would this mean?
|
| Well essentially it would discontinue all intranet / internet access to
| the media database which includes access to on-line schedules and client
| FTP authentication (this is necessary for Julie's project in Jamaica).
| Perhaps this could be done after the demonstration in Jamaica. Anyway
| in time, the programmer guy would develop an alternative means to
| authenticate ftp access.
|
| Since media department staff members all have individual clients, their
| operation would not be affected.
|
| Please let me know your thoughts on this alterntive."
| ------------------------------------------------------------------
Again .. I have no idea what he is talking about. Well, I know what he is
saying, but I still know why! :)
| "programmer guy" is me lol lol.
| Oh how the HELL did I get into this little turf war!!
They are secretly after your blueberry muffins.
Todd
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
