Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP General > database help requested ... works online, but not on local

Thread Tools

database help requested ... works online, but not on local

Posts: n/a

I wrote a website about 8 years ago -
It has an Access database of web links and a number of pages that
show the different categories.

I may need to make a lot of changes to the website.

Although these asp pages are working fine online, whenever I try to
run them in my MS InterDev v6.0 (Microsoft's "Dreamweaver")
the listings do not show up and an error is reported.

here is the code ....

> urlPath = "c:/domains/"
> mapFilePath = Server.MapPath("db/pbLinks.mdb")
> fileDSN = " DBQ=" & mapFilePath
> urlDSN = " DBQ=" & urlPath
> Set myConn = Server.CreateObject("ADODB.Connection")
> myConn.Open "Driver={Microsoft Access Driver (*.mdb)};" & urlDSN & ";"
> sql_Query = "SELECT * FROM pblLinks WHERE pblCat='Org' ORDER BY pblName"
> set rs = myConn.Execute(sql_Query)
> <tr>
> <td class="b" />
> <td class="l"> <a href="#" onClick="fOpenLinksWindow('<%=rs("pblLink")%>');" > <%=rs("pblName")%> </a> </td>
> <td class="b" />
> <td class="d"> <%=rs("pblDesc")%> </td>
> <td class="b" />
> </tr>
> rs.MoveNext

This is what is appearing in the first field ... ');"

obviously it involves the quotes, but why would it work online and
not on InterDev ?

as I said, did this 8 years ago and have forgotten how the DB was
set up

best regards

Posted via a free Usenet account from

Reply With Quote
Bob Barrows [MVP]
Posts: n/a
BobTheBowler wrote:
> Hi

Please don't multipost. I've already replied to this question over at
..asp.db. If you feel you must direct your question at multiple
newsgroups*, then post one single message to the desired groups by
putting the group names into the To list (aka crosspost)

Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the

Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Database Database Database Database Computer Information 0 09-27-2012 02:43 AM
DataBase DataBase DataBase DataBase Computer Information 0 09-26-2012 09:40 AM
Browser link to local file works when local, not work when servedfrom http lurker HTML 1 04-05-2005 05:10 AM
[py2exe.i18n] English works, German works, but not French. What do I miss? F. GEIGER Python 3 08-06-2004 10:01 AM
VPN Client works with LOCAL authentication but not RADIUS Nuno Martins Cisco 0 02-17-2004 03:43 PM