SERVICES

WEB-HOSTING

MULTI-DOMAIN-HOSTING

PAYMENT

SUPPORT

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

Administration of SQL databases can be done in any number of ways; the easiest of these, however, is to use dedicated administration software.

To administer MySQL databases we recommend using MySQL Administrator and MySQL Query Browser. For more information on these, please see:
http://www.mysql.com/products/tools/administrator/
http://www.mysql.com/products/tools/query-browser/

For MS-SQL, we recommend using Microsoft SQL Server Management Studio Express. See:
http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796

Note that when connecting remotely to a MS SQL database, you should use port 1501.

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

Solution