Foros del Web - Ver Mensaje Individual - Como hacer la Conexion de BD con BRINKSTER

CHuLoSoY · #5 (**permalink**) 26/08/2002, 19:59

Hola:

Código:

&lt;%
Set con = Server.CreateObject(&quot;ADODB.Connection&quot;)
Con.Open(&quot;Provider=Microsoft.Jet.OLEDB.4.0;Data Source=&quot; &amp; _
Server.MapPath(&quot;loquesea.mdb&quot;))
sql = &quot;SELECT * FROM Tabladelabd&quot;
set result = Con.Execute(sql)
%&gt;

Mostrar resultados:

Código:

&lt;%=result(&quot;campo&quot;)%&gt;

Ejemplo claro:

Código:

&lt;%
Set con = Server.CreateObject(&quot;ADODB.Connection&quot;)
Con.Open(&quot;Provider=Microsoft.Jet.OLEDB.4.0;Data Source=&quot; &amp; _
Server.MapPath(&quot;noticias.mdb&quot;))
sql = &quot;SELECT * FROM Noticias&quot;
set result = Con.Execute(sql)
%&gt;
&lt;html&gt;
&lt;head&gt;
&lt;title&gt;Noticias&lt;/title&gt;
&lt;/head&gt;
&lt;body&gt;
&lt;p&gt;&lt;font face=&quot;Arial&quot; size=&quot;5&quot; color=&quot;#0080C0&quot;&gt;&lt;%=result(&quot;titulo&quot;)%&gt;&lt;/font&gt;&lt;br&gt;
&lt;font face=&quot;Arial&quot; size=&quot;2&quot;&gt;&lt;strong&gt;&lt;%=result(&quot;copete&quot;)%&gt;&lt;/strong&gt;&lt;/font&gt;&lt;/p&gt;
&lt;p&gt;&lt;font face=&quot;Arial&quot; size=&quot;2&quot;&gt;&lt;%=result(&quot;noticia&quot;)%&gt;&lt;/font&gt;&lt;/p&gt;
&lt;p&gt;&lt;font face=&quot;Arial&quot; size=&quot;2&quot;&gt;Categoría: &lt;b&gt;&lt;%=result(&quot;categoria&quot;)%&gt;&lt;/font&gt;&lt;/b&gt;&lt;/p&gt;
&lt;/body&gt;
&lt;/html&gt;

saludos.

<center><hr size="1" color="blue" width="39%"><a href="http://www.ommadawn.es.vg" target="_blank"><font color="red">www.Ommadawn.es.vg[/CODE]</a><hr size="1" color="blue" width="39%">