|
 |
asp_ado_rds thread: ASP Remote Databasing
Message #1 by "Yousef Abdali" <aseer53@h...> on Sat, 6 Jul 2002 15:19:43
|
|
I am trying to access an mdb file that resides on a remote server. I am
doing that through ASP page that resides on my local server. However, I
get server time out when I run it although that I changed the timeout time
to 180 seconds!
Can anybody help me!!!
Thanks,
Yousef
Here's my MSDFMAP.INI entry"
==================================
[connect Northwind]
Access=ReadWrite
Connect="DSN=Northwind"
==================================
Here's my test page contents
==================================
<%
Response.timeout=180
Dim objCon, strCon
On Error Resume Next
Set objCon=Server.CreateObject("ADODB.Connection")
objCon.Open "Provider=MS Remote; Remote Server=http://infosrv; Remote
Provider=MSDASQL; Data Source=Northwind;"
objCon.Open strCon
strSQL="SELECT Products.ProductName, Products.UnitPrice FROM Products"
Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.ActiveConnection = strCon
objRS.Open strSQL
%>
<TABLE border=1>
<tr><td><b>productname</b></td><td><b>unitprice</b></td></tr>
<%
Do While Not objRS.EOF
%>
<tr>
<td><%=objrs("productname")%></td>
<td><%=objrs("unitprice")%></td>
</tr>
<%
objRS.Movenext
Loop
%>
</table>
%>
=========================
Message #2 by akash das <akashdas@y...> on Sat, 6 Jul 2002 23:33:02 -0700 (PDT)
|
|
Hi,
Use the server.mappath function.
Aksh.
--- Yousef Abdali <aseer53@h...> wrote:
> I am trying to access an mdb file that resides on a
> remote server. I am
> doing that through ASP page that resides on my local
> server. However, I
> get server time out when I run it although that I
> changed the timeout time
> to 180 seconds!
>
> Can anybody help me!!!
>
> Thanks,
> Yousef
>
> Here's my MSDFMAP.INI entry"
> ==================================
> [connect Northwind]
> Access=ReadWrite
> Connect="DSN=Northwind"
> ==================================
>
> Here's my test page contents
> ==================================
> <%
> Response.timeout=180
> Dim objCon, strCon
>
> On Error Resume Next
> Set objCon=Server.CreateObject("ADODB.Connection")
>
> objCon.Open "Provider=MS Remote; Remote
> Server=http://infosrv; Remote
> Provider=MSDASQL; Data Source=Northwind;"
>
> objCon.Open strCon
>
> strSQL="SELECT Products.ProductName,
> Products.UnitPrice FROM Products"
>
> Set objRS = Server.CreateObject("ADODB.Recordset")
>
> objRS.ActiveConnection = strCon
> objRS.Open strSQL
> %>
> <TABLE border=1>
>
<tr><td><b>productname</b></td><td><b>unitprice</b></td></tr>
> <%
> Do While Not objRS.EOF
> %>
> <tr>
> <td><%=objrs("productname")%></td>
> <td><%=objrs("unitprice")%></td>
> </tr>
> <%
> objRS.Movenext
> Loop
> %>
> </table>
> %>
> =========================
>
> akashdas@y...
> %%email.unsub%%
>
__________________________________________________
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com
Message #3 by "Yousef Abdali" <aseer53@h...> on Tue, 9 Jul 2002 10:24:40
|
|
Hii,
why to use the mappath function, whatz for???
> Hi,
Use the server.mappath function.
Aksh.
--- Yousef Abdali <aseer53@h...> wrote:
> I am trying to access an mdb file that resides on a
> remote server. I am
> doing that through ASP page that resides on my local
> server. However, I
> get server time out when I run it although that I
> changed the timeout time
> to 180 seconds!
>
> Can anybody help me!!!
>
> Thanks,
> Yousef
>
> Here's my MSDFMAP.INI entry"
> ==================================
> [connect Northwind]
> Access=ReadWrite
> Connect="DSN=Northwind"
> ==================================
>
> Here's my test page contents
> ==================================
> <%
> Response.timeout=180
> Dim objCon, strCon
>
> On Error Resume Next
> Set objCon=Server.CreateObject("ADODB.Connection")
>
> objCon.Open "Provider=MS Remote; Remote
> Server=http://infosrv; Remote
> Provider=MSDASQL; Data Source=Northwind;"
>
> objCon.Open strCon
>
> strSQL="SELECT Products.ProductName,
> Products.UnitPrice FROM Products"
>
> Set objRS = Server.CreateObject("ADODB.Recordset")
>
> objRS.ActiveConnection = strCon
> objRS.Open strSQL
> %>
> <TABLE border=1>
>
<tr><td><b>productname</b></td><td><b>unitprice</b></td></tr>
> <%
> Do While Not objRS.EOF
> %>
> <tr>
> <td><%=objrs("productname")%></td>
> <td><%=objrs("unitprice")%></td>
> </tr>
> <%
> objRS.Movenext
> Loop
> %>
> </table>
> %>
> =========================
>
> akashdas@y...
> %%email.unsub%%
>
__________________________________________________
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com
|
|
|
View Cart
