<div>
Hi dj_alik, This AS400 IBM Console will that need to be installed on the DB Server?<br />
So I'll be able to get the DS and edit the changes through the DB ?<br />
<br />
Thanks,<br />
Jeff
</div>


Hi dj_alik, This AS400 IBM Console will that need to be installed on the DB Server?
So I'll be able to get the DS and edit the changes through the DB ?

Thanks,
Jeff

<div>
not only odbc drivers for oledb linked sql server using...<br />

</div>


not only odbc drivers for oledb linked sql server using...


<div>
You need to talk to the admin of the AS/400 to find out how they may provide access to the file you want.<br />
<br />
If the file is a flat (standard sequential file) then I don't think SQL and ODBC are going to work. &nbsp;ODBC is generally used to access a remote database.<br />
<br />
Do you know what type of file it is?
</div>


You need to talk to the admin of the AS/400 to find out how they may provide access to the file you want.

If the file is a flat (standard sequential file) then I don't think SQL and ODBC are going to work.  ODBC is generally used to access a remote database.

Do you know what type of file it is?

<div>
not what i needed but will accept.
</div>


<div>
<div class="content wysiwyg-content">
I need to connect to a Main Frame Data Set via .Net Technology.<br />
Any suggestions? Can I setup a Linked Server on MS SQL Server and link the IBM Console to get access to the Data Set? or should I do it by XML, FTP etc; <br />
<br />

</div>
</div>


I need to connect to a Main Frame Data Set via .Net Technology.
Any suggestions? Can I setup a Linked Server on MS SQL Server and link the IBM Console to get access to the Data Set? or should I do it by XML, FTP etc; 



Main Frame Data Set Connection

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

A mainframe operating system is networking software infrastructure that allows a mainframe computer to run programs, connect linked machines, and process complex numerical and data-driven tasks. Modern mainframe design is generally defined by redundant internal engineering, extensive input-output facilities, strict backward compatibility with older software, high hardware and computational utilization rates and high stability and reliability. Well-known operating systems include IBM z/OS, z/VM, zTPF, z/VSE, OS/390, and their predecessors, along with MCP for Unisys ClearPath, and NonStop OS/Guardian on HP/Tandem, and questions regarding the IBM midrange operating system called IBM i, OS/400, and i5/OS.