| Reg Domaratzki \(iAnywhere Solutions\) 2005-06-30, 11:24 am |
| You have two different drivers installed on this machine.
Open the registry editor (regedit.exe) and browse to
HKEY_LOCAL_MACHINE\S
OFTWARE\ODBC\ODBCINS
T.INI. Each directory in this
folder represents a driver you have installed. If you look in each folder,
the "Driver" key gives the full path to the driver DLL. Find all the Oracle
ODBC drivers in here, and then check the version of the driver in Windows
Explorer (don't trust the DriverODBCVer key). Note the full path of the
"correct" driver when you find it, as well as the name of the folder.
There are now two ways to make sure your test ML server uses the "correct"
driver.
1) Next, browse to
HKEY_CURRENT_USER\So
ftware\ODBC\ODBC. INI\WhyAreYouStillAt
VersionSevenPointZe
ro where " WhyAreYouStillAtVers
ionSevenPointZero" represents the name of the
DSN that is using the "wrong" driver. Modify the Driver key in this DSN to
point to the "correct" driver.
2) Create a new DSN, and when asked to choose the driver from the list, make
sure you choose the name that matches the folder name in the Registry where
you found the "correct" driver.
--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup
iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL
"Doug" < doogie414removethis@
yahoo.com> wrote in message
news:42c40b69@forums
-1-dub...
> We are using MobiLink server 7.0.0.497. When we start it up and connect to
> our production Oracle 8.01.7400 database the ML server log file says 'ODBC
> DBMS Driver Version: 08.00.5800'. We sync fine from our remotes.
>
> When we connect this same ML server to our test Oracle database of the
same
> version the ML server log file says 'ODBC DBMS Driver Version:
08.01.0700'.
> The remote syncs are a disaster. We are getting 'ORA-12571: TNS:packet
> writer failure' and 'ORA-03114: not connected to ORACLE' errors.
>
> The only driver (we believe) on the server is 08.01.0700. We can't quite
> figure out why the production ML server starts with a different ODBC
driver.
>
> Any thoughts?
>
>
|