Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: link Active directory Field With SQL Field Post Reply Post New Topic
Author Message
mtrenda
Newbie
Newbie
Avatar

Joined: 18 Jun 2009
Location: United States
Online Status: Offline
Posts: 1
Quote mtrenda Replybullet Topic: link Active directory Field With SQL Field
    Posted: 18 Jun 2009 at 4:29pm
I have a report that is using ADO to connect to active directory
 
select samaccountname, sn, givenname, displayname, physicaldeliveryofficeName, mail, TelephoneNumber, Department from 'LDAP://DC=YourSubdomain, dc=YourDomain, dc=yourdomainext' Where ObjectCategory='person' and  objectClass='user'
 
and sQl Database that i am attaching to with a Field Called CostCenter of integer.
 
I want to link the CostCenter Field with the PhysicalDeliveryofficeName which is string. 
 
So here is the Question:  Can I Change the data type of PhysicalDeliveryofficeName to integer in the ldap Query so that it can be linked with the sql table.
 
I kow the answer is change the sql field to string but that changes other things we are doing so not an option.  Another would be to import that into another database and change it but i was looking for a command that might work for me like convert.
 
thanks in advance for any suggestions.
 
thanks
 
mark

 
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.