OleDbConnections to Access

[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

[bruce]

Hi,

See this posting

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



[b]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">