Create text file to OS400 folder by using Microsoft SQL Server 2005

20 pts.
Tags:
AS/400 Text File
OS/400
SQL Server 2005
Hi All, Do u have any idea to create text file to the OS400 folder by using MS SQL Server 2005? currently i had map drive with OS400 folder in server. i only can create text file at local server by using Ms SQL Server 2005. No idea to create text file at OS400 folder. But allow use dos command to create output file at OS400 folder. Thanks for reply

Answer Wiki

Thanks. We'll let you know when a new response is added.

Instead of trying to create the folder on the mapped drive, create the file on the OS400 folder using the full network path to the folder.

You will need to make sure that the SQL Server is running under a domain account and that, that account has rights to the network share on the OS400 machine.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following