Install server2005 in LDAP machine problem: Found the problem and the solution

Hi all,

I installed June CTP on server with (already) SQL 2000 and LDAP (the idea is to check if 2005 and 2000 are good friends).
after installation I start to retrieve Errors from the LDAP: "Automation error The authentication mechanism is unknown." (error 2147016662)

more info about the proccess that failed:
ASP file (IIS5) create object (mine dll).
mine dll try to connect LDAP and retrieve data from user.

The proccess fail when it try to connect the LDAP (I debug it).

more then it: when I create the dll from VB6, every thing gone great.

Any Idea?Just to let you know:

The problem was COM+ issue.
Some how the installation couse my COM+ application to stop working (or work with limited security owner).

I build new COM+ Application, moved all my dlls to the new one, and it work.

Install server2005 in LDAP machine problem

Hi all,

I installed June CTP on server with (already) SQL 2000 and LDAP (the idea is to check if 2005 and 2000 are good friends).
after installation I start to retrieve Errors from the LDAP: "Automation error The authentication mechanism is unknown." (error 2147016662)

more info about the proccess that failed:
ASP file (IIS5) create object (mine dll).
mine dll try to connect LDAP and retrieve data from user.

The proccess fail when it try to connect the LDAP (I debug it).

more then it: when I create the dll from VB6, every thing gone great.

Any Idea?Just to let you know:

The problem was COM+ issue.
Some how the installation couse my COM+ application to stop working (or work with limited security owner).

I build new COM+ Application, moved all my dlls to the new one, and it work.

Inserting with DTS in IDENTITY table

Hi

I need to insert values from a text-file to a table with a primary key as identity. In the text file I have no idea of the primary key values and i get "foreign key constraint violation" when trying to import null values into the column.

How can I solve the problem? With ordinary insert-statement there is no problem since the table generates identity- key values automatically. Is there a possibility to generate identity values with DTS-import?

Bjrnyes.

you just need to not map anything to the primary key column. In the wizard, you need to hit the transform button and make and under the column mappings make sure ignore is selected. If you are using the DTS desginer, you need to get rid of the mapping on your transform data task under the transformations task.