ODBC Link Server in MS SQL

yuibox No Comments »

yuibox

Here is how you link you ODBC server. Just open SQL Management Studio-> New Query and type this:

EXEC sp_addlinkedserver

@server = ‘MyServer’, — the name of your linkserver

@srvproduct = ”,

@provider = ‘MSDASQL’, — This is the default for ODBC server, for more info please reffer to MS Site

@datasrc = ‘lotus’ –DSN name

GO
Read the rest of this entry »

… everything happens for a reason.

yuibox No Comments »

yuiboxHello!,

Sorry I was not able to post much this month. Many important things happened this month and it took me out of surprise.

Like Kevin from Diggnation.com says… “MOVING ON!…”

It almost the end of the month, hence, I was thinking new ideas for this little blog for the upcoming month. Which are the following:

Read the rest of this entry »

Java - Querying an LDAP Directory

yuibox 3 Comments »

yuibox(All credit to my sensei, Eric Enright)

Yesterday I spent a lot of time figuring out how to go about getting a user’s group membership information out of Active Directory, Java style. Since Active Directory is essentially a glorified LDAP server, you can connect to it through JNDI, treating it like any other database: connect to it, query it, and process your results. The below code will run over all user accounts, printing out their full LDAP DN, their email address, and their logon name.

Read the rest of this entry »

Comunication Between Bluetooths through COMs in C# Part I

yuibox No Comments »

yuiboxI was trying to send information, strings, files and the most important, custom packets between 2 bluetooth. One listening and the other one sending(Master <-> Slave). In order to test this in an easy way, both bluetooh are connected to a Serial Port, in this case, COM1 and COM2. In order to test this in 1 single computer and avoid the hassle, I Connected a Null Modem Adapter or RS-232 Serial Cable. I wired one COM port into another, so both will be connected together, transmitting and receiving in the same line cross linked (TX, similar to RX).

This tutorial will show the first step to start a connection and to get the general idea of how this puppy works :)

In Part I of this tutorial I will explain how to send a simple string and receive it :) easy ne? ^.^ we all love baby steps ;)

Requirements :  - Null Modem Adapter

- VS.NET 2005 (or any other C# compiler)

- Basic Knowledge of C#

- and lots of time and patient :D

Read the rest of this entry »

Design by j david macor.com.Original WP Theme & Icons by N.Design Studio
Entries RSS Comments RSS Log in