-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: nitin_karan
Message 6 in Discussion
HI,
You cannot use the DSN based connection with the SqlClient.
For your purpose you can go through ODBCConnection.
Dim oODBCConnection As OdbcConnection
Dim sConnString As String = "Dsn=myDsn;" & _
"Uid=myUsername;" & _
"Pwd=myPassword"
oODBCConnection = New Odbc.OdbcConnection(sConnString)
oODBCConnection.Open()
However still why are you going for DSN Based connection.
As far as the performance and other features are concerned you should go on with the
Native SqlClient class that provides you the fastest access to the SQL Server bcz it
uses the TDS protocol that is native to SQL Server.
--Nitin
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
