Web Based Manager

[neofactor]

Is there a web based manager like mySQL/PHP has?

How do you setup clients to use SQL? Do they all have to install the Enterprise Manager Client tool? Doesn't that require a licence per user?

I thought there was a coldfusion tool that did this?!

Anyways.. please let me know how you have clients access SQL remotely.

Thank you.
David McIntosh

http://www.neofactor.com

Have a nice day!

 

[tlbroadbent]

I'm not familiar with the web-based manager you mentioned. Does it allow administration of MySQL from a web browser? I've seen a number of ads for web-based SQL Server administration tools but haven't used any myself.

Users do not need the SQL Server client tools (Enterprise Manager, Query Analyzer, etc.) to access SQL Server. There are many ways to access the data - VB, C++, Java, ColdFusion, ASP, PHP, MS Access, FoxPro, etc. All clients will need MDAC which is installed with several Windows versions. MDAC can also be downloaded from Microsoft or installed from the SQL Server setup disk.

What kind of application will your users be using? Will they be accessing SQL Server from the web or internally over a LAN? If the users are coming in over the web, all they need is access to the web pages. The web server will need the proper components installed to access SQL Server. If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

 

[neofactor]

Im confused as to excactly what MDAC is.
All I say was updates and patches but no application.

Is this a tool that would allow users on an NT machine access the SQK database using their assigned usename and password?

I also have a few Macs that want to access the SQL server and develop thaie own tables in the DB.

Any advise?

David McIntosh

http://www.neofactor.com

Have a nice day!

 

[tlbroadbent]

Microsoft Data Access Components (MDAC) contains the drivers and components necessary to connect to SQL Server.

If your users are developers, then they can the SQL Server Client tools for their work. The client tools do not have separate licensing but do require proper SQL Server licensing by your company.

I don't know what is available for the Mac.

Most of your questions can be answered by reading the product documentation. You'll find much more detail in the manuals than anyone will want to post in this forum.

BTW: The website for neofactor.com claims expertise in SQL Server 2000. Are you new to neofactor or does the web site overstate the capabilities of neofactor? If neofactor has experts in SQL Server integration, perhaps you should be talking to them. If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm