Re: Converting Excel time-format (hours since 1.1.1901)

2007-12-10 Thread Dirk Hagemann
On 9 Dez., 18:38, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > On Dec 9, 8:52�am, Dirk Hagemann <[EMAIL PROTECTED]> wrote: > > > > > On 7 Dez., 22:36, John Machin <[EMAIL PROTECTED]> wrote: > > > > On Dec 8, 12:20 am, Dirk Hagemann &l

Re: Converting Excel time-format (hours since 1.1.1901)

2007-12-09 Thread Dirk Hagemann
On 7 Dez., 22:36, John Machin <[EMAIL PROTECTED]> wrote: > On Dec 8, 12:20 am, Dirk Hagemann <[EMAIL PROTECTED]> wrote: > > > Hello, > > > From a zone-file of a Microsoft Active Directory integrated DNS server > > I get the date/time of the dynamic update e

Re: Converting Excel time-format (hours since 1.1.1901)

2007-12-07 Thread Dirk Hagemann
On 7 Dez., 16:50, Dirk Hagemann <[EMAIL PROTECTED]> wrote: > On 7 Dez., 16:21, Tim Golden <[EMAIL PROTECTED]> wrote: > > > > > [EMAIL PROTECTED] wrote: > > > On Dec 7, 7:20�am, Dirk Hagemann <[EMAIL PROTECTED]> wrote: > > >> Hello,

Re: Converting Excel time-format (hours since 1.1.1901)

2007-12-07 Thread Dirk Hagemann
On 7 Dez., 16:50, Dirk Hagemann <[EMAIL PROTECTED]> wrote: > On 7 Dez., 16:21, Tim Golden <[EMAIL PROTECTED]> wrote: > > > > > [EMAIL PROTECTED] wrote: > > > On Dec 7, 7:20�am, Dirk Hagemann <[EMAIL PROTECTED]> wrote: > > >> Hello,

Re: Converting Excel time-format (hours since 1.1.1901)

2007-12-07 Thread Dirk Hagemann
On 7 Dez., 16:21, Tim Golden <[EMAIL PROTECTED]> wrote: > [EMAIL PROTECTED] wrote: > > On Dec 7, 7:20�am, Dirk Hagemann <[EMAIL PROTECTED]> wrote: > >> Hello, > > >> From a zone-file of a Microsoft Active Directory integrated DNS server > >> I g

Re: Converting Excel time-format (hours since 1.1.1901)

2007-12-07 Thread Dirk Hagemann
On 7 Dez., 14:34, supercooper <[EMAIL PROTECTED]> wrote: > On Dec 7, 7:20 am, Dirk Hagemann <[EMAIL PROTECTED]> wrote: > > > > > Hello, > > > From a zone-file of a Microsoft Active Directory integrated DNS server > > I get the date/time of the dynami

Converting Excel time-format (hours since 1.1.1901)

2007-12-07 Thread Dirk Hagemann
Hello, >From a zone-file of a Microsoft Active Directory integrated DNS server I get the date/time of the dynamic update entries in a format, which is as far as I know the hours since january 1st 1901. For Example: the number 3566839 is 27.11.07 7:00. To calculate this in Excel I use this: ="01.01

Re: Active Directory: how to delete a user from a group?

2007-05-04 Thread Dirk Hagemann
On 2 Mai, 17:48, Tim Golden <[EMAIL PROTECTED]> wrote: > Tim Golden wrote: > >Dirk Hagemannwrote: > >> Hi! > > >> Does anyone has experience with manipulating MS Active Directory > >> objects? I'd like to delete some users from a group, but so far I > >> couldn't find anything about this. > >> Ther

Active Directory: how to delete a user from a group?

2007-05-02 Thread Dirk Hagemann
Hi! Does anyone has experience with manipulating MS Active Directory objects? I'd like to delete some users from a group, but so far I couldn't find anything about this. There is some good stuff about retrieving data out of the AD (thanks to Tim Golden!), but how can I manipulate or change AD obje

Re: MS SQL Server: NT Authentication. Possible?

2006-08-24 Thread Dirk Hagemann
> http://msdn.microsoft.com/msdnmag/issues/05/09/SecurityBriefs/ > http://msdn2.microsoft.com/en-us/library/bsz5788z.aspx Thanks for the links Tim! This really seems to go in the right direction. Tomorrow I will talk to my colleague who takes care of the webserver. Dirk -- http://mail.python.or

Re: MS SQL Server: NT Authentication. Possible?

2006-08-23 Thread Dirk Hagemann
I already mentioned, that it the following works when it's NOT executed by the webserver: > > import adodbapi > db = adodbapi.connect ("Provider=sqloledb;Data Source=VODEV1;Initial > Catalog=EVOBACK;Integrated Security=SSPI;") > q = db.cursor () > q.execute ("SELECT SYSTEM_USER") > print q.fetcho

Re: MS SQL Server: NT Authentication. Possible?

2006-08-22 Thread Dirk Hagemann
> You have a user named "null"? > > Off-hand, it looks very much like the CGI script is still running > with the privileges of the web-server, and /that/ is set up in a locked > down account that doesn't have connection rights. I also thought this might be the reason, but when I includ

Re: MS SQL Server: NT Authentication. Possible?

2006-08-21 Thread Dirk Hagemann
Very strange. It works when I directly run the script, but when I use this script as a CGI-script on a webserver, I get this error: File "D:\Web\test\adodbapi.py", line 224, in connect raise DatabaseError(e) adodbapi.DatabaseError: (-2147352567, 'Exception occurred.', (0, 'Microsoft OLE DB Provider

Re: MS SQL Server: NT Authentication. Possible?

2006-08-21 Thread Dirk Hagemann
> > import adodbapi > > db = adodbapi.connect ("Provider=sqloledb;Data Source=VODEV1;Initial > Catalog=EVOBACK;Integrated Security=SSPI;") > q = db.cursor () > q.execute ("SELECT SYSTEM_USER") > print q.fetchone () > q.close () > > Cool! That works :-) Thanks a lot (again) Tim! Have a great we

Re: MS SQL Server: NT Authentication. Possible?

2006-08-18 Thread Dirk Hagemann
My windows-user has already access-permission to the database. Thanks for the exmaple - I will try it out on monday! :-) Enjoy your weekend! Dirk -- http://mail.python.org/mailman/listinfo/python-list

Re: MS SQL Server: NT Authentication. Possible?

2006-08-18 Thread Dirk Hagemann
Hi Tim! I think the adodbapi module is interesting. I just tried it out but got this error: 'Exception occurred.', (0, 'Microsoft OLE DB Provider for ODBC Drivers', "[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server conn

MS SQL Server: NT Authentication. Possible?

2006-08-18 Thread Dirk Hagemann
Hi! Is it somehow possible to access an MS SQL Server database from python by NT-Authentication or do I have only the possibility to use an SQL-Account with DB = odbc.odbc(myDB/myAccount/myPW) ? Kind regards Dirk -- http://mail.python.org/mailman/listinfo/python-list

How to start more than one process at the same time?

2006-07-14 Thread Dirk Hagemann
dn't change anything. Is it just not possible or what am I doing wrong? Thanks for any help! Dirk Hagemann -- http://mail.python.org/mailman/listinfo/python-list

Countdown timer for different timezones

2006-07-06 Thread Dirk Hagemann
Hi! I'd like to implement a countdown timer on a webite. It should show the months, days, hours, minutes and seconds until a given date and time. So far it's not really difficult, but this website will be used from different time zones, what will make a difference of 10 hours, if I use the time-in

Re: string.count issue (i'm stupid?)

2006-05-22 Thread Dirk Hagemann
I think I can tell you WHY this happens, but I don't know a work-around at the moment. It seems as if only the following "_a_" (A) are counted: a_A_a_A_ regards Dirk -- http://mail.python.org/mailman/listinfo/python-list

Re: Windows Registry Dump

2006-05-19 Thread Dirk Hagemann
Hi Tim! I want to do some analysis (as always ;-) ) and for that reason I think it's more practical to go trough a text-file. I can produce this text-file also by right-click on the key (the folder) in the registry and select "Export". There one can select Text-File and the place where to save th

Re: Windows Registry Dump

2006-05-19 Thread Dirk Hagemann
@Diez: I'm not trying to hack into somebody's computer - it is about collecting data from my company's anti-virus-parent-server. And all the information is only available in the registry (thanks Symantec...). @Tim, olso and Fredrik: THANKS - I will have a closer look at these modules. regards Dir

Windows Registry Dump

2006-05-18 Thread Dirk Hagemann
Hi! Does someone know how I can make a Text-Dump-File of a remote Windows-Computer's Registry (not the whole registry - only a part of it)? Thanks a lot for some code or a helpful link! regards Dirk -- http://mail.python.org/mailman/listinfo/python-list

Re: Convert Active Directory Object to string

2006-01-18 Thread Dirk Hagemann
Ok - this really works well for german special characters, but what to do with all the other encodings. What I could do is to try to vonvert it to latin-1 and if it fails I try latin-2 and so on. But is this really necessary? Isn't there may me a module which can do this for me and returns a string

Re: Convert Active Directory Object to string

2006-01-18 Thread Dirk Hagemann
Hi Fredrik! I think this will help me. I just have to do the same for danish encoding and may be some further encondings... Thanks! Dirk -- http://mail.python.org/mailman/listinfo/python-list

Convert Active Directory Object to string

2006-01-17 Thread Dirk Hagemann
Hi! When I receive data from Microsoft Active Directory it is an "ad_object" and has the type unicode. When I try to convert it to a string I get this error: UnicodeEncodeError: 'ascii' codec can't encode character u'\xfc' in position 26: ordinal not in range(128) This is caused by characters lik

Re: change an element of a list

2005-09-15 Thread Dirk Hagemann
THANKS! That works :-) But meanwhile I found another solution that works in my case. Out of this list of tuples I generated a SQL-Statement which is a simple string. Then I simply checked this string for 'None'. May be too easy... Dirk -- http://mail.python.org/mailman/listinfo/python-list

change an element of a list

2005-09-15 Thread Dirk Hagemann
Hi! I have a list of lists and in some of these lists are elements which I want to change. Here an example: lists=[('abc', 4102, 3572), ('def', 2707, 'None'), ('ghi', 'None', 4102)] 'None' should be replaced by 0 or NULL or something else. But as far as I know the replace function of the modu

Re: Datatype of non-negative values

2005-02-10 Thread Dirk Hagemann
A result smaller than 0 should be just invalid. I'd like to work with "try" and "except" like this: value=20 try: value=value-23 except: print 'value is smaller than 23' Now it should run into the "except". Dirk Hagemann Larry Bates <

Datatype of non-negative values

2005-02-09 Thread Dirk Hagemann
Hi, Is there a datatype in python which allows no negative values? I subtract several times something from a value and I don't want to chek everytime if this value is still bigger or equal 0. Thanks for help! Dirk Hagemann -- http://mail.python.org/mailman/listinfo/python-list