on 07-17-2012 4:48 PM
On our WIN XP 32-bit PC's we never had any problems.
On our new laptops running "WINDOWS 7 proffesional 64 -Bit" we in stalled the ODBC driver part of the "maxdb-all-win-64bit-x86_64-7_6_06_10.exe" installer tool => OK
Then we installed Database manager with "maxdb-dbmgui-setup.exe" => OK
THen we installed databse studio 64 bit => works fine Installing SQLSTUDIO with "maxdb-sqlstudio-setup-7_6_03_15.exe" => installation is OK
BUT when we try to connect to one of our maxdb instaces on our company network we get next message:
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
ODBC-Error:[SAP AG][SQLOD32 DLL][MaxDB] Unable to connect to data source;-5015 POS(79) Missing keyword:CHARACTER,SQLMODE,SPACE,NOLOG,NO,CACHELIMIT return-code:SQL_ERROR (-5015) >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
The problem is that we develop lots of python 2.6 32-bit code
accessing the database using the SQLSTUDIO "SQLSTUDIOODBC"-driver returning the same error.
When running "c:\windows\sysWoW64\odbcad32.exe" we see that the "SQLSTUDIOODBC"-driver for 32-bit ODBC is really installed.
Our databases are mostely 7.7 or older and were always accessable from windows XP using the 7.6 ODBC drivers.
Can someone look at this and come up with a solution because it is blocking our development.
Best Regards,
Filip Godefroi Newtec Cy Test development Team
We found a solution our selves:
Login as administrator
Remove your user profile according procedure on the link below:
Restart your PC and login with your normal user name and password
Now it works!
But you wil have to reinitialize your mail, wireless lan, skype, jabber
afterwards
It was a user profile related issue.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Aditional info:
Testing the 32-bit odbc of SqlStudio:
C:\Program Files (x86)\SDB\SQLStudio>odbcreg "SQLSTUDIOODBC" -t
MDAC version: 6.1.7601.17514
ODBC Driver test for 'SQLSTUDIOODBC'.
not connected (SQLSTUDIOODBC).
SQLstate: 08001
esq_sql_code: -5015 [SAP AG][SQLOD32 DLL][MaxDB] Unable to connect t
o data source;-5015 POS(68) Missing keyword:CHARACTER,TIMEOUT,SQLMODE,SPACE,NOLO
G,NO,CACHELIMIT
When testing the 64-bit drivers the connection seems to work:
c:\Program Files\sdb\globalprograms\pgm>odbcreg "MAXDB (Unicode)" -t
MDAC version: 6.1.7601.17514
ODBC Driver test for 'MAXDB (Unicode)'.
Driver version 7.6.6 b010.
So "MDAC version: 6.1.7601.17514" is used in both cases but seems not to work for 32-bit odbc
=> WHY THE HELL DOES IT NOT WORK !!!
Can sombody help us out please.
The strange thing is that we have 3 Lenovo W520 laptops with Windows 7 professional (64 bit) and on 2 of the 3 we see this problem
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.