Originally posted by sashi...
Connection string More samples
MsAccess - Connection String
Standard security
Expand|Select|Wrap|Line Numbers
- oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
- "Data Source=c:\somepath\myDb.mdb;"
Expand|Select|Wrap|Line Numbers
- oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
- "Data Source=c:\somepath\mydb.mdb;" & _
- "Jet OLEDB:System Database=MySystem.mdw", _
- "myUsername", "myPassword"
Expand|Select|Wrap|Line Numbers
- oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
- "Data Source=c:\somepath\mydb.mdb;" & _
- "Jet OLEDB:Database Password=MyDbPassword", _
- "myUsername", "myPassword"
Expand|Select|Wrap|Line Numbers
- oConn.Mode = adModeShareExclusive
- oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
- "Data Source=c:\somepath\myDb.mdb;"
Expand|Select|Wrap|Line Numbers
- oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
- "Data Source=\\myServer\myShare\myPath\myDb.mdb"
DSN
Expand|Select|Wrap|Line Numbers
- oConn.Open "DSN=mySystemDSN;" & _
- "Uid=myUsername;" & _
- "Pwd=myPassword"
Expand|Select|Wrap|Line Numbers
- oConn.Open "FILEDSN=c:\somepath\mydb.dsn;" & _
- "Uid=myUsername;" & _
- "Pwd=myPassword"
For Standard Security
Expand|Select|Wrap|Line Numbers
- oConn.Open "Provider=sqloledb;" & _
- "Data Source=myServerName;" & _
- "Initial Catalog=myDatabaseName;" & _
- "User Id=myUsername;" & _
- "Password=myPassword"
Expand|Select|Wrap|Line Numbers
- oConn.Open "Provider=sqloledb;" & _
- "Server=myServerName;" & _
- "Database=myDatabaseName;" & _
- "User Id=myUsername;" & _
- "Password=myPassword"
Expand|Select|Wrap|Line Numbers
- oConn.Open "Provider=sqloledb;" & _
- "Data Source=myServerName;" & _
- "Initial Catalog=myDatabaseName;" & _
- "Integrated Security=SSPI"
Expand|Select|Wrap|Line Numbers
- oConn.Open "Provider=sqloledb;" & _
- "Data Source=myServerName\myInstanceName;" & _
- "Initial Catalog=myDatabaseName;" & _
- "User Id=myUsername;" & _
- "Password=myPassword"
To Prompt user for username and password
Expand|Select|Wrap|Line Numbers
- oConn.Provider = "sqloledb"
- oConn.Properties("Prompt") = adPromptAlways
- oConn.Open "Data Source=myServerName;" & _
- "Initial Catalog=myDatabaseName"
Expand|Select|Wrap|Line Numbers
- oConn.Open "Provider=sqloledb;" & _
- "Data Source=(local);" & _
- "Initial Catalog=myDatabaseName;" & _
- "User ID=myUsername;" & _
- "Password=myPassword"
Expand|Select|Wrap|Line Numbers
- oConn.Open "Provider=sqloledb;" & _
- "Network Library=DBMSSOCN;" & _
- "Data Source=xxx.xxx.xxx.xxx,1433;" & _
- "Initial Catalog=myDatabaseName;" & _
- "User ID=myUsername;" & _
- "Password=myPassword"