Microsoft access connection string odbc

The connection string is different for different types of ODBC data sources. Have questions or feedback about Office VBA or this documentation?

Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback. Skip to main content. Please rate your experience Yes No. Any additional feedback? Submit and view feedback for This product This page.

View all page feedback. In this article. KeepAlive v KeepAliveInterval v Azure Active Directory Managed Identity authentication. Azure Active Directory Service Principal authentication. In this case, none of the properties are updated. OdbcConnection properties such as Database return only default settings or those settings specified in the ConnectionString. In the Microsoft. NET Framework version 1. It is the responsibility of the underlying ODBC driver to validate the connection string.

If the connection string contains invalid or unsupported properties, the driver may raise an OdbcException at run time. However, in the. The remaining verification is performed by the underlying ODBC driver when the application calls the Open method. The value of the DSN keyword cannot consist only of blanks and should not contain leading blanks. Applications do not have to add braces around the attribute value after the Driver keyword unless the attribute contains a semicolon ; , in which case the braces are required.

If the attribute value that the driver receives includes braces, the driver should not remove them but they should be part of the returned connection string. However, when you use these characters in a keyword, the Driver Manager returns an error when you work with file DSNs, but passes the connection string to the driver for regular connection strings. Any content of an adult theme or inappropriate to a community web site. Any image, link, or discussion of nudity.

Any behavior that is insulting, rude, vulgar, desecrating, or showing disrespect. Any behavior that appears to violate End user license agreements, including providing product keys or links to pirated software. Unsolicited bulk mail or bulk advertising. Any link to or advocacy of virus, spyware, malware, or phishing sites.

Any other inappropriate content or behavior as defined by the Terms of Use or Code of Conduct. Any image, link, or discussion related to child pornography, child nudity, or other child abuse or exploitation.

As per your description, please refer to Overview of connecting to importing data , not all the external data source requires ODBC driver. Additionally, some ODBC driver can be downloaded free, but the data source need payment to use. Therefore, to use ODBC driver, it depends on which external data source want to use. Was this reply helpful? Yes No.