Source language: Translate to:

connessione a mdb su hosting windows 2008

Discussioni in Italiano di NeoBook

Moderator: systems.it

connessione a mdb su hosting windows 2008

Postby michi » Sun Aug 09, 2015 5:53 am

ciao a tutti, da alcuni ormai compilo applicazioni con neobook sfruttando le capacità del plugin dbpro.
C'è un modo per collegarsi con un'applicazione neobook ad un database access mdb salvato in un server remoto?

Mi servirebbe ad esempio per inserire/modificare dei record all'interno di un database mdb in un hosting windows di aruba.it

Come faccio a collegarmi con il db remoto (tenuto conto che questo si trova nella cartella mdb-database del sito)?

Grazie in anticipo a tutti
Michi

Started to use Neobook in 2003 when I was 12 to make interactive books. Coders saw me and smiled.
Nowadays I'm still using Neobook to create advanced and powerful softwares. Coders see me and say: «how did you make that?»
michi
 
Posts: 33
Joined: Wed Jun 25, 2014 3:01 am
Location: Italy

Re: connessione a mdb su hosting windows 2008

Postby Neosoft Support » Tue Aug 11, 2015 10:51 am

I do not think it's possible to open an MDB file over the Internet. Instead you would need to convert your database to something specifically designed for remote access like mySQL.
NeoSoft Support
Neosoft Support
NeoSoft Team
 
Posts: 5603
Joined: Thu Mar 31, 2005 10:48 pm
Location: Oregon, USA

Re: connessione a mdb su hosting windows 2008

Postby David de Argentina » Tue Aug 11, 2015 11:55 am

Hi Michi

Some years ago, i had for testing purposes, a free hosting with remote MDB support.

The provider was domaindlx.com

It worked at DSNLess technique.

i have use to connect with the MDB database this asp:

Code: Select all
<%
cual=request("cual")
Dim Conn, RS

Set Conn = Server.CreateObject("ADODB.Connection")
Set RS = Server.CreateObject("ADODB.Recordset")

DSNName = "DRIVER=Microsoft Access Driver (*.mdb);DBQ="
DSNName = DSNName & Server.MapPath("/neosoporte/db/Base.mdb")
Conn.Open DSNName

sql = "SELECT * FROM fallecidos where id=" + cual
RS.Open sql, Conn, 3, 3

id=RS.Fields("id").Value
apellido=RS.Fields("apellido").Value
nombres=RS.Fields("nombres").Value
fecha_fallec=RS.Fields("Fecha_fallec").Value
tablon=RS.Fields("Tablon").Value
fila=RS.Fields("Fila").Value
parcela=RS.Fields("parcela").Value
fecha_hebrea=RS.Fields("fecha_hebrea").Value
foto=RS.Fields("Foto").Value
mes=month(fecha_fallec)
dia=day(fecha_fallec)
ano=year(fecha_fallec)
%>
<html>
<head>
<title>AISA - Gestión de Fallecidos</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<SCRIPT TYPE="text/javascript" LANGUAGE="JavaScript" SRC="kdate.js">
<!--
//-->
</head>
<body bgcolor="#EEEEEE">
</SCRIPT>
<font face="arial, helvetica" > </font>
<table width="100%" border="0">
  <tr bgcolor="#66CCFF">
    <td><font face="Arial, Helvetica, sans-serif" size="4"><b><font color="#000000">AISA
      - <font size="2">Registro de Fallecidos</font></font></b></font></td>
  </tr>
</table>
<font face="arial, helvetica" >
<table width="100%" border="0" height="264">
  <tr>
    <td width="29%" height="256">
      <table width="100%" border="0">
        <tr>
          <td width="80%"><img src="/neosoporte/Images/<%=foto%>" height="230" width="186"></td>
          <td width="20%"> </td>
        </tr>
      </table>
    </td>
    <td width="71%" height="256">
      <table width="100%" border="0">
        <tr>
          <td> </td>
        </tr>
        <tr>
          <td><font face="Arial, Helvetica, sans-serif" size="4"><b><%=nombres%> 
            <%=apellido%></b></font></td>
        </tr>
        <tr>
          <td><font size="2" face="Arial, Helvetica, sans-serif">Falleció
            el:<b><font size="3"> <%=dia%>/<%=mes%>/<%=ano%> </font></b></font></td>
        </tr>
        <tr>
          <td><font face="Arial, Helvetica, sans-serif" size="2">Fecha Hebrea:
            <b> <font size="3">
            <SCRIPT LANGUAGE="JavaScript"> <!--
   // First display the Hebrew date
   var now = new Date;
   var tday = <%=dia%>;
   var tmonth = (<%=mes%>+1);
   var tyear = <%=ano%>;
   if(tyear < 1900)
      // if date from Netscape, then add 1900
      tyear += 1900;
   var hebDate = civ2heb(tday, tmonth, tyear);
   var hmS = hebDate.substring(hebDate.indexOf(' ')+1, hebDate.length);
   var hDay = eval(hebDate.substring(0, hebDate.indexOf(' ')));
   var hMonth = eval(hmS.substring(0, hmS.indexOf(' ')));
   var hYear = hmS.substring(hmS.indexOf(' ')+1, hmS.length);
   //document.write('La fecha Hebrea de hoy es:<br>');
   document.write(' '+ hDay + ' ' + hebMonth[hMonth+1] + ' ' + hYear);
//--></SCRIPT>
            </font></b></font></td>
        </tr>
        <tr>
          <td> </td>
        </tr>
        <tr>
          <td><font face="Arial, Helvetica, sans-serif" size="2">Ubicación</font></td>
        </tr>
        <tr>
          <td>
            <table width="100%" border="0">
              <tr>
                <td width="20%"><font face="Arial, Helvetica, sans-serif" size="2">Tablón:<b><font size="3">
                  <%=tablon%> </font></b></font></td>
                <td width="18%"><font face="Arial, Helvetica, sans-serif" size="2">Fila:
                  <b><font size="3"><%=fila%></font></b></font></td>
                <td width="62%"><font face="Arial, Helvetica, sans-serif" size="2">Parcela:
                  <b><font size="3"><%=parcela%></font></b> </font></td>
              </tr>
            </table>
          </td>
        </tr>
        <tr>
          <td> </td>
        </tr>
        <tr>
          <td> </td>
        </tr>
      </table>
    </td>
  </tr>
  <tr>
    <td width="29%"><b><font face="Arial, Helvetica, sans-serif" size="3">Recordatorios</font></b></td>
    <td width="71%"><b></b></td>
  </tr>
</table>
<table width="100%" border="0">
  <tr bgcolor="#66CCFF">
    <td width="11%">
      <div align="center"><font face="Arial, Helvetica, sans-serif"><font face="Arial, Helvetica, sans-serif"><font size="2">Fecha</font></font></font></div>
    </td>
    <td width="22%">
      <div align="center"><font face="Arial, Helvetica, sans-serif"><font face="Arial, Helvetica, sans-serif"><font size="2">Quien
        Recuerda </font></font></font></div>
    </td>
    <td width="67%">
      <div align="left"><font face="Arial, Helvetica, sans-serif"><font face="Arial, Helvetica, sans-serif"><font size="2">
        <font color="#66CCFF">...</font>Mensaje</font></font></font></div>
    </td>
  </tr>
  <%
RS.Close
Conn.Close
'---------------------
' tabla recordatorios
'---------------------
Set Conn = Server.CreateObject("ADODB.Connection")
Set RS = Server.CreateObject("ADODB.Recordset")
DSNName = "DRIVER=Microsoft Access Driver (*.mdb);DBQ="
DSNName = DSNName & Server.MapPath("/neosoporte/db/Base.mdb")
Conn.Open DSNName
sql = "SELECT * FROM recordatorios where clave=" + cual
RS.Open sql, Conn, 3, 3
cuantos=RS.recordcount
i = 1
if cuantos > 0 then
  RS.MoveFirst
  Do while not RS.EOF
    id=RS.Fields("id").Value
    fecha=RS.Fields("fecha").Value
    quien=RS.Fields("quien").Value
    mensaje=RS.Fields("mensaje").Value
    if (i/2) = int(i/2) then
       color = "#FFFFFF"
    else 
       color = "#CCFFFF"
    end if
%>
  <tr bgcolor="<%=color%>">
    <td width="11%"><b><font face="Arial, Helvetica, sans-serif" size="2"> <%=fecha%>
      </font></b></td>
    <td width="22%"><b><font face="Arial, Helvetica, sans-serif" size="2"> <%=quien%>
      </font></b></td>
    <td width="67%"><b><font face="Arial, Helvetica, sans-serif" size="2"> <%=mensaje%>
      </font></b></td>
  </tr>
  <%
    RS.MoveNext
    i=i+1
  loop
end if
%>
</table>
</font>
</body></html>
<%
RS.Close
Conn.Close
%>


I think if you research the web, perhaps you would get a windows hosting with asp / MDB support.

My 0.01
David de Argentina
User avatar
David de Argentina
 
Posts: 1560
Joined: Mon Apr 04, 2005 4:13 pm
Location: Buenos Aires, Argentina

Re: connessione a mdb su hosting windows 2008

Postby David de Argentina » Tue Aug 11, 2015 12:04 pm

Take a look of:

http://www.1apps.net/

Another 0.01

David de Argentina
User avatar
David de Argentina
 
Posts: 1560
Joined: Mon Apr 04, 2005 4:13 pm
Location: Buenos Aires, Argentina

Re: connessione a mdb su hosting windows 2008

Postby Neosoft Support » Wed Aug 12, 2015 10:07 am

I'm sorry, I was wrong about using MDB over the Internet. You just need to have the right software installed on your server.
NeoSoft Support
Neosoft Support
NeoSoft Team
 
Posts: 5603
Joined: Thu Mar 31, 2005 10:48 pm
Location: Oregon, USA


Return to NeoBook in Italiano

Who is online

Users browsing this forum: No registered users and 1 guest