connessione a mdb su hosting windows 2008

Discussioni in Italiano di NeoBook
Locked
michi
Posts:40
Joined:Wed Jun 25, 2014 3:01 am
Location:Italy
connessione a mdb su hosting windows 2008

Post by 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?»

Neosoft Support
NeoSoft Team
Posts:5628
Joined:Thu Mar 31, 2005 10:48 pm
Location:Oregon, USA
Contact:

Re: connessione a mdb su hosting windows 2008

Post by 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

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

Re: connessione a mdb su hosting windows 2008

Post by 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%">&nbsp;</td>
        </tr>
      </table>
    </td>
    <td width="71%" height="256"> 
      <table width="100%" border="0">
        <tr> 
          <td>&nbsp;</td>
        </tr>
        <tr> 
          <td><font face="Arial, Helvetica, sans-serif" size="4"><b><%=nombres%>&nbsp; 
            <%=apellido%></b></font></td>
        </tr>
        <tr> 
          <td><font size="2" face="Arial, Helvetica, sans-serif">Falleci&oacute; 
            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>&nbsp;</td>
        </tr>
        <tr> 
          <td><font face="Arial, Helvetica, sans-serif" size="2">Ubicaci&oacute;n</font></td>
        </tr>
        <tr> 
          <td> 
            <table width="100%" border="0">
              <tr> 
                <td width="20%"><font face="Arial, Helvetica, sans-serif" size="2">Tabl&oacute;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>&nbsp;</td>
        </tr>
        <tr> 
          <td>&nbsp;</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:1596
Joined:Mon Apr 04, 2005 4:13 pm
Location:Buenos Aires, Argentina
Contact:

Re: connessione a mdb su hosting windows 2008

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

Take a look of:

http://www.1apps.net/

Another 0.01

David de Argentina

Neosoft Support
NeoSoft Team
Posts:5628
Joined:Thu Mar 31, 2005 10:48 pm
Location:Oregon, USA
Contact:

Re: connessione a mdb su hosting windows 2008

Post by 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

Locked