1. Welcome! Please take a few seconds to create your free account to post threads, make some friends, remove a few ads while surfing and much more. ClutchFans has been bringing fans together to talk Houston Sports since 1996. Join us!

Non-basketball post: Anyone know anything about asp or MS SQL Server?

Discussion in 'BBS Hangout' started by BuckeyeRocketFan, Jan 31, 2002.

Tags:
  1. BuckeyeRocketFan

    BuckeyeRocketFan Contributing Member

    Joined:
    Apr 19, 2000
    Messages:
    261
    Likes Received:
    18
    I'm just trying to find someone who knows a little bit about them. I am trying to fix a personal asp website that ties to a mdb file. But I can't pull up the mdb file in MS Access which is what I usually use to view mdb files. I am just trying to find out if the mdb extension works for SQL Server too.

    Thanks in advance for any help.

    Mike
     
    #1 BuckeyeRocketFan, Jan 31, 2002
  2. Francis3

    Francis3 Member

    Joined:
    Mar 29, 1999
    Messages:
    3,640
    Likes Received:
    3
    Whoa.. this is way to easy. Ill let someone else rip you. :eek:
     
    #2 Francis3, Jan 31, 2002
  3. Mango

    Mango Contributing Member

    Joined:
    Sep 23, 1999
    Messages:
    7,547
    Likes Received:
    1,980
    Is the mdb file that you are trying to pull up <i>local</i> on your computer or on a remote server?



    Mango
     
    #3 Mango, Jan 31, 2002
  4. Tb-Cain

    Tb-Cain Member

    Joined:
    Sep 15, 1999
    Messages:
    2,722
    Likes Received:
    64
    You can import Access databases into SQL Server. I'd be more concerned about why you can't open the MDB file in Access.
     
    #4 Tb-Cain, Jan 31, 2002
  5. 3Rings

    3Rings Contributing Member

    Joined:
    Apr 10, 1999
    Messages:
    415
    Likes Received:
    137
    I am a Access/SQL Server programmer.

    Upon opening the mdb with MSAccess, what is the error message?
     
    #5 3Rings, Jan 31, 2002
    Last edited: Jan 31, 2002
  6. Dr of Dunk

    Dr of Dunk Clutch Crew

    Joined:
    Aug 27, 1999
    Messages:
    45,185
    Likes Received:
    31,150
    Like the others have said, are you getting an error message when trying to open the MDB file in Access?

    If you're just trying to query a database trying to use something like SQL Query Analyzer, you can always set up a machine/system-level ODBC source that points to the MDB (provided it's not corrupted) and query it that way.

    But then I guess we need to wait for your response as to what the problem is first before anyone can help... :D
     
    #6 Dr of Dunk, Jan 31, 2002
  7. BuckeyeRocketFan

    BuckeyeRocketFan Contributing Member

    Joined:
    Apr 19, 2000
    Messages:
    261
    Likes Received:
    18
    Well, smack me with a wet newspaper and call me silly.

    I ftped the database down from the site using ascii mode rather than binary mode. So when I pulled the database up, it gave me wierd error messages.

    It is someone else's site I was trying to trouble shoot and help with and I only know a little bit about ASP and nothing about SQL Server so I was grasping at straws when I couldn't get an MDB file to work.

    Stupid mistake. Sorry to bother everyone.
     
    #7 BuckeyeRocketFan, Feb 1, 2002
  8. Dr of Dunk

    Dr of Dunk Clutch Crew

    Joined:
    Aug 27, 1999
    Messages:
    45,185
    Likes Received:
    31,150
    It takes a man to admit that. :eek:

    ;)
     
    #8 Dr of Dunk, Feb 1, 2002
(You must log in or sign up to post here.)

Share This Page

Toggle Width
Style
ClutchFans Original

  • About ClutchFans

    Since 1996, ClutchFans has been loud and proud covering the Houston Rockets, helping set an industry standard for team fan sites. The forums have been a home for Houston sports fans as well as basketball fanatics around the globe.

  • Rockets Content

  • Support ClutchFans!

    If you find that ClutchFans is a valuable resource for you, please consider becoming a Supporting Member. Supporting Members can upload photos and attachments directly to their posts, customize their user title and more. Gold Supporters see zero ads!


    Upgrade Now