server mappath

Question

when i use the server mappath to connect database, the server gives this error 'e:\windows\system32\inetsrv\server.mappath(a2128reem\reemjr.mdb)' is not a valid path.... the think that i wont to under staand why the server do not go direct to inetpub????? and is there any way to make go there by servermappath or am i able to change the servermappath??? thanks in advance

Answer 1

hey i tried this in some different way just give it a try,
i am using ABC Table as you give in the above example and considering the column you gave in it.
if the attached code is also taking time then try with using query hints like (nolock) , creating index on table columns etc.

Thanks!

Answer 2

Hi,

i think here is the typo in date insted of 2/1/2009 you have put 2/2/2009 name,1/1/2009 2/2/2009

if possible can you please put your query/code here. to see where you are missing.

Thanks!