We help IT Professionals succeed at work.

link to a mdf database

Medium Priority
808 Views
Last Modified: 2013-12-16
ok so i created a MS SQL db , but now i cannot link to it.

 I WOULD like to create a database in my C:/Cfusion/wwroot folder and not in ProgramFiles/MicsoSQL/Data folder.

Is that possible? How? I cannot create a new database in anywhere but ProgramFiles/MicsoSQL/Data folder.

Now i have an mdf in wwroot, but it does not show in enterprise manager?

This is bothering me because i need to seelct it so i can create a super user for it , and then an ODBC datasource so i can use it with coldfusion.

I think it needs to be in my wwwroot to work for coldfusion
Comment
Watch Question

Author

Commented:
basically my site stopped working and i dont know why, all i did was change from access to sql (first experience with sql) and i have a host.

i posed the question aboce because now i am testing on my computer, the host took care of my sql stuff so the problem has to do with the code i used

all i i did was change


all instances of cfquery datasource="#Application.DataSource#"

to

cfquery datasource="#Application.DataSource#" username="xxxxxx" password="xxxxx"

I also changed my application.cfm file to

<cfset Application.DataSource = "blueprintdatabase">
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Commented:
I think it needs to be in my wwwroot to work for coldfusion -- No.  This does not matter, the ODBC connection takes care of the information.

This may sound like a stupid question, but:
Is your host providing a SQL-Server for your database to attach to at the other end ?
CERTIFIED EXPERT
Top Expert 2012

Commented:
Please maintain your many old open questions:

1 03/15/2003 25 link to 1000 outstanding points  Open Macromedia Flash
2 05/13/2003 270 Who is good at reading source code?? (10...  Open Macromedia Flash
3 07/24/2003 500 PAYPAL in FLASH  Open Macromedia Flash
4 07/28/2003 500 Need to add UPS Online Tools to my ecomm...  Open ColdFusion
5 12/13/2003 500 best credit card processing service for ...  Open ColdFusion
6 12/13/2003 500 payment processing  Open Web Servers
7 11/17/2003 500 360 viewer  Open Macromedia Flash
8 03/29/2004 500 Decrease File Size  Open Macromedia Flash
9 03/29/2004 500 MDF OR LDF  Open Microsoft SQL Server
10 03/30/2004 0 Converted MS Access Datasource to SQL  Open ColdFusion
11 03/30/2004 500 link to a mdf database  Open Microsoft SQL Server
12 03/30/2004 500 sql server not working  Open ColdFusion
13 03/31/2004 500 update query between access and mysql?  Open Mysql
14 03/31/2004 500 Cannot connect to mysql on localhost err...  Open Mysql
15 04/01/2004 500 error executing db query after moving to...  Open Mysql
16 04/01/2004 500 weird error message from calling a cfc  Open ColdFusion
17 05/12/2003 35 simple SELECT statement confusion....wha...  Open ColdFusion
18 06/12/2003 125 Copy contents of one table to another us...  Open ColdFusion
19 08/29/2003 500 Custom tags in a CFC??  Open ColdFusion
20 10/28/2003 500 Coldfusion Server Not Working because i ...  Open ColdFusion
21 11/25/2003 500 root variables?  Open Macromedia Flash
22 01/06/2004 500 finding the letter of my cd drive?  Open MS-DOS

Thanks

Commented:
No refund as finnstone never responded to the experts
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.