UPERC.ORG



Connection strings for AccessProviders for Access??Microsoft Jet OLE DB 4.0??.NET Framework Data Provider for OLE DB (OleDbConnection)??Microsoft Access ODBC Driver??.NET Framework Data Provider for ODBC (OdbcConnection)Community ForumsFind solutions and post questions regarding connection string related issues.Forum for Access >>Microsoft Jet OLE DB 4.0Type:????OLE DB ProviderUsage:? Provider=Microsoft.Jet.OLEDB.4.0Manufacturer:??MicrosoftCustomize stringexample values ?Standard securityProvider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;User Id=admin;Password=;How to Use JET in 64 bit environments >>?With database passwordThis is the connection string to use when you have an access database protected with a password using the Set Database Password function in Access.Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;Jet OLEDB:Database Password=MyDbPassword;Some reports of problems with password longer than 14 characters. Also that some characters might cause trouble. If you are having problems, try change password to a short one with normal characters.?Workgroup (system database)Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;Jet OLEDB:System Database=system.mdw;??Workgroup (system database) specifying username and passwordProvider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;Jet OLEDB:System Database=system.mdw;User ID=myUsername;Password=myPassword;??DataDirectory functionalityProvider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\myDatabase.mdb;User Id=admin;Password=;??Network LocationProvider=Microsoft.Jet.OLEDB.4.0;Data Source=\\serverName\shareName\folder\myDatabase.mdb;User Id=admin;Password=;??Using RDS (MS Remote)Access database over HTTP. You must setup RDS on the server for his to work.Provider=MS Remote;Remote Provider=Microsoft.Jet.OLEDB.4.0;Remote Server= Source=d:\myPath\myDatabase.mdf;? HYPERLINK "javascript:ccstc(document.getElementById('p0cs6'));" ?ExclusiveUsed to get exclusive access to the database if you, for instance, want to let the application be able to reset the database password.Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;Mode=Share Exclusive;User Id=admin;Password=;? HYPERLINK "javascript:ccstc(document.getElementById('p0cs7'));" ?.NET Framework Data Provider for OLE DBType:????.NET Framework Wrapper Class LibraryUsage:? System.Data.OleDb.OleDbConnectionManufacturer:??Microsoft HYPERLINK "" More info about this wrapper class library ? HYPERLINK "" Customize stringexample values ?Bridging to Jet OLE DB 4.0This is just one connection string sample for the wrapping OleDbConnection class that calls the underlying OLEDB provider. See respective OLE DB provider for more connection strings to use with this class.Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;User Id=admin;Password=;? HYPERLINK "javascript:ccstc(document.getElementById('p1cs0'));" ?Microsoft Access ODBC DriverType:????ODBC DriverUsage:? Driver={Microsoft Access Driver (*.mdb)}Manufacturer:??Microsoft HYPERLINK "" Customize stringexample values ?Standard SecurityDriver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Uid=Admin;Pwd=;? HYPERLINK "javascript:ccstc(document.getElementById('p2cs0'));" ?WorkgroupDriver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;SystemDB=C:\mydatabase.mdw;? HYPERLINK "javascript:ccstc(document.getElementById('p2cs1'));" ?ExclusiveDriver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Exclusive=1;Uid=admin;Pwd=;? HYPERLINK "javascript:ccstc(document.getElementById('p2cs2'));" ?Enable admin statementsTo enable certain programatically admin functions such as CREATE USER, CREATE GROUP, ADD USER, GRANT, REVOKE and DEFAULTS (when making CREATE TABLE statements) use this connection string.Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Uid=Admin;Pwd=;ExtendedAnsiSQL=1;? HYPERLINK "javascript:ccstc(document.getElementById('p2cs3'));" ?Specifying locale identifierUse this one to specify the locale identifier which can help with non-US formated dates.Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Locale Identifier=2057;Uid=Admin;Pwd=;The above example uses the en-gb locale identifier (2057) HYPERLINK "javascript:ccstc(document.getElementById('p2cs4'));" ?.NET Framework Data Provider for ODBCType:????.NET Framework Wrapper Class LibraryUsage:? System.Data.Odbc.OdbcConnectionManufacturer:??Microsoft HYPERLINK "" More info about this wrapper class library ? HYPERLINK "" Customize stringexample values ?Bridging to Microsoft Access ODBC DriverThis is just one connection string sample for the wrapping OdbcConnection class that calls the underlying ODBC Driver. See respective ODBC driver for more connection strings to use with this class.Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Uid=Admin;Pwd=; ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download