using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Data.OleDb; namespace ConnectionOledb { class Program { static void Main(string[] args) { OleDbConnection conn = new OleDbConnection(@" provider=sqloledb; data source=.; integrated security =sspi; "); try { conn.Open(); Console.WriteLine("Connection opened."); Console.WriteLine("Connection Properties:"); Console.WriteLine("\tConnection String:{0}", conn.ConnectionString); Console.WriteLine("\tDatabase:{0}", conn.Database); Console.WriteLine("\tDataSource:{0}", conn.DataSource); Console.WriteLine("\tServerVersion:{0}", conn.ServerVersion); Console.WriteLine("\tState:{0}", conn.State); } catch (OleDbException e) { Console.WriteLine("Error: " + e); } finally { conn.Close(); Console.WriteLine("Connection close."); } Console.ReadKey(); } } }
使用OleDbConnection显示连接信息
转载本文章为转载内容,我们尊重原作者对文章享有的著作权。如有内容错误或侵权问题,欢迎原作者联系我们进行内容更正或删除文章。
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章