Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problems connecting to an access database

Status
Not open for further replies.

Christi444

Technical User
Aug 6, 2001
3
US
I am learning ASP.net...and having a problem connecting to a database from a remote server...all the tutorials I see assume you are connecting from your local server (on the C: drive) on your computer which was installed with the VS.net installation. All my files have been uploaded to the below server, although they have been created on my computer. I have attempted to try connect the way that I know in asp (simply typing in the address) as well, and that was unsuccessful. I appreciate any help

the server that my files are located on is student.cba.ufl.edu/nettest and the file is the northwind.mdb (access database)

Dim strConnection as String = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & _
Server.MapPath( ????)

Dim strConnection as String = "Provider=Microsoft.Jet.OLEDB.4.0;"
strConnection += "Data Source= ???????"
Thank You :)
 
Chris: I'm surprised you haven't any answers yet; this seems like a "core" issue since connecting to remote databases would be required when you want to pull out data maintained at a different location. I have plans in the future to do this, needing weather data from NOAA, water quality data from EPA, State sources, etc... You might find a few clues at EPA's Enviorfacts database as their tables are open for SQL querying. Would like to know the answer to this. Good Luck.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top