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!

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

FrontPage Connection Issue.....

Status
Not open for further replies.
stlrain95

stlrain95

Programmer
Sep 21, 2001
224
US
I am having some serious issues with trying to get DSN-less connection to my Access DB.?

What am I missing?

<HTML>
<BODY>
<%
Dim MyConn
Dim connString

Set MyConn = Server.CreateObject(&quot;ADODB.Connection&quot;)
connString = &quot;DBQ=&quot; & Server.MapPath(&quot;<C:\My downloads\ASP\Sample_2000.mdb>&quot;)
MyConn.Open &quot;Driver={Microsoft Access Driver (*.mdb)}; &quot; & connString
SQL_query = &quot;SELECT * FROM Friends&quot;
Set RS = MyConn.Execute(SQL_query)
WHILE NOT RS.EOF
%>
<LI><%=RS(&quot;Name&quot;)%>: <A HREF=&quot;<%=RS(&quot;Link&quot;)%>&quot;>Homepage</A>
<%
RS.MoveNext
WEND
%>
</BODY>
</HTML>
 
Sort by date Sort by votes
I don't know if this has anything to do with the global.asa?
 
Upvote 0 Downvote
Not sure, just shooting blanks I guess.. but the
connString = &quot;DBQ=&quot; & Server.MapPath(&quot;<C:\My downloads\ASP\Sample_2000.mdb>&quot;)
part doesnt look ok to me?! My codes look like something a kid wrote
I have absolutely no idea what I am talking about
Somehow I still manage to make it work
 
Upvote 0 Downvote
Your connection string is incorrect

connString = &quot;DBQ=&quot; & Server.MapPath(&quot;<C:\My downloads\ASP\Sample_2000.mdb>&quot;)

This would set the path as etc

To set it to a path on ur pc use

connString = &quot;DBQ=&quot; & (&quot;C:\My downloads\ASP\Sample_2000.mdb&quot;) Saturday 12.00
im6.gif
im2.gif
im2.gif
20.00
im5.gif
im4.gif
im7.gif
3.00am
im8.gif
Sunday [img http
 
Upvote 0 Downvote
I am still getting an internal server error? I am dealing with an intranet, but I am wondering if I am having trouble because of my global.asa?

Any other ideas?
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

JScannell
  • Locked
  • Question
Border issue with Google Chrome on an Android phone
Replies
0
Views
416
JScannell
JScannell
Ambientguitar
  • Locked
  • Question
Issue with this not calling the Sub in Classic ASP page
Replies
5
Views
376
MarkSweetland
MarkSweetland
vamsikirank
  • Locked
  • Question
Fortify Scan For Classic Asp Application - Issue
Replies
2
Views
282
guitarzan
guitarzan
leifoet
  • Locked
  • Question
Asp database connection for login fails
Replies
11
Views
236
guitarzan
guitarzan
MauiNick
  • Locked
  • Question
Weird issue with IIS7 &amp; ASP
Replies
1
Views
119
xwb
xwb

Part and Inventory Search

Sponsor

Back
Top