Installation in Windows

[carl1121]

We would like to understand how to register or install the odbccpp.dll file such that it is part of the list in the Drivers tab of the ODBC Data Source Administrato

That way client applications can use a data source name and the driver wrapper to then connect to SQL Server. The idea is to have the ability to inspect the SQL and potentially optimize it before submitting it to SQL Server for execution

Thanks!

[mrylov]

It seems there is a misunderstanding of what the odbc-cpp library is. The odbc-cpp library is just a wrapper of the ODBC API that allows to work with one of the available ODBC drivers (see your image) installed on a given machine. In other words, it is not a driver and any installation (copying to a custom directory) won't list it in the tab mentioned above.

[carl1121]

I understand it is just a wrapper that then loads the actual driver. However, we need to make it look like a driver to the operating system so that a client application such as SQL Server management studio can access it by using the DSN.. Get Outlook for iOS<https://aka.ms/o0ukef>

…

________________________________ From: Maxim Rylov ***@***.***> Sent: Thursday, March 10, 2022 4:30:46 AM To: SAP/odbc-cpp-wrapper ***@***.***> Cc: carl1121 ***@***.***>; Author ***@***.***> Subject: Re: [SAP/odbc-cpp-wrapper] Installation in Windows (Issue #28) It seems there is a misunderstanding of what the odbc-cpp library is. The odbc-cpp library is just a wrapper of the ODBC API that allows to work with one of the available ODBC drivers (see your image) installed on a given machine. In other words, it is not a driver and any installation (copying to a custom directory) won't list it in the tab mentioned above. — Reply to this email directly, view it on GitHub<#28 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AVEFIRPBSMSEPEJBSGM4EL3U7G6MNANCNFSM5QK7DNGQ>. Triage notifications on the go with GitHub Mobile for iOS<https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android<https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>. You are receiving this because you authored the thread.Message ID: ***@***.***>

[mrylov]

The SQL Server management studio wont' be able to access it in no case, unless you use the wrapper in your C++ implementation of the client application.

[carl1121]

Correct, not in it’s current state. We are thinking of writing another program to use the Microsoft ODBC installer API in order to add the wrapper to the list of drivers. So that the odbccpp.dll is a driver facade to the underlying SQL Server driver. We think an installation program is needed per the following https://docs.microsoft.com/en-us/cpp/mfc/tn048-writing-odbc-setup-and-administration-programs?view=msvc-170 [https://docs.microsoft.com/en-us/media/logos/logo-ms-social.png]<https://docs.microsoft.com/en-us/cpp/mfc/tn048-writing-odbc-setup-and-administration-programs?view=msvc-170> TN048: Writing ODBC Setup and Administration Programs for MFC Database Applications | Microsoft Docs<https://docs.microsoft.com/en-us/cpp/mfc/tn048-writing-odbc-setup-and-administration-programs?view=msvc-170> Applications using MFC database classes will need a setup program that installs ODBC components. They may also need an ODBC Administration program that will retrieve information about the available drivers, to specify default drivers and to configure data sources. docs.microsoft.com On Mar 10, 2022, at 7:26 AM, Maxim Rylov ***@***.***> wrote:  The SQL Server management studio wont' be able to access it in no case, unless you use the wrapper in your C++ implementation of the client application. — Reply to this email directly, view it on GitHub<#28 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AVEFIRLPCGPN4GYV4FVB7SDU7HTANANCNFSM5QK7DNGQ>. Triage notifications on the go with GitHub Mobile for iOS<https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android<https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>. You are receiving this because you authored the thread.Message ID: ***@***.***>

[stefanuhrig]

Hi carl1121,

This project is a C++ wrapper of the C-based ODBC API. It is not a wrapper of an ODBC driver, so there is no way to register the compiled .dll as an ODBC driver.

If you'd like to develop an ODBC driver wrapper, a good starting point might be an actual ODBC driver. You might have a look at the open-source PostgreSQL ODBC driver (https://git.postgresql.org/gitweb/?p=psqlodbc.git;a=tree) to get an idea how to implement an ODBC driver.

Cheers,
Stefan