Solution

With MS SQL databases, while the server IP is always the same, the connection port is different if you are trying to connect remotely (with SQL Management Studio or similar software) or locally (from a script).

When connecting remotely to MS SQL databases, you should use port 1501. In Management Studio, for example, under 'server name', you should enter: 67.19.166.82,1501 

When connecting locally, from a script, you should use port 1433 instead

Solution

OLE DB Connection Strings:

While ODBC drivers are currently available, we nonetheless recommend the use of OLE DB instead. Example connection strings for various database systems are available below:

MS Access:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;User Id=admin;Password=;"

SQL Server:
"Provider=sqloledb;Data Source= 67.19.166.82,1433;Network Library=DBMSSOCN;Initial Catalog=pubs;User ID=sa;Password=asdasd;"

Excel:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1"""

Text:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\txtFilesFolder\;Extended Properties=""text;HDR=Yes;FMT=Delimited"""

DBF / FOXPRO:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\folder;Extended Properties=dBASE IV;User ID=Admin;Password="

Visual FoxPro:

Database container (.DBC):
"Provider=vfpoledb.1;Data Source=C:\MyDbFolder\MyDbContainer.dbc;Collating Sequence=machine"

Free table directory:
"Provider=vfpoledb.1;Data Source=C:\MyDataDirectory\;Collating Sequence=general"

MySQL:

MyODBC 2.50 Remote database:
"Driver={mySQL};Server=67.19.166.82;Port=3306;Option=131072;Stmt=;Database=my-database;Uid=username;Pwd=password;"

MyODBC 3.51 Remote database:
"DRIVER={MySQL ODBC 3.51 Driver};SERVER=67.19.166.82;PORT=3306;DATABASE=myDatabase; USER=myUsername;PASSWORD=myPassword;OPTION=3;"

Please remember, though, that these are just generic examples; you should make sure you use your own credentials and database information instead of the examples here.

Solution

'This is an example only, and needs to be modified with proper information

'Sub SendEmail()

'create the mail message
Dim nmail As New System.Net.Mail.MailMessage

'set the addresses
nmail.To.Clear()
nmail.To.Add(New System.Net.Mail.MailAddress("recipient name "))
nmail.From = New System.Net.Mail.MailAddress("my name ")

'set the content
nmail.Subject = "This is an email"
nmail.Body = "this is the body content of the email."

'prepare to send the message
Dim smtp As System.Net.Mail.SmtpClient = New System.Net.Mail.SmtpClient("mail.mydomain.tld")

'you need to use the credentials of an existing mail account
smtp.Credentials = New System.Net.NetworkCredential("me@mydomain.tld", "mypassword")

Try
smtp.Send(nmail)
Catch ex As Exception
Response.Write("Error: " & ex.ToString())
End Try

End Sub

Solution

Solution

Solution