<div>
Check it out<br />
<br />
<a href="http://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp?topic=%2Frzaik%2Fconnectkeywords.htm" rel="ugc nofollow">http://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp?topic=%2Frzaik%2Fconnectkeywords.htm</a>
</div>


Check it out

http://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp?topic=%2Frzaik%2Fconnectkeywords.htm [http://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp?topic=%2Frzaik%2Fconnectkeywords.htm]

<div>
Is creating a DSN optional? &nbsp;When I look at the ODBCConnection Class, the ConnectionString can be like:<br />
<br />
conn.ConnectionString = &quot;Driver={iSeries Access ODBC Driver};System=my_system_n<wbr />ame;Uid=my<wbr />Username;P<wbr />wd=myPassw<wbr />ord;<br />
<br />
What would be the System Name?<br />
<br />
OR, if a DSN is created:<br />
<br />
conn.ConnectionString =&quot;DSN=AS400;UID=myUsername<wbr />;PWD=myPas<wbr />sword;&quot;<br />
<br />
Should I use one over the other?<br />
<br />

</div>


Is creating a DSN optional?  When I look at the ODBCConnection Class, the ConnectionString can be like:

conn.ConnectionString = "Driver={iSeries Access ODBC Driver};System=my_system_name;Uid=myUsername;Pwd=myPassword;

What would be the System Name?

OR, if a DSN is created:

conn.ConnectionString ="DSN=AS400;UID=myUsername;PWD=myPassword;"

Should I use one over the other?



<div>
<div class="content wysiwyg-content">
I have a VB.NET application that uses the ODBCConnection object to connect to a DSN that is defined using the iSeries Access ODBC driver. &nbsp;Right now, I can connect &nbsp;using the DSN name &quot;AS400&quot;, like this: dsn=AS400 as the connection string. &nbsp;<br />
The problem is... my application doesn't Prompt for a user login to the ODBC connection. &nbsp;Is there a way to add a default user and password to the connection OR a way to bring up a prompt for it the first time a connection is requested?
</div>
</div>


I have a VB.NET application that uses the ODBCConnection object to connect to a DSN that is defined using the iSeries Access ODBC driver.  Right now, I can connect  using the DSN name "AS400", like this: dsn=AS400 as the connection string.  
The problem is... my application doesn't Prompt for a user login to the ODBC connection.  Is there a way to add a default user and password to the connection OR a way to bring up a prompt for it the first time a connection is requested?

ODBC iSeries DSN ODBCConnection Login Format

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,

Visual Basic.NET

IBM i, formerly known as AS/400, is a proprietary, midrange, object-based operating and application system. It includes a relational database, a menu-driven interface, support for multiple users, block-oriented terminal support and printers, and supports security, communications, and web-based application servers including Websphere, Apache and Tomcat.

IBM System i

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.