School Assignment? Project Due Tomorrow? Chat LIVE With A Programming Expert!

Dream.In.Code > Programming Help > ColdFusion

Welcome to Dream.In.Code
	Become an Expert! Join 300,458 Programmers for FREE! Get instant access to thousands of experts, tutorials, code snippets, and more! There are 1,633 people online right now. Registration is fast and FREE... Join Now! Chat LIVE With a Expert

Access ColdFusion's Datasource's outside of the administrator

Access ColdFusion's Datasource's outside of the administrator

xheartonfire43x	27 Apr, 2009 - 11:18 AM Post #1
D.I.C Regular Joined: 22 Dec, 2008 Posts: 260 Thanked: 2 times My Contributions	I am building a website that people can sign up for and it will give them there own database but store their member information in one giant DB. Everything happens right on the website so far without me having to do anything except for add the datasource. Is there a way to add that from the site. I basically need it to do the query to build the DB and then add the datasource on CF Admin or through MS Windows Server 2K3's ODBC connector.
	This Post Was Helpful!

Register for Free to Make These Ads Go Away!

xheartonfire43x	RE: Access ColdFusion's Datasource's Outside Of The Administrator 29 Apr, 2009 - 09:13 AM Post #2
D.I.C Regular Joined: 22 Dec, 2008 Posts: 260 Thanked: 2 times My Contributions	I figured it out. You can check out my thread on SitePoint at SitePoint.com
	This Post Was Helpful!

sansclue	RE: Access ColdFusion's Datasource's Outside Of The Administrator 29 Apr, 2009 - 10:54 AM Post #3
D.I.C Regular Joined: 21 Nov, 2007 Posts: 316 Thanked: 28 times My Contributions	QUOTE(xheartonfire43x @ 29 Apr, 2009 - 09:13 AM) I figured it out. You can check out my thread on SitePoint at SitePoint.com Yipes! Why would you want to work in the master database??
	This Post Was Helpful!

xheartonfire43x	RE: Access ColdFusion's Datasource's Outside Of The Administrator 29 Apr, 2009 - 11:43 AM Post #4
D.I.C Regular Joined: 22 Dec, 2008 Posts: 260 Thanked: 2 times My Contributions	QUOTE(sansclue @ 29 Apr, 2009 - 10:54 AM) QUOTE(xheartonfire43x @ 29 Apr, 2009 - 09:13 AM) I figured it out. You can check out my thread on SitePoint at SitePoint.com Yipes! Why would you want to work in the master database?? I need to be able to drop databases on the fly. I know it is scary, but this site has it's own dedicated SQL server and I have made sure that it is locked down dang good.
	This Post Was Helpful!

sansclue	RE: Access ColdFusion's Datasource's Outside Of The Administrator 29 Apr, 2009 - 11:50 AM Post #5
D.I.C Regular Joined: 21 Nov, 2007 Posts: 316 Thanked: 28 times My Contributions	QUOTE(xheartonfire43x @ 29 Apr, 2009 - 11:43 AM) I need to be able to drop databases on the fly. I know it is scary, but this site has it's own dedicated SQL server and I have made sure that it is locked down dang good. That is different than what you initially described a) create databases and b ) create datasources. The first you can do with sql and the second with the administrator API. So you are not working in the master database all the time? Because that would be scary as a) it means you are running an account with uber permissions and b ) that database is critical. If you accidentally hose it, you are dead in the water .. and I hope you have lots of recent backups. This post has been edited by sansclue: 29 Apr, 2009 - 11:51 AM
	This Post Was Helpful!

xheartonfire43x	RE: Access ColdFusion's Datasource's Outside Of The Administrator 30 Apr, 2009 - 05:17 AM Post #6
D.I.C Regular Joined: 22 Dec, 2008 Posts: 260 Thanked: 2 times My Contributions	QUOTE(sansclue @ 29 Apr, 2009 - 11:50 AM) That is different than what you initially described a) create databases and b ) create datasources. The first you can do with sql and the second with the administrator API. So you are not working in the master database all the time? Because that would be scary as a) it means you are running an account with uber permissions and b ) that database is critical. If you accidentally hose it, you are dead in the water .. and I hope you have lots of recent backups. That stuff was what I was starting with. But my needs have changed. I back up my SQL Server every day and it is a SQL Server dedicated to this App, because someday we hope that it is huge, but for now it won't be that big.
	This Post Was Helpful!

sansclue	RE: Access ColdFusion's Datasource's Outside Of The Administrator 30 Apr, 2009 - 07:45 AM Post #7
D.I.C Regular Joined: 21 Nov, 2007 Posts: 316 Thanked: 28 times My Contributions	QUOTE(xheartonfire43x @ 30 Apr, 2009 - 05:17 AM) That stuff was what I was starting with. But my needs have changed. I back up my SQL Server every day and it is a SQL Server dedicated to this App, because someday we hope that it is huge, but for now it won't be that big. If the master database gets corrupted, you may have to reinstall sql server itself. But I suppose it is your funeral ;-) Good Luck
	This Post Was Helpful!

xheartonfire43x	RE: Access ColdFusion's Datasource's Outside Of The Administrator 30 Apr, 2009 - 07:53 AM Post #8
D.I.C Regular Joined: 22 Dec, 2008 Posts: 260 Thanked: 2 times My Contributions	QUOTE(sansclue @ 30 Apr, 2009 - 07:45 AM) If the master database gets corrupted, you may have to reinstall sql server itself. But I suppose it is your funeral ;-) Good Luck Well is there another way to be able to drop databases on the fly without using the Master?
	This Post Was Helpful!

sansclue	RE: Access ColdFusion's Datasource's Outside Of The Administrator 30 Apr, 2009 - 10:34 AM Post #9
D.I.C Regular Joined: 21 Nov, 2007 Posts: 316 Thanked: 28 times My Contributions	QUOTE(xheartonfire43x @ 30 Apr, 2009 - 07:53 AM) Well is there another way to be able to drop databases on the fly without using the Master? You can drop a database from anywhere, as long as it is not in use. The point isn't do not _ever_ use the master database. It is to use the master database _only_ when necessary. Since I don't understand what you're trying to achieve here anymore.. whether you are using it correctly or not is anyone's guess.
	This Post Was Helpful!

Fast Reply

Reply to this topic

Start new topic

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

Time is now: 11/8/09 02:09AM

Invision Power Board v2.1.7 © 2009 IPS, Inc.

Licensed to: MediaGroup1

Advertising | Terms of Use | Privacy Policy | About Us | Site Map

Advertise on this site through Lake Quincy Media

Forum Index: Programming Help | C and C++ | VB6 | Java | VB.NET | C# | ASP.NET | PHP | ColdFusion | Perl and Python | Ruby | Databases | Other Languages | Game Programming | Mobile Development | Software Development | Computer Science | Industry News | Programming Tutorials | C++ Tutorials | Visual Basic Tutorials | Java Tutorials | VB.NET Tutorials | C# Tutorials | Linux Tutorials | PHP Tutorials | ColdFusion Tutorials | Windows Tutorials | HTML/JavaScript Tutorials | CSS Tutorials | Flash Tutorials | Web Promotion Tutorials | Graphic Design & Photoshop Tutorials | Software Development Tutorials | Database Tutorials | Other Language Tutorials | ASP.NET Tutorials | Game Programming Tutorials | WPF & Silverlight Tutorials |

Copyright 2001-2008 MediaGroup1 LLC, All Rights Reserved
A MediaGroup1 LLC Production - Version 6.0.2.1.36
Server: secure2

Search^Updated!w00t

Over 509,000 Pages! Advanced Forum Search

Live Help!

Be Social

Tutorials

Programming

Web Development

Reference Sheets

Code Snippets

DIC Chatroom

Join our IRC Chat

Bye Bye Ads

Monthly Drawing

Top Contributors

Top 10 Kudos This Month