#1
  1. No Profile Picture
    Registered User
    ASP Explorer (0 - 99 posts)

    Join Date
    Dec 2012
    Location
    Chico
    Posts
    1
    Rep Power
    0

    SQL ERROR Server does not exist or access denied


    Hello everyone, this is my first post so hopefully I'm doing everything correctly. I have seen others with a smiliar issue but different enough that I wanted to post my problem.
    I am running a loop in Microsoft Access 2003 that is checking one view in SQL and updating another view. The record count being updated is about 60000. The loop starts perfectly and runs
    for a while updating records correctly and then suddently I receive the error "microsoft odbc sql server driver tcp/ip sockets sql server does not exist or access denied". I then start the loop again and
    it runs fine for a while until the same error message appears. I have had this problem off and on with various loops I've set up in my access database. Sometimes the entire loop works fine, even with large
    record counts, other times it does as I described and runs for a short while and then stops with the error. It seems like a network error but I can't track down any network problems to coincide with the
    appearance of the error. Any help would be greatly appreciated. Thank You.
  2. #2
  3. Contributing User
    ASP Skiller (1500 - 1999 posts)

    Join Date
    Mar 2005
    Location
    Columbus, OH
    Posts
    1,600
    Rep Power
    278
    Why you run that in Access, Why not on SQL server on SQl server everything will be done internally, No big communications, no network errors.
    GK
    __________________________________________________ _____
    if you found this post is useful click Give Rep button (bottom side on this reply ) and agree
  4. #3
  5. No Profile Picture
    Registered User
    ASP Explorer (0 - 99 posts)

    Join Date
    Jan 2013
    Posts
    1
    Rep Power
    0
    I think your Sql statement syntax is not correct, that is the reason of the error. When I created Sql statements I found good help to Sql templates here: SMS Gateway - Database user, SQL templates. It is quete specific since an OzekiSMS software uses the sql statments but I hope it will help you too.

Similar Threads

  1. Replies: 0
    Last Post: September 24th, 2009, 12:04 PM
  2. “Server does not exist or access denied….”
    By axisz in forum ASP Development
    Replies: 7
    Last Post: March 13th, 2007, 07:06 AM
  3. SQL Server does not exist or access denied
    By jmjyiannis in forum .NET Development
    Replies: 2
    Last Post: July 26th, 2005, 07:06 AM
  4. SQL Server does not exist or access denied.
    By twopecker in forum ASP Development
    Replies: 2
    Last Post: February 11th, 2005, 05:49 AM
  5. Replies: 2
    Last Post: February 4th, 2005, 02:18 AM

IMN logo majestic logo threadwatch logo seochat tools logo