O7: ODBC Admin of DSN drivers

Tom Stecki pc_code_warrior at yahoo.com
Tue Jun 28 18:48:50 EDT 2016


Gavin,
Using Omnis 7 v3.8.1 and Windows 10 the following still works correctly for me.  This will create a User DSN
Register DLL ('ODBCCP32.DLL','SQLConfigDataSource','AJJCC') 
Calculate LV_NULLTERMINATEDSTRING as con('DSN=',LV_DSNNAME,chr(0),'SERVER=',LV_SERVERNAME,chr(0),'DATABASE=',LV_DATABASENAME,chr(0),'USEPROCFORPREPARE=NO',chr(0,0))     
Call DLL ('ODBCCP32.DLL','SQLConfigDataSource',0,1,'SQL Server',LV_NULLTERMINATEDSTRING) 
And this will work if you want to use Encryption and a Trusted Certificate:
Calculate LV_NULLTERMINATEDSTRING as con('DSN=',LV_DSNNAME,chr(0),'SERVER=',LV_SERVERNAME,chr(0),'DATABASE=',LV_DATABASENAME,chr(0),' ENCRYPT=YES',chr(0),'TrustServerCertificate=YES',chr(0),'USEPROCFORPREPARE=NO',chr(0,0))
Call DLL ('ODBCCP32.DLL','SQLConfigDataSource',0,1,'SQL Server Native Client 10.0',LV_NULLTERMINATEDSTRING)     

Tom 

    On Tuesday, June 28, 2016 4:34 AM, Phil (OmnisList) <phil at pgpotter.co.uk> wrote:
 

 Hi Gav.,

Haven't tried it, but even the 64bit dlls are called xxx32.dll so you 
may need to specifically call the 32 bit dll within the syswow64 folder...


regards
Phil Potter
Based in Chester in the UK.

On 28/06/2016 10:56, Gavin Foster wrote:
> Hi all,
>
> Omnis 7 v3.8.1 (32 bit)
> Windows 7 (64 bit)
>
> Does anyone know why the following will not work any longer:
>
> Register DLL ('ODBCCP32.DLL','SQLConfigDataSource','AJJCC') with return value lvError
>
> We know that when running a 32 bit application like O7 on 64 bit Windows, you have to create DSN’s using C:/Windows/SysWOW64/odbcad32.exe
> However, you would have thought the above reference to a 32 bit DLL would continue to work too.
> Are we missing something?
>
> There is a Studio tech note for 32 bit Studio versions 4.2 and 4.3 here: http://omnis.net/technotes/tnsq0015.jsp <http://omnis.net/technotes/tnsq0015.jsp>
> This also seems not to work any longer.
>
> Regards
> Gav
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
_____________________________________________________________
Manage your list subscriptions at http://lists.omnis-dev.com


  



More information about the omnisdev-en mailing list