EasyCFM.COM ColdFusion Forums / MS SQL Server Related Issues / MS SQL?

   Reply to Discussion | New Discussion << previous || next >> 
Posted By Discussion Topic: MS SQL?

book mark this topic Printer-friendly Version  send this discussion to a friend  new posts last

MIGhunter
03-06-2009 @ 4:26 AM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Senior Member
Posts: 570
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
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Moderator
Posts: 2398
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
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Moderator
Posts: 773
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
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Senior Member
Posts: 570
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
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Senior Member
Posts: 570
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
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Moderator
Posts: 773
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
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Senior Member
Posts: 570
Joined: Apr 2006

Thanks


Website Designed and Developed by Pablo Varando.