Thanks for that advice - but I had already found it in the lists and had accounted for case-sensitive connection string by trying all different combinations.
I think Axel's advice regarding dba and dmo operators (dba should create the user in SQL Studio so that they have rights to connect as non-dmo operators!) should sort me out. Also he has sent me a manual which lloks very useful - I will digest and let you know if I make any progress (I'm sure I will.) Thanks for all the help fellas! I'm getting there...! Regards, Ian Kershaw E-government Development Officer Hyndburn Borough Council 01254 380661 [EMAIL PROTECTED] >>> "Koetter, Thomas Theodor" <[EMAIL PROTECTED]> 10/12/2003 08:32:59 >>> Hi > -----Original Message----- > From: Axel Busch [mailto:[EMAIL PROTECTED] > Sent: Dienstag, 9. Dezember 2003 18:26 > To: 'Ian Kershaw'; [EMAIL PROTECTED] > Subject: AW: ODBC connection string (Windows 2000) & dbmcli command > > > Hi Ian, > > first you have to create a DSN in the odbc manager > control panel -> administration -> data sources (odbc) or > just execute c:\winnt\system32\odbcad32.exe. > > - Choose <add ...>, > - select the MaxDB driver you installed from the MaxDB Server package > (or SAP DB 7.4 ODBC driver, it works as well) > - Choose <finish> > - Enter: > Data Source Name: whatever, lets say "mytest" > Description: blank > Server: "localhost", or ip-address, or dns name > Database: "test" > - <ok> > > The ODBC connection string will then be: > DSN=mytest;UID=sa;PWD=<your password> Please be aware that starting with 7.4.03 build 28 UID and PWD are handled case-sensitive. If you create an user (e.g. in SQLStudio) with create user myuser password mypass this results to an user MYUSER/MYPASS and has to be taken into account in the connect string: DSN=mytest;UID=MYUSER;PWD=MYPASS; If you use create user "myuser" password "mypass" then DSN=mytest;UID=myuser;PWD=mypass; is ok. FYI, the SQLDriverConnect popup dialog uppers UID/PWD unless they are entered qouted (" at the beginning and at the end). HTH Thomas ---------------------------------------------- Dr. Thomas K�tter SAP DB, SAP Labs Berlin Do you know SAP^H^H^H MaxDB ? www.sapdb.org ************************************************************** This e-mail is confidential and is intended solely for the use of the individual or entity to whom it is addressed. If you are not the intended recipient and you have received this e-mail in error then any use,dissemination, forwarding, printing or copying of this e-mail is strictly prohibited and you should contact the sender by e-mail return and then delete all the material from your system. Any views or opinions presented are solely those of the author and do not necessarily represent those of Hyndburn Borough Council. This email does not form a part of a legally binding agreement. We have taken precautions to minimise the risk of transmitting software viruses, but we advise that you carry out your own virus checks on any attachments to this message. We cannot accept liability for any loss or damage done by software viruses. *************************************************************** <<<< GWAVASIG >>>> -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
