Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

I used to use DAO to connect to my SQL Server. How do I establish a connection to SQL Server using ODBCDirect?

April 26, 2017Connect connection DAO odbcdirect SQL Server Used

0

Posted

I used to use DAO to connect to my SQL Server. How do I establish a connection to SQL Server using ODBCDirect?

1 Answer

0

Posted

For this, we need to create a new Connection object using the OpenConnection method. The new Connection object can be viewed as just a modified Database object, containing information about the connection, such as the server name, the data source name, and so on. The following code sample demonstrates a typically “preconnect” routine using ODBCDirect.