OLEDB Provider Connect String for SQL Server

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.

Add Feedback