PC SOFT

GRUPOS DE DISCUSSÃO PROFISSIONAL
WINDEVWEBDEV e WINDEV Mobile

Inicio → WINDEV 2024 → [WD8] Dynamic ODBC
[WD8] Dynamic ODBC
Iniciado por Raimund Schuldhaus, mar., 30 2004 8:07 PM - 3 respostas
Publicado em março, 30 2004 - 8:07 PM
Hi all,
is there a way to use a dynamic ODBC connection or to change the ODBC parameters at runtime?
I have the need to read a TOPSPEED file, but the name and directory has to be defineable at runtime.
I played a little bit with HDescribeConnection and HDescribeFile but without luck.
Raimund
Publicado em março, 30 2004 - 10:39 AM
Like Pter said, you can create a DSN-file.
The DSN-file is a file in Ascii-format.
We create our own DSN-files.
Search your computer with "*.dsn".
With an ACII-editor you can open the DSN-files to examine the format.
For more info you van search www.microsoft.com\msdn\
greetings,
Joop van der Linden
Member of the Dutch speaking WinDev Developer Group (WDG)

Hi you,
is there a way to use a dynamic ODBC connection or to change the ODBC
parameters at runtime?
I have the need to read a TOPSPEED file, but the name and directory has to be
defineable at runtime.
I played a little bit with HDescribeConnection and HDescribeFile but without
luck.
I think you have to go to a more lower level, change or create a DSN ?

Do you know where the parameters are stored? Registry?
Peter



New-Way Automation b.v.
Publicado em março, 30 2004 - 2:26 PM
I think you have to go to a more lower level, change or create a DSN ?
Do you know where the parameters are stored? Registry?
Peter

Thanks Peter and Joop,
I found a solultion without dealing/handling with DSN files and/or Registry settings. My idea comes from the ADO connect string. And what a supprise, it works!
myParam is string = "DRIVER=Topspeed Developer version; NullEmptyStr=N; Oem=N; Extension=LTF; DBQ=D:\CWAB\ICP_cz.ltf\!"
HDescribeConnection("New", myParam)
HChangeConnection(UNNAMED, "New")
Best regards
Raimujnd

http://www.invitec.com
Publicado em março, 31 2004 - 1:07 AM
Hi you,
is there a way to use a dynamic ODBC connection or to change the ODBC
parameters at runtime?
I have the need to read a TOPSPEED file, but the name and directory has to be
defineable at runtime.
I played a little bit with HDescribeConnection and HDescribeFile but without
luck.

I think you have to go to a more lower level, change or create a DSN ?
Do you know where the parameters are stored? Registry?
Peter