From: Jorge A. B. <li...@da...> - 2009-10-23 14:27:36
|
The "driver" value at the DSN saved into registry (pointing generally to C:\WINDOWS\system32\OdbcFb32.dll), how and where it´s used? (I´ve configured a Windows 2000 with that value - Win2000 doesnt get installed at \windows, but \winnt - ... however, driver seems to work anyway) Regards! -- Jorge Andrés Brugger Informática DASU - Obra Social del Personal de la Universidad Nacional de la Patagonia Comodoro Rivadavia, Chubut, Argentina Teléfono (0297) 446-4444 int. 103 Correo electrónico: jbr...@da... Website: www.dasu.com.ar |
From: Roman S. <rom...@re...> - 2009-10-23 14:56:00
|
> Jorge Andrés Brugger wrote: > > The "driver" value at the DSN saved into registry (pointing generally to > C:\WINDOWS\system32\OdbcFb32.dll), how and where it´s used? > > (I´ve configured a Windows 2000 with that value - Win2000 doesnt get > installed at \windows, but \winnt - ... however, driver seems to work > anyway) > > Regards! > How did you install odbc driver? While installing it is registered in registry, AFAIK. Run odbcad32.exe and look for driver location. -- Roman Simakov |
From: Jorge A. B. <li...@da...> - 2009-10-23 15:50:32
|
Roman, I'm not talking about the driver install, but the DSN data. If you install the driver, and then create a ODBC DSN (for example, "TestDSN"), a new registry key is created at HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\TestDSN Inside that key, there is a value named "Driver", containing "C:\WINDOWS\system32\OdbcFb.dll" (if DSN was created in a WinXP box, change "windows" by "winnt" if using win2000). How is that value used by the driver? (I create the DSN inside my app installer, by adding the necessary registry entries, but today I've realized I was creating always "Driver=C:\WINDOWS\system32\OdbcFb.dll" but there is no such path on win2000). Roman Simakov escribió: >> Jorge Andrés Brugger wrote: >> >> The "driver" value at the DSN saved into registry (pointing generally to >> C:\WINDOWS\system32\OdbcFb32.dll), how and where it´s used? >> >> (I´ve configured a Windows 2000 with that value - Win2000 doesnt get >> installed at \windows, but \winnt - ... however, driver seems to work >> anyway) >> >> Regards! >> >> > > How did you install odbc driver? While installing it is registered in > registry, AFAIK. > Run odbcad32.exe and look for driver location. > > -- Jorge Andrés Brugger Informática DASU - Obra Social del Personal de la Universidad Nacional de la Patagonia Comodoro Rivadavia, Chubut, Argentina Teléfono (0297) 446-4444 int. 103 Correo electrónico: jbr...@da... Website: www.dasu.com.ar |
From: Roman S. <rom...@gm...> - 2009-10-23 19:21:19
|
That value is used by ODBC manager when you connect to the database and provide described DSN. ODBC manager find necessary library. Or I still don't understand your question. You program can work in other way. I can't tell you. Maybe your driver is self-registered in installer? You can start debug ODBC and look into messages. What driver is really used. -- Roman Jorge Andrés Brugger wrote: > Roman, I'm not talking about the driver install, but the DSN data. If > you install the driver, and then create a ODBC DSN (for example, > "TestDSN"), a new registry key is created at > HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\TestDSN > > Inside that key, there is a value named "Driver", containing > "C:\WINDOWS\system32\OdbcFb.dll" (if DSN was created in a WinXP box, > change "windows" by "winnt" if using win2000). > > How is that value used by the driver? (I create the DSN inside my app > installer, by adding the necessary registry entries, but today I've > realized I was creating always "Driver=C:\WINDOWS\system32\OdbcFb.dll" > but there is no such path on win2000). > > Roman Simakov escribió: > >>> Jorge Andrés Brugger wrote: >>> >>> The "driver" value at the DSN saved into registry (pointing generally to >>> C:\WINDOWS\system32\OdbcFb32.dll), how and where it´s used? >>> >>> (I´ve configured a Windows 2000 with that value - Win2000 doesnt get >>> installed at \windows, but \winnt - ... however, driver seems to work >>> anyway) >>> >>> Regards! >>> >>> >>> >> How did you install odbc driver? While installing it is registered in >> registry, AFAIK. >> Run odbcad32.exe and look for driver location. >> >> >> > > |
From: Jorge A. B. <li...@da...> - 2009-10-26 12:43:39
|
Roman: Thanks for answering. I´ll try to be more specific: - To use a ODBC DSN, you need: 1) The ODBC driver registered (and the fbclient, etc) 2) The DSN (Control Panel/Administrative Tools/Data Sources (ODBC)/System DSN **** For (1) the following is created at registry: Windows Registry Editor Version 5.00 [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Firebird/InterBase(r) driver] "UsageCount"=dword:00000001 "Driver"="C:\\WINDOWS\\system32\\OdbcFb.dll" "Setup"="C:\\WINDOWS\\system32\\OdbcFb.dll" "FileExtns"="*.fdb,*.gdb" "APILevel"="1" "ConnectFunctions"="YYY" "FileUsage"="0" "DriverODBCVer"="03.51" "SQLLevel"="1" **** For (2) registry is filled with: Windows Registry Editor Version 5.00 [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\MyDSN] "Description"="Test" "CharacterSet"="ISO8859_1" "ReadOnly"="N" "NoWait"="N" "Dialect"="3" "QuotedIdentifier"="N" "SensitiveIdentifier"="N" "AutoQuotedIdentifier"="N" "UseSchemaIdentifier"="0" "LockTimeoutWaitTransactions"="" "Driver"="C:\\WINDOWS\\system32\\OdbcFb.dll" "SafeThread"="Y" "Dbname"="192.168.1.59:C:\\fbdata\\TEST.FDB" "Client"="" "User"="SYSDBA" "Role"="" "JdbcDriver"="IscDbc" "Password"="<encrypted-password-string>" My question is at (2), specifically the value "Driver"="C:\\WINDOWS\\system32\\OdbcFb.dll". Thay value, is used or not? (at the C++ driver code, I'm not a C programmer and I wasn't able to check if it is used somewere). Regards! Roman Simakov escribió: > That value is used by ODBC manager when you connect to the database and > provide described DSN. ODBC manager find necessary library. > > Or I still don't understand your question. > > You program can work in other way. I can't tell you. Maybe your driver > is self-registered in installer? > > You can start debug ODBC and look into messages. What driver is really used. > > -- > Roman > > > Jorge Andrés Brugger wrote: > >> Roman, I'm not talking about the driver install, but the DSN data. If >> you install the driver, and then create a ODBC DSN (for example, >> "TestDSN"), a new registry key is created at >> HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\TestDSN >> >> Inside that key, there is a value named "Driver", containing >> "C:\WINDOWS\system32\OdbcFb.dll" (if DSN was created in a WinXP box, >> change "windows" by "winnt" if using win2000). >> >> How is that value used by the driver? (I create the DSN inside my app >> installer, by adding the necessary registry entries, but today I've >> realized I was creating always "Driver=C:\WINDOWS\system32\OdbcFb.dll" >> but there is no such path on win2000). >> >> Roman Simakov escribió: >> >> >>>> Jorge Andrés Brugger wrote: >>>> >>>> The "driver" value at the DSN saved into registry (pointing generally to >>>> C:\WINDOWS\system32\OdbcFb32.dll), how and where it´s used? >>>> >>>> (I´ve configured a Windows 2000 with that value - Win2000 doesnt get >>>> installed at \windows, but \winnt - ... however, driver seems to work >>>> anyway) >>>> >>>> Regards! >>>> >>>> >>>> >>>> >>> How did you install odbc driver? While installing it is registered in >>> registry, AFAIK. >>> Run odbcad32.exe and look for driver location. >>> >>> >>> >>> >> >> > > > ------------------------------------------------------------------------------ > Come build with us! The BlackBerry(R) Developer Conference in SF, CA > is the only developer event you need to attend this year. Jumpstart your > developing skills, take BlackBerry mobile applications to market and stay > ahead of the curve. Join us from November 9 - 12, 2009. Register now! > http://p.sf.net/sfu/devconference > _______________________________________________ > Firebird-odbc-devel mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel > > > > -- Jorge Andrés Brugger Informática DASU - Obra Social del Personal de la Universidad Nacional de la Patagonia Comodoro Rivadavia, Chubut, Argentina Teléfono (0297) 446-4444 int. 103 Correo electrónico: jbr...@da... Website: www.dasu.com.ar |
From: Alan B. <_@_._> - 2009-10-24 17:07:26
|
Jorge, Read the "Driver" value from "HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Firebird/InterBase(r) driver" first Then use this value when creating your own DSN inside your app. HTH Alan ""Jorge Andrés Brugger"" <li...@da...> wrote in message news:4AE...@da...... > Roman, I'm not talking about the driver install, but the DSN data. If = > > you install the driver, and then create a ODBC DSN (for example, = > > "TestDSN"), a new registry key is created at = > > HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\TestDSN > > Inside that key, there is a value named "Driver", containing = > > "C:\WINDOWS\system32\OdbcFb.dll" (if DSN was created in a WinXP box, = > > change "windows" by "winnt" if using win2000). > > How is that value used by the driver? (I create the DSN inside my app = > > installer, by adding the necessary registry entries, but today I've = > > realized I was creating always "Driver=3DC:\WINDOWS\system32\OdbcFb.dll" = > > but there is no such path on win2000). > > Roman Simakov escribi=F3: >>> Jorge Andr=E9s Brugger wrote: >>> >>> The "driver" value at the DSN saved into registry (pointing generally to >>> C:\WINDOWS\system32\OdbcFb32.dll), how and where it=B4s used? >>> >>> (I=B4ve configured a Windows 2000 with that value - Win2000 doesnt get >>> installed at \windows, but \winnt - ... however, driver seems to work >>> anyway) >>> >>> Regards! >>> >>> = > >> >> How did you install odbc driver? While installing it is registered in >> registry, AFAIK. >> Run odbcad32.exe and look for driver location. >> >> = > > > -- = > > Jorge Andr=E9s Brugger > Inform=E1tica > DASU - Obra Social del Personal de la Universidad Nacional de la Patagonia > Comodoro Rivadavia, Chubut, Argentina > Tel=E9fono (0297) 446-4444 int. 103 > Correo electr=F3nico: jbr...@da... > Website: www.dasu.com.ar > > > > ---------------------------------------------------------------------------= > --- > Come build with us! The BlackBerry(R) Developer Conference in SF, CA > is the only developer event you need to attend this year. Jumpstart your > developing skills, take BlackBerry mobile applications to market and stay > = > > ahead of the curve. Join us from November 9 - 12, 2009. Register now! > http://p.sf.net/sfu/devconference > _______________________________________________ > Firebird-odbc-devel mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel > |