on 2021 Apr 16 1:23 PM
Hi,
I have a dbeng17 OEM authenticated licence for macOS and Windows
When I try to perform a dbunload on Windows it doesn't work but on macOS it works fine. The dbunload command :
"C:\\8sensSybase\\Debug8TPV\\Bin64\\dbunload" -c " UID=DBA;PWD=**;SERVER=**;DBN=Demov6" -an "C:\\8sensSybase\\Debug8TPV\\8Backup\\Demov62.db"
The result of this command is :
SQL Anywhere - Utilitaire de déchargement Version 17.0.8.4003 Connexion et initialisation Déchargement des définitions d'utilisateur et de groupe Déchargement des unités de mesure spatiale Déchargement des systèmes de référence spatiale Déchargement des séquences Déchargement des définitions de table Déchargement des configurations de texte Déchargement des définitions de vue matérialisée Déchargement des définitions d'index Déchargement des fonctions Déchargement des définitions de vue Déchargement des procédures Déchargement des triggers Déchargement des définitions SQL Remote Déchargement des définitions MobiLink Création de la base de données ***** Erreur SQL : Non-respect de l'authentification
If I try to do the same thing on macOS it works fine, the dbunload is perform without any error.
I have the same authenticate.sql file on Windows and macOS and the dbeng17.lic is good to (it refers to my company, the same company in the authenticate.sql)
Did somebody had an idea of what could it be wrong ?
Thanks in advance.
So, indeed it was the SQLANY17 environment variable who wasn't set.
I define it as you said Chris, and it works fine know.
I tried to set it with a command line and I did it with the following command :
setx SQLANY17 "The path" /M
The " are important and the /M means you set a system environment vairable, and you need to be in an "adminstrator shell" to execute the commande.
Thanks for your help.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Wow, I wasn't aware of the SETX command, thanks for the hint:)
If we tried to create a new database we have the same kind of error, a problem with the authentication.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
That suggests that either the contents of authenticate.sql are incorrect or that the file is not found when the database is being created. For the later, may sure that the file is located in the scripts directory and that the the SQLANY17 environment variable is defined and set to the root directory of the SQLA install. Assuming that the authenticate.sql should be same for both platforms, you could diff the file from the macOS and/or try it on Windows.
The athenticate.sql is in the scripts directory, but indeed we think the SQLANY17 environment variable is perhaps not well defined on Windows.
We didn't find the file sa_config.sh in the windows binary. On mac this file had everithing needed to set properly the SQLANY17 environment variable. So do you know the command line for windows to set SQLANY17.
It will not be sufficient to do this at the command line on Windows generally as technically is the case on Linux. If you set it at the command line, it is only visible in that context and processes started there. I would suggest setting it in the Windows environment variables by entering "Environment Variables" in the search next to the Windows Logo icon which will bring up link to the System Properties dialog. At the bottom of that dialog, click Environment Variables. Check the System Variables for SQLANY17 - add or modify the value.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
73 | |
10 | |
8 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.