Hi,
I successfully created a new database instance with the web interface and now
want to execute some SQL commands. Therefore I now try to connect to my new
instance with some SQL utility, but both the web interface (websql) and
"xsql" tell me that I use a wrong user/password combination (as Database
Manager dbm):
ODBC-Error: [MySQL MaxDB][LIBSQLOD SO][MaxDB] Invalid authorization
specification;-4008 POS(1) Unknown user name/password combination
return-code: SQL_ERROR (-4008).
This is strange as I can connect via webdbm to the instance with the same
user/passwd combination without any problems.
I tried to create a new user with webdbm but also cannot login with websql.
The problem does not seem to be with the websql tool as I have another old
SAPDB 7.4 Database running on another server and I can connect with the MaxDB
websql tool to this database without any problems.
Next I tried to connect with dbmcli and execute the sql statements there, so I
do the following:
dbmcli -u dbm,<passwd> -d zisdb
dbmcli on zisdb>
dbmcli on zisdb>sql_connect dbm,<passwd>
OK
dbmcli on zisdb>sql_execute select * from tables
OK
CONTINUE
-> select result
So, this obviously works.
What am I doing wrong? Did I forget something?
Best Regards,
Hermann
--
[EMAIL PROTECTED]
GPG key ID: 299893C7 (on keyservers)
FP: 0124 2584 8809 EF2A DBF9 4902 64B4 D16B 2998 93C7
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
