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
connessione a mdb su hosting windows 2008
connessione a mdb su hosting windows 2008
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?»
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
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
-
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
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:
I think if you research the web, perhaps you would get a windows hosting with asp / MDB support.
My 0.01
David de Argentina
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
%>My 0.01
David de Argentina
-
David de Argentina
- Posts: 1596
- Joined: Mon Apr 04, 2005 4:13 pm
- Location: Buenos Aires, Argentina
- Contact:
-
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
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