473,651 Members | 2,670 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How do I store objectGuid (binary from AD) into SQL table?

I don't want to extend the AD schema but need the hierarchical info on
some groups (objectGuids that maintain the group).

So I need to store the objectGuid of groups and accounts into the
relational table in SQL.

However, I don't know how to insert the objectGuid that are of type
binary (!?) into the SQL table.

Another question would be if I can cross-join the AD database with the
MS-SQL one so I could say use queries to select only groups where some
account is defined in the relational table in MS-SQL?

Any examples out there?

TIA
Jul 20 '05 #1
0 1863

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
10354
by: Sacs | last post by:
Hi all, this is _really_ bugging me, and the Google God has failed me: Doing an ldap_search of a Wink2k Active Directory trying to get the objectGUID. This is a unique id within AD and is meant to be a 128bit octal string. (16 bytes). Works 99% of the time, but the occasional objectGUID comes up short. e.g.
0
1793
by: Ammar | last post by:
I don't want to extend the AD schema but need the hierarchical info on some groups (objectGuids that maintain the group). So I need to store the objectGuid of groups and accounts into the relational table in SQL. However, I don't know how to insert the objectGuid that are of type binary (!?) into the SQL table. Another question would be if I can cross-join the AD database with the
2
331
by: Rastarizer | last post by:
I use VB .NET 2003 and I want to store into a binary field of a SqlServer 2003 table a File that I got on my hard disk. Does anyone know how can I do that ? I also use an OpenFileDialog component to get the file name and the path. I got already a connection to my DB and the only problem is that I don't know how to store the file into the table ?
3
13380
by: Karen Grube | last post by:
Hi! Each week, we receive a two-page PDF file from UPS along with a separate flat file (a CSV) The PDF file contains the overview of our weekly invoice and the CSV contains the details of each shipment. I download the file from UPS and then use DTS to import the data into SQL. At that point, I have a Crystal report that prints what looks like a regular UPS invoice. The only problem is that I wind up with having to print two...
0
1440
by: Ryo | last post by:
Hello ! I want to do something like this: string strFilter = "SyntaxThatICantFound"; DirectoryEntry dreAD = new DirectoryEntry("LDAP://192.168.0.1", "Admin", "Admin"); DirectorySearcher drsAD = new DirectorySearcher(dreAD); drsAD.Filter = "objectGUID=" + strFilter; drsAD.FindOne().GetDirectoryEntry(); But I can't found the syntax for the string strFilter, indeed in Active
4
2997
by: serge | last post by:
I was working on figuring out where a certain application was storing the multiple selection choices I was doing through the app. I finally figured out that they were being store in an IMAGE data type colum with the variable length of 26 bytes. This is the first time I ran into such way of storing multiple selections in a single Image data type. Is this a better alternative than to store into a One-to-Many tables? If so then I'll have...
4
2544
by: RedHair | last post by:
I'd like to set up a file system for the ASP.NET 2.0 application to store user-uploaded files, since the members are more than 100,000 people, the basic requirements are as below: (1) The file system is separate with front-end web site (2) Need to re-size user-uploaded image file to same size (3) Need to rename file name to avoid duplicate name (4) How to design directory and file structure to increase disk I/O performance (5) How to...
2
2487
by: HC | last post by:
Hello, Folks. I am not sure if this can be done (and a brief search of this group didn't yield any results that I thought would do the trick) but if it can be done it would make my life easier so here goes. First, what I am trying to accomplish is to make a program I've written automatically update itself if there is a newer version on the network. Second, my application runs on one or more computers at many geographically separated...
1
2673
by: theS70RM | last post by:
Hi, I have a php script to retrieve data about a user from the active directory using ldap. Here's a cut down version: $domainName = "domain.com"; $serverName = "server"; $baseDomainName = "DC=domain,DC=com"; $connection = ldap_connect($serverName);
0
8352
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8802
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8697
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
8579
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7297
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6158
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5612
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4283
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1909
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.