SQL STUDIO doesn't connect to our databases on Windows 7 64 - bit

[Former Member]

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 our mostely 7.7 or older and wer 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

[Former Member · Accepted solution]

We found a solution our selves:

Login as administrator

Remove your user profile according procedure on the link below:

http://superuser.com/questions/63017/how-do-i-delete-a-user-profile-on-a-windows-7-machine-that-is-p...

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.

[Former Member]

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

[Former Member]

It becomes even more rediculous:

i have logged in as a local user and SQLSTUDIO works fine now

But when i log with my normal account on the network domain it IS NOT working

Can anyone explain how on earth that this is even possible?