Connection To DataBase
-
Hi All Iam Using the SqlConnection To Connect To Sql Server 2005 And the connecte is Done . I wount to Connecte to Sql Server 2005 By Using OledbConnection Or ODBCConnection , My Quesion Is : how I Can Connecte to Sql Server 2005 With OLedbConnection Or ODBCConnection ? and it is a Write Connect ? Thanks For any body help me :rose:
Thaer
-
Hi All Iam Using the SqlConnection To Connect To Sql Server 2005 And the connecte is Done . I wount to Connecte to Sql Server 2005 By Using OledbConnection Or ODBCConnection , My Quesion Is : how I Can Connecte to Sql Server 2005 With OLedbConnection Or ODBCConnection ? and it is a Write Connect ? Thanks For any body help me :rose:
Thaer
-
Ok Thanks Mr Pedram Behroozi iwount To Know Can I Use The ODBCConnection Or OledbConnection to Connecte to Sql Server 2005 :rose:
Thaer
-
Ok Thanks Mr Pedram Behroozi iwount To Know Can I Use The ODBCConnection Or OledbConnection to Connecte to Sql Server 2005 :rose:
Thaer
I think so but OdbcConnection requires an ODBC driver for the database while OleDbConnection requires an OLEDB provider (it's suitable for MSAccess or Oracle). Why don't you use SqlConnection? It's more efficient when using SQL Server because there is no OLEDB provider in between.
Life is 5: 3 me, 1 you.
-
Ok Thanks Mr Pedram Behroozi iwount To Know Can I Use The ODBCConnection Or OledbConnection to Connecte to Sql Server 2005 :rose:
Thaer
Yes, you can use ODBCConnection to connect to a SQL Server database, however, you really should use SQlConnection, which is specifically written for SQL Server. ODBC connections are necessarily generic where as the SQL connection offers enhanced performance and capabilities specific to SQL Server.
only two letters away from being an asset
-
Hi All Iam Using the SqlConnection To Connect To Sql Server 2005 And the connecte is Done . I wount to Connecte to Sql Server 2005 By Using OledbConnection Or ODBCConnection , My Quesion Is : how I Can Connecte to Sql Server 2005 With OLedbConnection Or ODBCConnection ? and it is a Write Connect ? Thanks For any body help me :rose:
Thaer
OledbConnection is not For SQL SqlConnection is for SQL, ODBCConnection is Fine, but i suggest you use ODBCConnection
Vuyiswa Maseko, Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding VB.NET/SQL7/2000/2005 http://vuyiswamb.007ihost.com http://Ecadre.007ihost.com vuyiswam@tshwane.gov.za
-
Hi All Iam Using the SqlConnection To Connect To Sql Server 2005 And the connecte is Done . I wount to Connecte to Sql Server 2005 By Using OledbConnection Or ODBCConnection , My Quesion Is : how I Can Connecte to Sql Server 2005 With OLedbConnection Or ODBCConnection ? and it is a Write Connect ? Thanks For any body help me :rose:
Thaer
Yes u can use OLeDBConnection & ODBCConnection to connect with SQL 2005 but .Net provided SQLConnection class to reduce the overhead while connecting with SQL using OLeDB or ODBC SQLConnection specifically built for SQL. So if you use SQLConnection it will save time and your application will be more efficient as compared if you ODBC or OLeDB
-
OledbConnection is not For SQL SqlConnection is for SQL, ODBCConnection is Fine, but i suggest you use ODBCConnection
Vuyiswa Maseko, Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding VB.NET/SQL7/2000/2005 http://vuyiswamb.007ihost.com http://Ecadre.007ihost.com vuyiswam@tshwane.gov.za
Vuyiswa Maseko wrote:
i suggest you use ODBCConnection
You mean SqlConnection don't you?
Giorgi Dalakishvili #region signature My Articles Asynchronous Registry Notification Using Strongly-typed WMI Classes in .NET [^] My blog #endregion
-
Vuyiswa Maseko wrote:
i suggest you use ODBCConnection
You mean SqlConnection don't you?
Giorgi Dalakishvili #region signature My Articles Asynchronous Registry Notification Using Strongly-typed WMI Classes in .NET [^] My blog #endregion
Oops typo i meant that yes thanks
Vuyiswa Maseko, Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding VB.NET/SQL7/2000/2005 http://vuyiswamb.007ihost.com http://Ecadre.007ihost.com vuyiswam@tshwane.gov.za