-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: aamirOnline
Message 7 in Discussion
Hi
You can use ODBC.Net data
provider or OLEDB fo with ODBC data provider, in your case you have specified
wrong connection string without provider
1) OLEDB with ODBC Dirver : you need to
specify database provider : Can you please tell me which database r u
using. if you dont want to specify database provider you will have to use
ODBC.Net
2) ODBC.Net : The
ODBC .NET Data Provider is an add-on component to the
.NET 1.0 Framework SDK. It provides access to native ODBC drivers the
same way the OLE DB .NET Data Provider provides access to native OLE DB
providers.
For SQL Server ODBC Driver' VB.NET
Dim oODBCConnection As Odbc.OdbcConnection
Dim sConnString As String = _
"Driver={SQL Server};" & _
"Server=MySQLServerName;" & _
"Database=MyDatabaseName;" & _
"Uid=MyUsername;" & _
"Pwd=MyPassword"
oODBCConnection = New Odbc.OdbcConnection(sConnString)
oODBCConnection.Open()Hope this will help you outregardsm aamir maniar[System Analyst
(CWS)][Freelance OOPD Consultant]
-----------------------------------------------------------
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]
