Best Practice question about database access between Dev and Production Servers

2012-01-28 Thread Brook Davies
Hello, I'm setting up a new environment and I would like to have the ability, through a web UI to copy objects from our production database (separate server) to a development/debugging database (separate server). My question is not about how to implement this but rather whether this is bad

Re: Best Practice question about database access between Dev and Production Servers

2012-01-28 Thread Mike Chabot
Putting production data source connections on the development server is a practice you should avoid. I cringe whenever I see developers do this. Having the development DSN on the production server is less risky. Another path would be having the two databases linked at the database level and use

Re: Best Practice question about database access between Dev and Production Servers

2012-01-28 Thread Russ Michaels
just take a copy of the live database and remove all sensitive data from it. either remove all data and replace with demo data, or just run a query that replaces the sensitive data with something else. On Sat, Jan 28, 2012 at 10:15 PM, Mike Chabot mcha...@gmail.com wrote: Putting production

RE: Best Practice question about database access between Dev and Production Servers

2012-01-28 Thread Bobby Hartsfield
-Original Message- From: Brook Davies [mailto:cft...@logiforms.com] Sent: Saturday, January 28, 2012 4:02 PM To: cf-talk Subject: Best Practice question about database access between Dev and Production Servers Hello, I'm setting up a new environment and I would like to have the ability

Access database - Access Problem

2004-03-22 Thread Mickael
Hi All, I am trying to read an access database that is in a shared folder on our network.When I try to set up a DSN I get this error Connection verification failed for data source: Elms []java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][SequeLink Server]Required user name is missing.

RE: Access database - Access Problem

2004-03-22 Thread Philip Arnold
From: Mickael I am trying to read an access database that is in a shared folder on our network.When I try to set up a DSN I get this error Connection verification failed for data source: Elms []java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][SequeLink Server]Required user

Re: Access database - Access Problem

2004-03-22 Thread Mickael
Subject: RE: Access database - Access Problem From: Mickael I am trying to read an access database that is in a shared folder on our network.When I try to set up a DSN I get this error Connection verification failed for data source: Elms []java.sql.SQLException: [Macromedia][SequeLink

RE: Access database - Access Problem

2004-03-22 Thread Philip Arnold
From: Mickael I am the only one working on the database, too early for anyone else :).The Database didnot have a user name or password assigned to it.Is there a default password that Access assigns? Not Access, but the datasource username and password in the CFAdmin Just in case these

Re: Access database - Access Problem

2004-03-22 Thread Mickael
What is strange it that is works fine on CF5 and only errors on CFMX. - Original Message - From: Philip Arnold To: CF-Talk Sent: Monday, March 22, 2004 8:51 AM Subject: RE: Access database - Access Problem From: Mickael I am the only one working on the database, too early

RE: Access database - Access Problem

2004-03-22 Thread Dave Watts
I am trying to read an access database that is in a shared folder on our network. If the CFMX service is running as SYSTEM, it won't be able to see network shares. You'll need to run CFMX as a user with permissions to network resources. Dave Watts, CTO, Fig Leaf Software

SQL 7 Database Access From Solaris Version of CF

2000-12-15 Thread Robert Forsyth
We are evaluating how our websites run on NT versus Solaris. What do I need on the CF/Solaris side to connect with my NT/SQL7 Database? I tried using the Merant default MSSQL Driver and it can verify the datasource but it does not get any data and throws errors when the page is executed.

RE: Database access problem

2000-05-18 Thread Tim Bahlke
If you're using Win98 there is fix at the Allaire site that might fix the problem. -- Tim Bahlke thinkcreate.com P: 336.230.0575 -Original Message-- From: "Peter Tilbrook" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: May 16, 2000 11:05:03 PM GMT Subject: RE

RE: Database access problem

2000-05-17 Thread Shally Kon
al Message-- From: "Peter Tilbrook" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: May 16, 2000 11:05:03 PM GMT Subject: RE: Database access problem Have you installed the Microsoft Data Access software? (see http://www.microsoft.com/data). Also have you already setup your ODBC co

Database access problem

2000-05-16 Thread Fernando
This is a multi-part message in MIME format. --=_NextPart_000_00C4_01BFBF42.643058A0 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Hi! My problem is that when I try to access to my database from the = Studio 4.5 resource tab, in

RE: Database access problem

2000-05-16 Thread Peter Tilbrook
Have you installed the Microsoft Data Access software? (see http://www.microsoft.com/data). Also have you already setup your ODBC connections? : quoted-printable Hi! My problem is that when I try to access to my database from the = Studio 4.5 resource tab, in localhost, i get an error

Database Access

2000-03-29 Thread Mark Jones
I am designing a system where users log in to see data and can update add and delete the data. What I was wondering is whether or not it is possible to tell which user id has edited the database. For instance, is it possible for a user to access the database according to his/her user id and

Re: Database Access

2000-03-29 Thread Chris Tazewell
ot; [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 29, 2000 4:03 PM Subject: Database Access I am designing a system where users log in to see data and can update add and delete the data. What I was wondering is whether or not it is possible to tell which user id has edited th