I have placed my "campus.mdb" database in folder "database" in remotely .please 
advise how i can use ms-access databases remotely?

>From the "main.asp",I am trying to get values.

set con =server.CreateObject("ADODB.Connection")
con.open "DSN=campus"
Set objrs1 = Server.CreateObject("ADODB.Recordset")
sql1="SELECT distinct dept_name from campus"

The error Im getting is.

Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC 
Driver Manager] Data source name not found and no default driver specified 

/campusarea/select.asp, line 11 

Can you pls advice/help as I am working first time on this website.

Thank you in advance.


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

[Non-text portions of this message have been removed]






------------------------ Yahoo! Groups Sponsor --------------------~--> 
$9.95 domain names from Yahoo!. Register anything.
http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/17folB/TM
--------------------------------------------------------------------~-> 

---------------------------------------------------------------------    
 Home       : http://groups.yahoo.com/group/active-server-pages
---------------------------------------------------------------------
 Post       : [EMAIL PROTECTED]
 Subscribe  : [EMAIL PROTECTED]
 Unsubscribe: [EMAIL PROTECTED]
--------------------------------------------------------------------- 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/active-server-pages/

<*> To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/
 



Reply via email to