Professional Web Applications Themes

Database Connection thru FileDSN - ASP Database

I am new to ASP.NET . I am currently using file dsn to locate my ms access database using ASP. Is this also possible for ASP.NET? If yes, can you help me with the code? Mark...

  1. #1

    Default Database Connection thru FileDSN

    I am new to ASP.NET . I am currently using file dsn to locate my ms access
    database using ASP. Is this also possible for ASP.NET? If yes, can you help
    me with the code?

    Mark


    M P Guest

  2. #2

    Default Re: Database Connection thru FileDSN

    Well first some of theses newsgroup is for classic ASP none of that .net
    stuff (microsoft.public.inetserver.asp.db &
    microsoft.public.inetserver.asp.general). Second Microsoft has added
    ODBC (aka DSN) to it's list of Deprecated Components for the MDAC. The
    list of Deprecated Components for the MDAC can be found at the following
    address.

    [url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/ado_deprecated_components.asp[/url]

    This other link about classic ASP gives more info as to why you never
    should even consider a DSN connection in the first place.

    [url]http://www.aspfaq.com/show.asp?id=2126[/url]

    M P wrote:
    > I am new to ASP.NET . I am currently using file dsn to locate my ms access
    > database using ASP. Is this also possible for ASP.NET? If yes, can you help
    > me with the code?
    >
    > Mark
    >
    >
    joker Guest

  3. #3

    Default Re: Database Connection thru FileDSN

    "M P" <marktextguru.ph> wrote in message
    news:%23VovGMseEHA.704TK2MSFTNGP09.phx.gbl...
    > I am new to ASP.NET . I am currently using file dsn to locate my ms access
    > database using ASP. Is this also possible for ASP.NET? If yes, can you
    help
    > me with the code?
    I refer to this site quite a bit...
    [url]http://www.able-consulting.com/dotnet/adonet/Data_Providers.htm[/url]


    Mark Rae Guest

  4. #4

    Default Re: Database Connection thru FileDSN

    Sure it's possible. It is also possible to ride to work on a tricycle.
    However, a car is much faster. And almost anything is faster at connecting
    to a database than a file DSN.

    Access is OLEDB-compliant. Why don't you use the System.Data.OleDb classes,
    and skip the ODBC stuff?

    --
    HTH,
    Kevin Spencer
    ..Net Developer
    Microsoft MVP
    Big things are made up
    of lots of little things.

    "M P" <marktextguru.ph> wrote in message
    news:#VovGMseEHA.704TK2MSFTNGP09.phx.gbl...
    > I am new to ASP.NET . I am currently using file dsn to locate my ms access
    > database using ASP. Is this also possible for ASP.NET? If yes, can you
    help
    > me with the code?
    >
    > Mark
    >
    >

    Kevin Spencer Guest

Similar Threads

  1. connection database
    By mit83 in forum Macromedia Flash Data Integration
    Replies: 1
    Last Post: May 7th, 07:25 PM
  2. database connection
    By Chris Barber in forum ASP
    Replies: 31
    Last Post: June 9th, 08:43 PM
  3. mx7 connection to sql database
    By macandmo in forum Coldfusion Database Access
    Replies: 3
    Last Post: January 25th, 09:07 PM
  4. Using JET in a file dsn (FILEDSN)
    By groups1@rocketmonkeys.com in forum ASP Components
    Replies: 0
    Last Post: June 23rd, 01:03 AM
  5. connection to database
    By mj@leicester in forum Dreamweaver AppDev
    Replies: 3
    Last Post: March 17th, 03:19 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139