| Author |
dbunload doesnt work on clientmachine
|
|
| Sascha Meyer 2005-04-13, 3:23 am |
| hi @ll
i need to upgrade alle client databases from anywhere 5 to anywhere 9.
i add to my migrationfunction a automatic call to the dbunload utility.
lst_run = "dbunload.exe -c" + '"' + "uid=" + gst_CRPEUserID + ";pwd=" +
gst_CRPEUserPwd + ";dbf=" + gst_dbdir + "\" + gst_CRPEDBName + '"' + " -ar
" + gst_dbdir
ll_ret = run(lst_run)
now on my developmentmachine everything works fine. but on client machines
there is a problem.
The utility starts well but after its i get this message:
**** SQL Error: Cannot convert between requested character sets 'utf8' and
'cp850'
The deployed files are:
dbcon9.dll
dbctrs9.dll
dbeng9.exe
dblgen9.dll
dblib7.dll
dblib9.dll
dbodbc9.dll
dbserv9.dll
dbtool9.dll
dbunload.exe
And no one of these files are registed in the registry.
anyone knows something that helps me?
thanks
sascha
| |
| Chris Keating \(iAnywhere Solutions\) 2005-04-13, 9:23 am |
| Rather than using an -ar option, have you tried separating the unload and
reload processes? Do you have the same problem?
"Sascha Meyer" <smeyer at atus dot ch> wrote in message
news:425ccf17@forums
-2-dub...
> hi @ll
>
> i need to upgrade alle client databases from anywhere 5 to anywhere 9.
> i add to my migrationfunction a automatic call to the dbunload utility.
>
> lst_run = "dbunload.exe -c" + '"' + "uid=" + gst_CRPEUserID + ";pwd=" +
> gst_CRPEUserPwd + ";dbf=" + gst_dbdir + "\" + gst_CRPEDBName + '"' +
> " -ar " + gst_dbdir
> ll_ret = run(lst_run)
>
> now on my developmentmachine everything works fine. but on client machines
> there is a problem.
> The utility starts well but after its i get this message:
>
> **** SQL Error: Cannot convert between requested character sets 'utf8' and
> 'cp850'
>
> The deployed files are:
> dbcon9.dll
> dbctrs9.dll
> dbeng9.exe
> dblgen9.dll
> dblib7.dll
> dblib9.dll
> dbodbc9.dll
> dbserv9.dll
> dbtool9.dll
> dbunload.exe
>
> And no one of these files are registed in the registry.
>
> anyone knows something that helps me?
>
> thanks
> sascha
>
>
| |
| Sascha Meyer 2005-04-13, 9:23 am |
| Yes but i get the message later. It starts with unload the data but after a
few tables it shows again the same message.
"Chris Keating (iAnywhere Solutions)" < Spam_NoThanks_keatin
g@iAnywhere.com>
schrieb im Newsbeitrag news:425d16e9$1@foru
ms-1-dub...
> Rather than using an -ar option, have you tried separating the unload and
> reload processes? Do you have the same problem?
>
>
> "Sascha Meyer" <smeyer at atus dot ch> wrote in message
> news:425ccf17@forums
-2-dub...
>
>
| |
| Reg Domaratzki \(iAnywhere Solutions\) 2005-04-13, 9:23 am |
| ASA Programming Guide
Deploying Databases and Applications
Deploying database servers
In this section of the docs it states that when deploying a database server,
you need to include dbunic9.dll, asa.cvf and the charsets\ directory. These
files are needed to do character set translation, which is what is failing
at the client sites during your unload.
--
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
"Sascha Meyer" <smeyer at atus dot ch> wrote in message
news:425ccf17@forums
-2-dub...
> hi @ll
>
> i need to upgrade alle client databases from anywhere 5 to anywhere 9.
> i add to my migrationfunction a automatic call to the dbunload utility.
>
> lst_run = "dbunload.exe -c" + '"' + "uid=" + gst_CRPEUserID + ";pwd=" +
> gst_CRPEUserPwd + ";dbf=" + gst_dbdir + "\" + gst_CRPEDBName + '"' +
" -ar
> " + gst_dbdir
> ll_ret = run(lst_run)
>
> now on my developmentmachine everything works fine. but on client machines
> there is a problem.
> The utility starts well but after its i get this message:
>
> **** SQL Error: Cannot convert between requested character sets 'utf8' and
> 'cp850'
>
> The deployed files are:
> dbcon9.dll
> dbctrs9.dll
> dbeng9.exe
> dblgen9.dll
> dblib7.dll
> dblib9.dll
> dbodbc9.dll
> dbserv9.dll
> dbtool9.dll
> dbunload.exe
>
> And no one of these files are registed in the registry.
>
> anyone knows something that helps me?
>
> thanks
> sascha
>
>
| |
| John Smirnios 2005-04-13, 9:23 am |
| This may be relevant but you didn't mention the version you are using so
I cannot tell for sure:
Versions affected: 901 (after build 1827 and before build 1879)
Versions fixed: 901 (build 1879), main90 and mainline
Modules affected: dbtool?.dll
Description:
After 9.0.1 EBF ( build 1827 and after ) is applied, dbunload would
report character set conversion error when UNILIB character set
conversion tables ( the uct files under charsets\unicode folder ) are
not deployed with database server . This problem has been fixed.
However, if UNILIB character set conversion tables are not present for
the server, object names which contain non-English characters can be
mangled in messages when database character set is different than client
character set.
-john.
--
John Smirnios
Senior Software Developer
iAnywhere Solutions Engineering
Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
Developer Community at http://www.ianywhere.com/developer
Sascha Meyer wrote:
> hi @ll
>
> i need to upgrade alle client databases from anywhere 5 to anywhere 9.
> i add to my migrationfunction a automatic call to the dbunload utility.
>
> lst_run = "dbunload.exe -c" + '"' + "uid=" + gst_CRPEUserID + ";pwd=" +
> gst_CRPEUserPwd + ";dbf=" + gst_dbdir + "\" + gst_CRPEDBName + '"' + " -ar
> " + gst_dbdir
> ll_ret = run(lst_run)
>
> now on my developmentmachine everything works fine. but on client machines
> there is a problem.
> The utility starts well but after its i get this message:
>
> **** SQL Error: Cannot convert between requested character sets 'utf8' and
> 'cp850'
>
> The deployed files are:
> dbcon9.dll
> dbctrs9.dll
> dbeng9.exe
> dblgen9.dll
> dblib7.dll
> dblib9.dll
> dbodbc9.dll
> dbserv9.dll
> dbtool9.dll
> dbunload.exe
>
> And no one of these files are registed in the registry.
>
> anyone knows something that helps me?
>
> thanks
> sascha
>
>
| |
| Sascha Meyer 2005-04-13, 9:23 am |
| Now it looks better but i got another error->
Message "Cannot access file 'mksad60.sql' -- No such file or directory
"Reg Domaratzki (iAnywhere Solutions)" < Spam_bad_rdomarat@ia
nywhere.com>
schrieb im Newsbeitrag news:425d24c8$1@foru
ms-2-dub...
> ASA Programming Guide
> Deploying Databases and Applications
> Deploying database servers
>
> In this section of the docs it states that when deploying a database
> server,
> you need to include dbunic9.dll, asa.cvf and the charsets\ directory.
> These
> files are needed to do character set translation, which is what is failing
> at the client sites during your unload.
>
> --
> 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
>
> "Sascha Meyer" <smeyer at atus dot ch> wrote in message
> news:425ccf17@forums
-2-dub...
> " -ar
>
>
| |
| Oliver Albrecht 2005-04-13, 9:23 am |
| On 13 Apr 2005 00:49:47 -0700, Sascha Meyer wrote:
Hello Sascha,
we had the same problem. Deploying the Charsets directory
from the ASA-Install solved the problem. See also in the
Help "deploying database servers".
kind regards
Oliver
> hi @ll
>
> i need to upgrade alle client databases from anywhere 5 to anywhere 9.
> i add to my migrationfunction a automatic call to the dbunload utility.
>
> lst_run = "dbunload.exe -c" + '"' + "uid=" + gst_CRPEUserID + ";pwd=" +
> gst_CRPEUserPwd + ";dbf=" + gst_dbdir + "\" + gst_CRPEDBName + '"' + " -ar
> " + gst_dbdir
> ll_ret = run(lst_run)
>
> now on my developmentmachine everything works fine. but on client machines
> there is a problem.
> The utility starts well but after its i get this message:
>
> **** SQL Error: Cannot convert between requested character sets 'utf8' and
> 'cp850'
>
> The deployed files are:
> dbcon9.dll
> dbctrs9.dll
> dbeng9.exe
> dblgen9.dll
> dblib7.dll
> dblib9.dll
> dbodbc9.dll
> dbserv9.dll
> dbtool9.dll
> dbunload.exe
>
> And no one of these files are registed in the registry.
>
> anyone knows something that helps me?
>
> thanks
> sascha
Oliver Albrecht
Albrecht Software Solutions
Remove the nosp_ from the address before e-mailing.
--
Programmers don't die!
They just GOSUB without RETURN...
| |
| Reg Domaratzki \(iAnywhere Solutions\) 2005-04-13, 9:23 am |
| The scripts directory is needed if you want to initialize a new database,
which dbunload -ar does.
--
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
"Sascha Meyer" <smeyer at atus dot ch> wrote in message
news:425d297a@forums
-2-dub...
> Now it looks better but i got another error->
> Message "Cannot access file 'mksad60.sql' -- No such file or directory
>
>
>
> "Reg Domaratzki (iAnywhere Solutions)" < Spam_bad_rdomarat@ia
nywhere.com>
> schrieb im Newsbeitrag news:425d24c8$1@foru
ms-2-dub...
failing[color=darkre
d]
>
>
| |
| Sascha Meyer 2005-04-13, 11:23 am |
| Ok it works!
Thanks for your help!
"Reg Domaratzki (iAnywhere Solutions)" < Spam_bad_rdomarat@ia
nywhere.com>
schrieb im Newsbeitrag news:425d2b00$1@foru
ms-2-dub...
> The scripts directory is needed if you want to initialize a new database,
> which dbunload -ar does.
>
> --
> 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
>
> "Sascha Meyer" <smeyer at atus dot ch> wrote in message
> news:425d297a@forums
-2-dub...
> failing
>
>
|
|
|
|