Hi Alex - I know about all the details you gave me - I was trying a UDL file before I mailed the group, and used the DSN entry created by the installation (MAXDB) to create a system DSN also.
But no connection - constantly rejected with "-4008 Unkown username/password combination". Have tried lot of different combinations of DSN and connection strings, but always through the "Microsoft OLEDB provider for ODBC Drivers". I even tried adding a new user (webuser/webuser) and connecting as this one, but no luck there either. I realise that it is trying to validate with the instance because if I change the server name it gives an error regarding not locating an instance - therefore I have got so far...but not all the way! By the way - for further information - I cannot use DB manager as the system administrator, and I cannot use SQL Studio as database manager operator, but they connect fine vice versa. Is this by design? (I cannot use either as webuser that I created above - even though I gave him all rights, I cannot seem to do anything with him!) Could this be a problem with ODBC or my local accounts in general? Regards, Ian Kershaw E-government Development Officer Hyndburn Borough Council 01254 380661 [EMAIL PROTECTED] >>> "Axel Busch" <[EMAIL PROTECTED]> 09/12/2003 17:26:27 >>> 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> Tip: create an empty file "test.udl" on your desktop or wherever to test your connection. Doubleclick on it. Select "Microsoft Ole DB Provider for ODBC Drivers" as Provider, and "mytest" in the tab "Connection". Enter Username and Password an klick on "Test Connection". regards, Axel > -----Urspr�ngliche Nachricht----- > Von: Ian Kershaw [mailto:[EMAIL PROTECTED] > Gesendet: Dienstag, 9. Dezember 2003 18:09 > An: [EMAIL PROTECTED] > Betreff: ODBC connection string (Windows 2000) & dbmcli command > > Hi. > > Can anyone provide a Windows 2000 ODBC connection string to > maxDB that works? > > My instance of MaxDB is called "test", > Database System Administrator is "sa", > Database Manager Operator is "dbo" > > but I cannot connect and have little idea what kind of string > to be using. I am happy to use a system DSN if this will help > the situation. > > Regards, > ************************************************************** 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]
