oConn.Open "Provider=sqloledb; Data Source=myServerName; Initial Catalog=myDatabaseName; User Id=myUsername; Password=myPassword"
myServerName - will usually take the form of sqlx.server.net. It is recommended to always use the domain form of the sql server instead of an ip. As we do move sql server databases to newer servers from time to time.
Article ID: 272, Created: 4/24/2009 at 9:32 AM, Modified: 4/25/2009 at 11:57 AM