Actually the best answer would be to check on the PeopleSoft forums, I seem to remember seeing a lot of comments on SQL with PS.

Try

http://www.egroups.com/group/peoplesoft-fans

http://www.peoplesoftpros.com/forums/

Also try google with "PeopleSoft AND...

quote:

---

Thanks for your info Antares686. The link you sent to me is broken; however, I can open a web site using...

Sorry, I understand now. Actually, create your own role and place your users in that role. You can then make a user-defined role a memeber of another role so add...

FIrst try the latest MDAC from Microsoft. http://msdn.microsoft.com/library/default.asp?url=/nhp/Default.asp?contentid=28001860 in most cases this corrects the issue which may be a poor install of those components or an incorrect level.

It could be a limitation of the DAO Object, try using the ADO objects instead to see what happens or post the fully error message with the code where fails.

...

Check out MSDN at madn.microsoft.com. However in VC++ (which is the only place to build them at this point) there is a wizard to get the framework started.

Did you test on a W2k machine without SP4 if not could be related to the heap manager which was changed in SP4. See http://support.microsoft.com/default.aspx?scid=kb;EN-US;195009 otherwise not sure what is...

I do believe that the distributor has to be the same as the Publisher to be able to support all the features of the publisher. But the subscribers can be...

Set it up that way in model and when you create a new DB (since it is based on model) it will be tht way in the new DB. As...

Without being able to look directly at the database I cannot speculate exactly why. May be some piece did not get fixed and was throwing it out incorrectly. However this...

How much free space is on the drive, is the TempDB large and is the log file running out of room. If it becomes full and is not being truncated...

Usually means you have a process where a deadlock is occurring and one has been vicitimized. The problem is finding which one. However if it is an everynight thing then...

The only major issue I ran into was were do to the fact some implicit datatype conversions that worked in SQL 7 no longer happen in SQL 2000. But for...

Also you can try adjusting the transofrmation yourself to make sure it is seeing it. Or make sure the first row has column names.

Is the SQL Server and system setup to talk on the ,amage,emt network? If so the EM will talk to it fine under whatever installed protocols SQL is set to...