#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2003
    Location
    Guelph
    Posts
    16
    Rep Power
    0

    Recommended SQL Interfaces


    I am writing some ASP pages to interface with an MS SQL database (on a Win2k box). Does anyone have any recommendations on any tools that I can use to connect to the database and manage tables (create, drop, insert, etc)?

    Thanks,
    Anthony
  2. #2
  3. /(bb|[^b]{2})/

    Join Date
    Nov 2001
    Location
    Somewhere in the great unknown
    Posts
    5,163
    Rep Power
    792
    Just use the standard ADODB
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2003
    Location
    Guelph
    Posts
    16
    Rep Power
    0
    What's ADODB? How do I get it?
  6. #4
  7. /(bb|[^b]{2})/

    Join Date
    Nov 2001
    Location
    Somewhere in the great unknown
    Posts
    5,163
    Rep Power
    792
    ADO = ActiveX Data Object
    It is what ASP uses for database handling.
    See http://msdn.microsoft.com/library/de...ml/aspatoz.asp
    for more info
  8. #5
  9. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2003
    Location
    Guelph
    Posts
    16
    Rep Power
    0
    But I shouldn't need an ASP specific program should I? I have an MS SQL database installed on a server and I just want to access it so I can create, drop tables. Sorry, maybe I'm not making sense.
  10. #6
  11. /(bb|[^b]{2})/

    Join Date
    Nov 2001
    Location
    Somewhere in the great unknown
    Posts
    5,163
    Rep Power
    792
    Your accessing the pages through ASP therefore you will need to do it in ASP.
  12. #7
  13. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2003
    Location
    Guelph
    Posts
    16
    Rep Power
    0
    Okay, maybe I'm on the wrong track, which is quite possible since I'm new to web development. I have developed applications before using Java and C, connecting to MySQL databases. My database in those situations (like this one) was installed on a server. I used a program called SQLFront that allowed me to connect to the database. I then created a table using the desired schema. I then wrote Java classes and C code that would connect to the database and access that table.

    This is what I'm hoping to do now, but with an MS SQL database and eventually using ASP to access it. So I'm looking for a similar utility to first create and set up the table before I access it, load it with data and query it with ASP.

    Does this make sense or am I off?
  14. #8
  15. /(bb|[^b]{2})/

    Join Date
    Nov 2001
    Location
    Somewhere in the great unknown
    Posts
    5,163
    Rep Power
    792
    I don't know if there is a front end for SQL Server that you can get besides that which comes with SQL Server itself. You should be able to get the needed utitilties from the installation disk.
    The program that comes with SQL Server is called "Enterprise Manager" and will allow you to do what you want.
  16. #9
  17. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2003
    Location
    Guelph
    Posts
    16
    Rep Power
    0
    Okay, thanks for all your quick responses. I might be back for more help once I start trying to connect via ASP. : )
  18. #10
  19. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2003
    Location
    Guelph
    Posts
    16
    Rep Power
    0
    Originally posted by Onslaught
    Just use the standard ADODB
    Is this the ADODB provided for PHP (cause there seems to be LOTS of info out there on that)?
  20. #11
  21. /(bb|[^b]{2})/

    Join Date
    Nov 2001
    Location
    Somewhere in the great unknown
    Posts
    5,163
    Rep Power
    792
    There is two different things.
    One is the MS (which can be sometimes used in php) and the other is a database abstraction class which is excellent.

IMN logo majestic logo threadwatch logo seochat tools logo