Bitacora de Vuelo: 2011

26/12/11

Antivirus on line

Funciona sin instalacion como el active scan de panda software

http://housecall.trendmicro.com/es/

7/12/11

Como acceder a sqlexpress mediante cliente de sql

FAQ: How to connect to SQL Express from "downlevel clients"(Access 2003, VS 2003, VB 6, etc(basically anything that is not using .Net 2.0 or the new SQL Native Client))

sqlexpress 23 Jul 2004 1:09 AM 35

This is the short version, the longer version is further down, also make sure and review the SQL Express BOL and the Mini BOL.

Follow these steps:

1. Make sure express is running correctly (assumes a default install)

Drop to a cmd prompt

Type the following

sqlcmd -S.\sqlexpress

You should get a prompt like this

Type

Exit

to exit sqlcmd

2. Enable Protocols

a. Launch SQL Computer Manager

b. Expand "Server Network Configuration"

c. Expand Protocols for "SQLEXPRESS"

d. Enable Np (for local and remote access)

e. Enable TCP (for local and remote access)

3. Restart SQL Express

a. can be done from either SQL Computer Manager, Services applet, or command line( net start mssql$sqlexpress)

4. Start SQL Browser service from Service applet or command line( net start sqlbrowser)

At this point the client should be able to connect, if the machine is rebooted then the last step (4) needs to be repeated as this service must always be running. You can also set this service to autostart via Computer Manager, Services Management Applet.

These actions need to be performed wherever the machine is that has SQL Server Express running on it. If machine A is running SQL Express and an attempt is made to connect from a local tool or applet the steps must be performed on machine A. If an attempt is made to connect from a different machine(B) then the steps still need to be performed on Machine A.

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------

The long version.

This entry is designed to help explain the reasons behind the steps in the short version of this post. Lets walk through the steps and the problems and try and explain whats happening

Checking to make sure that Express is running via SQLCMD

The default install for SQL Express installs Express as a named instance(called SQLExpress), with no network listening and with Windows Authentication support only.

To connect to a named instance of SQL Server the convention is to use a servername of the format <servername>\<instancename>, its also possible to shortcut the machinename to either "." or "(local)"(these shortcuts work with all protocols, localhost will also work but only with TCP/IP in older clients,however SQL Native Access supports resolution of LocalHost for Named Pipes and Shared Memory).

No user id and password has been specified because of the default windows authentication, if the install had been changed to specify mixed mode authentication and a password had been given then this could have been used.

Enabling Protocols

Because SQL Server Express does not listen on the network by default connections are made using a local protocol, in the case of the VS 2005 SKUs this is the shared memory protocol. The interface to this has changed in SQL Server 2005 such that older clients can no longer use it. Hence for older clients to work a different local protocol or a network protocol must be used, these are not enabled by default and must be manually enabled.

SQL Browser Service

In general when a client connects remotely to a SQL Server named instance the client does not know the port that the instance is listening on(you can work around this by configuring SQL Server named instances to listen on a specific port and then specifying that port in the connection string in the format <servername>,<port number>)

So when an application attempts to connect to a named instance in the form <servername>\<instancename> the client connection needs to be directed to the correct port. In SQL Server 2000 one of the running services had a built in listener that received the named instance connection requests and redirected them appropriately.

In SQL Server 2005 this functionality has been moved to a dedicated listener service, that service is SQLBrowser.

SQLBrowser also performs another service, that of SQL Server Discovery, its common in many UIs from Microsoft and others to have the ability to browse for instances of SQL Server running locally or remotely, again in SQL Server 2000 this was handled by one of the running instances of SQL Server, in SQL Server 2005 this is handled by the SQLBrowser Service.

Thus the SQLBrowser Service must be started to be able to discover any instance on the machine, and also to connect to named instances through protocols other than shared memory. If network protocols are not enabled via the setup switch then the browser service is not set to autostart.

SQL Native Client

SQL Server native connectivity is defined as connectivity through OLE DB(ADO uses OLE DB under the covers) or ODBC means in SQL Server 2005 (dblib is not an included as a data access technology in SQL Server 2005).

In previous releases of SQL Server(SQL7 and SQL2000) an update to MDAC was preferred for client apps, this means the installation of an entire MDAC update for SQL Server connectivity. In SQL Server 2005 we no longer require an MDAC update as we have refactored out the SQL Server specific connectivity components for OLE DB and ODBC.

As such in SQL Server 2005 no MDAC update is required to connect(although MDAC 2.8 is preferred, any MDAC from Windows 2000 SP3 upwards is supported), but a new component is required. This component is referred to as SQL Native Access.

These components include support for OLE DB and ODBC accessed through a single .dll called: SQLNCLI.dll, this file and its support files are redistributable.

SQL Native Client is NOT required for managed data access via .Net APIs.

-Euan Garden

Product Unit Manager

SQL Server Tools

fuente:http://blogs.msdn.com/b/sqlexpress/archive/2004/07/23/192044.aspx

http://docs.aquafold.com/ads/4.7/screenshots/docs/express-register.gif

ojo: poner como direccion de host: 127.0.0.1\SQLExpress y el port por default:1433

9/11/11

Cursos de Genexus

Con ejemplos y pdfs

http://training.genexus.com/cursos/todos-los-cursos?es

2/11/11

Mapa interactivo de Buenos Aires

Tiene division de barrios, datos utiles: hospitales, cajeros automaticos, etc

http://mapa.buenosaires.gob.ar/

28/10/11

Instalando Genexus Server

Despues de un par de dias de trabajo logramos instalar Genexus Server, no hay una documentacion muy clara que diga como hacerlo y para que funcione correctamente tiene unos requerimientos especiales, por eso resumo los pasos que hicimos por si a alguien le sirve.

Inicialmente lo hicimos sobre un servidor que no tenia salida a internet y no tenia activado firewall

Pasos que seguimos:

Instalamos Windows 2003 Enterprise Edition
Agregamos el IIS (6.0)
Instalamos el Microsoft .Net framework 3.5 (Ojo el instalador completo requiere al final de la instalacion que este conectado a internet, sino la tiene termina con error)
Instalamos Sqlexpress (con el sql managment studio express que viene incluido)
Este paso puede no ser necesario: corrimos un sql para dejar persistente el estado de las asp (Install Persist SQLstate)
configuramos tanto el IIS como el SQL que usen cuentas de sistema

Instalamos genexus server

en este punto podiamos entrar sin contraseña por web a la pagina: http://<direccion o nombre>/GenexusServer

Activamos la seguridad de genexus server y nos pidio el certificado x 509

Instalamos como dice en la wiki

http://wiki.gxtechnical.com/commwiki/servlet/hwiki?Setting+up+an+SSL+Certificate+in+IIS+for+GXserver,

En este punto cuando queriamos transferir la kb al servidor generaba el xpz y fallaba la importacion en el servidor (import.log)

Lo que nos faltaba era actualizar la version del genexus server (trabajamos con cliente X evo1 U3 y no entendia el xpz)

Notas: A veces habia que reiniciar el servidor asi como cerrar y volver abrir Genexus cliente para que tome alguno de los cambios.

Si al hacer las pruebas da errores como no puedo activar el servicio xxxxx.svc, conviene pegar esa url en el navegador y ver que devuelve.

Paginas fundamentales:

http://wiki.gxtechnical.com/commwiki/servlet/hwiki?GeneXus+Server+Installation+Manual,

http://wiki.gxtechnical.com/commwiki/servlet/hwiki?GeneXus+Server+Common+Issues,

veo que este resumen es bastante popular, si tienen comentarios mejoras, avisen que las agrego, gracias

21/10/11

Portales laborales y redes sociales

Recopilacion de Sitios para buscar trabajo

execuzone

www.execuzone.com

jobomas

www.jobomas.com

www.linkedin.com

universobit

www.universobit.com.ar

zonajobs

www.zonajobs.com.ar

bumeran

www.bumeran.com

5/10/11

Validador para html 5

HTML 5 cambio un monton la sintaxis asi que para comprobar una pagina, un texto (pegandolo) o se puede subir un archivo

http://html5.validator.nu/

19/9/11

Sitio de Fotos (Igual a Flickr pero con fotos mas profesionales)

500 px

Welcome to a great photocommunity with a magic voting system, editorial selections & professional portfolios

18/9/11

Diarios Revistas

Descarga de diarios y revistas

http://quioskito.blogspot.com/

16/9/11

Pagina para resolver ecuaciones / Graficar

Problemas basicos, algebra, trigonometria, calculo, estadisticas

http://www.mathway.com/

13/9/11

Conversor on line de mp3 a aac

Convert media free, fast and online.

No software installation needed.

Audio - video - imagenes - documentos

http://www.online-convert.com/

1/9/11

Reduce el tamaño de las imagenes jpg

Comprime el tamaño de los jpgs hasta 5 veces

http://www.jpegmini.com/main/home

16/8/11

Funciones Frecuentes Celulares Claro Argentina

Consulta de Saldo

Enviar un sms con la palabra "SALDO" al 555 (sin las comillas)

Transferencia de Credito

Enviar un sms con el numero del celular (sin el 15) + el importe (de $2 al 10% del saldo) al 888

Números Frecuentes por SMS sin cargo!
Enviá un sms con la palabra "CLARONF" al 2233 y seguí las instrucciones para poder dar de alta o modificar tus números frecuentes.

fuente:

http://argentina.claro.com.ar/tengo/numeros_frecuentes.asp

22/7/11

Rebuild Modelo Genexus

http://www.gxtechnical.com/gxdlsp/pub/sac/hsac_02106,s.html
Pasos a seguir para ejecutar un Rebuild

Abstract:

Para ejecutar un Rebuild de la Base de conocimiento GeneXus seguir los siguientes pasos: 1. Ejecutar una línea de comando (ventana DOS). 2. Posicionarse en el directorio raíz de la KB. 3. Ejecutar el archivo rbld.bat que se encuentra en la raíz de la instalación de GeneXus. IMPORTANTE: Es importante tomar el rbld.bat de la versión de GX correspondiente a la KB. Ejemplo: C:\MyKB>C:\GeneXus\rbld.bat

Descripción Detallada

Modos de ejecución del Rebuild:

1. RBLD
Reconstruye todos los IDX siempre. Leyendo la información del cabezal antes. Esto último es la principal diferencia con la siguiente opción.

2. RBLD habiendo borrado los IDX previamente.
Reconstruye SOLAMENTE todos los IDX. También reconstruye los .DAT que estén dañados

3. RBLD -y (Rebuild Forzado)
Fuerza la reconstrucción de los IDX pero TAMBIEN reconstruye TODOS los DATs (que también pueden estar dañados) estén dañados o no.

NOTA:
_ IDX: Indices de acceso a la base de conocimiento.
_ DAT: estructura interna donde se almacenan los objetos GeneXus.

11/7/11

Analizador de codigo Javascript

JSLint

www.jslint.com

7/7/11

buscador de iconos libres de licencia

Icon Finder

buscador de iconos libres de licencia

4/7/11

Abrir command prompt en una carpeta en el explorador de archivos

Abrir command prompt en una carpeta

crear un archivo.reg con el siguiente texto y ejecutarlo

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Folder\shell\Command Prompt]
""="Command Prompt Here"
[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Folder\shell\Command Prompt\Command]
""="cmd.exe /k pushd %L"

fuente:

http://profdouglasoliveira.blogspot.com/2011/07/open-command-here.html

17/6/11

Graficador de funciones matematicas

Increible!!!

http://graph.tk/

30/5/11

Expresiones Regulares

Test online de expresiones regulares (muy recomendable)

http://regexpal.com/

26/5/11

Clientes Web de mensajeria instantanea (GTALK - MSN)

http://www.communicationtube.net/

http://www.livego.com/?via=MessengerFX

17/5/11

Carta de presentación de persona desempleada

http://yahoo.plan-carrera.monster.com.ar/curriculum-carta-de-presentacion/ejemplos-cartas-de-presentaci%C3%B3n/carta-presentacion-persona-desempleada/article.aspx

16/5/11

Manual y diagramas de circuitos electronicos Televisores, audio

www.fallastv.com.ar

tutoriales y manuales
http://www.electronicafacil.net/

Yo reparo
http://www.yoreparo.com/foros/electromedicina/algunos-manuales-y-circuitos-t161802.html

Indice de manuales HASA
http://www.hasa.com.ar/download.php