ColdFusion Tutorials - EasyCFM.COM

Senior Member
Posts: 510
Joined: Apr 2006

I have a datasource on my server that was implemented by my phpBB forums. I didn't set it up, otherwise I would have used MySQL since I'm used to it. Anyway, how can I access the database. What I am wanting to do is access the members table so that I can use the username and password information on our main site. The problem is I have no clue what the structure is for the members tables. In MySQL, I can use phpMyAdmin to get the info. Is there a program out there like phpMyAdmin for MS SQL?

megan

03-06-2009 @ 7:27 AM

Moderator
Posts: 2371
Joined: Jan 2003

see if this article helps you
http://coldfusion.sys-con.com/node/42001

also if it is sql server 2000 you can use enterprise manager to manage the database / if it is sql server 2005 then you will have to use management studio

also you could get a free copy of SQL Manager Lite from http://www.sqlmanager.net/ and use that

hth ~megan

-------------------------------------------------------
If you have a hobby you love, then you can create a profitable online business
that gives you an autopilot income stream in 30 days or less

nmiller

03-06-2009 @ 7:56 AM

Moderator
Posts: 756
Joined: Apr 2003

You can download sql 2008 express for free here: http://www.microsoft.com/express/sql/

This includes the database engine itself, as well as enterprise manager, which is how you connect to a running server.

Nathan Miller
NM Consulting

MIGhunter

03-09-2009 @ 4:27 AM

Senior Member
Posts: 510
Joined: Apr 2006

Well, I tried that coldfusion template and got:

Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'uidv'.

I also tried ms sql manager lite. I can't get it to connect. I think I'm doing something wrong ><

MIGhunter

03-09-2009 @ 7:46 PM

Senior Member
Posts: 510
Joined: Apr 2006

I can't seem to connect to my stuff. Fusionlink says there is a bug in 2008 that won't let you connect to 2005. What can I use to connect to a 2005 database?

nmiller

03-10-2009 @ 8:10 AM

Moderator
Posts: 756
Joined: Apr 2003

With sql 2005

http://www.microsoft.com/Sqlserver/2005/en/us/express.aspx

Nathan Miller
NM Consulting

MIGhunter

03-10-2009 @ 10:46 PM