Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    Regular Coder
    Join Date
    May 2005
    Posts
    129
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Lightbulb ASP working with SQL Server?

    Hi,

    Sorry by the lot of ignorance of my question, but I need working with large online databases: More than 50,000 records, pehaps 1,000.000 being visited by 500/1000 people by day!

    Some people said "for large databases or for a high traffic of visits use SqlServer". Thus, I would like to know the following:



    1. Can I use the scripts written in ASP for open tables/databases in MSACCESS to open databases in SQLServer?

    2. Do you know a good online tutorial for ASP+SqlServer?
    Thank you in advance

    JanLee

  • #2
    Senior Coder
    Join Date
    Nov 2002
    Location
    North-East, UK
    Posts
    1,265
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Unless you have specific Access Functions in your code then you can use the same, standard, SQL for SQL Server.

    Also, if you have any date/time functions then they would have to be rewritten.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •