It seems like you are trying to connect using a DSN on the server, rather than
by
the file path of the database. You will either have to change your DSN on the
server,
or connect using the absolute path of the database. Thanks Andy
----- Original Message -----
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]http://mail.yahoo.com
[Non-text portions of this message have been removed]
---------------------------------------------------------------------
Home :
[http://groups.yahoo.com/group/active-server-pages]http://groups.yahoo.com/group/active-server-pages
---------------------------------------------------------------------
Post : [EMAIL PROTECTED]
Subscribe : [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
---------------------------------------------------------------------
Yahoo! Groups Sponsor
[http://us.ard.yahoo.com/SIG=129in47e6/M=281955.5530326.6602771.3001176/D=groups/S=1705115381:HM/EXP=1101796908/A=2343726/R=0/SIG=12ilp2iod/*http://clk.atdmt.com/VON/go/yhxxxvon01900091von/direct/01/&time=1101710508983534]
[http://us.ard.yahoo.com/SIG=129in47e6/M=281955.5530326.6602771.3001176/D=groups/S=1705115381:HM/EXP=1101796908/A=2343726/R=1/SIG=12ilp2iod/*http://clk.atdmt.com/VON/go/yhxxxvon01900091von/direct/01/&time=1101710508983534]
Get unlimited calls to
U.S./Canada
--------------------------------------------------------------------------------
Yahoo! Groups Links
� To visit your group on the web, go to:
[http://groups.yahoo.com/group/active-server-pages/]
http://groups.yahoo.com/group/active-server-pages/
To unsubscribe from this group, send an email to:
[mailto:[EMAIL PROTECTED] [EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the
[http://docs.yahoo.com/info/terms/]Yahoo!
Terms of Service .
[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/
