SQL 연결확인 하기
SQL Database에 연결이 정상적으로 되는지 확인하는 코드는 다음과 같다. SQL Server에 계정과 비밀번호로 접속하고 연결이 되는지 확인한다.
ServerName은 server IP 가 될수 도 있다. SQL EXPRESS의 경우는 “MY-PC\SQLEXPRESS”와 같이 사용한다.
Data Source=local ;Integrated Security = SSPI 등과 같이 사용하면 SQL 연결상태를 확인를 확인한다.
Integrated Security = SSPI를 삭제하면 계정의 접근여부 까지 확인 할 수 있다
bool isOpened = false; using (SqlConnection conn = new SqlConnection(string.Format(@"Data Source ={0}; User ID = {1}; Password = {2}", ServerName, UserID, Password))) { try { conn.Open(); isOpened = (conn.State == ConnectionState.Open); conn.Dispose(); } catch (Exception e) { MessageBox.Show(e.Message); throw; } finally { if (conn != null) {conn.Close();} }
} return isOpened;
so time for a new one.
댓글 남기기는 문자가 오는데
Hello! I just wanted to ask if you ever have any problems with hackers?
My last blog (wordpress) was hacked and I ended up losing many
months of hard work due to no backup. Do you have any methods to
stop hackers?
Have you ever thought about publishing an e-book or guest authoring on other websites?
I have a blog centered on the same subjects you discuss and would really like to have
you share some stories/information. I know my audience would appreciate your work.
If you are even remotely interested, feel free to send me an email.
Hello! I know this is kinda off topic but I was wondering which blog platform are you using for this website?
I’m getting tired of WordPress because I’ve had problems with hackers
and I’m looking at options for another platform. I would be great if you could point
me in the direction of a good platform.
Tremendous issues here. I am very glad to peer your
article. Thanks a lot and I’m looking ahead to contact you.
Will you kindly drop me a e-mail?
Wonderful paintings! This is the type of information that are supposed to be shared across the internet. Disgrace on Google for now not positioning this put up higher! Come on over and seek advice from my website . Thanks =)
Hey there! Someone in my Facebook group shared this website with us so I came to take a look.
I’m definitely enjoying the information. I’m book-marking and will be tweeting this
to my followers! Terrific blog and wonderful design and style.