CapturedTech.com

Captured Technology

Testing a SQL Server Connection on a Remote Server

Jan 02 2009
183
1

If you are establishing a web server or an application server and need to test the database connectivity from the new server back to the database server, writing a quick visual basic script that produces the feedback needed is an easy solution. Below is the code from a vbs file with the connection information left out. Just complete the connection information and run the script from the new remote server.

Inserting a Unique Identifier (GUID) into a SQL Field

Dec 30 2008
141
0
If you have a database which contains GUIDs as a column of a table, then inserting the unique identifier into the needed column is not always straight forward. I found that converting the needed value into a unique identifier makes adding it to the database error free.

Sending eMails within a .Net Application

Dec 29 2008
174
0

Sending eMails within a .Net application is fairly simple with the use of the System.Net.Mail namespace.

First, import the class:

Imports System.Net.Mail

Then create a function to provide for sending the emails within a public class:

Blog Directory

Latest technology news.
 Patrick Stevens
 523  246271  11/23/2023

FaceBook

Translate