OleDbConnections to Access

Discussion in 'Databases' started by stopfalseal, Feb 17, 2003.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. I am programming in Visual Studio.Net and use OleDbConnection's to Access.

    Normally I drag the OleDataAdapter onto the page and the select the database that I want to connect to through the data adapter connection wizard.

    But since this only works on a local server, I am at a loss as how to connect to a database on your server.

    I also have tried to connect to my local server using a DSN but I have not been able to make that work. I have used ASP pages and have connected to the database using DSN's before, but no luck with aspx pages.


    H. Clements
     
  2. Bruce

    Bruce DiscountASP.NET Staff

    Hi,

    See this posting

    http://forum.discountasp.net/topic.asp?TOPIC_ID=21



    quote:Originally posted by stopfalseal

    I am programming in Visual Studio.Net and use OleDbConnection's to Access.

    Normally I drag the OleDataAdapter onto the page and the select the database that I want to connect to through the data adapter connection wizard.

    But since this only works on a local server, I am at a loss as how to connect to a database on your server.

    I also have tried to connect to my local server using a DSN but I have not been able to make that work. I have used ASP pages and have connected to the database using DSN's before, but no luck with aspx pages.


    H. Clements
    </blockquote id="quote"></font id="quote">
     
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page