Derek, I had the same problem. Turned out to be a case-sensitivity issue. Connecting to a SAPDB instance on Linux with the dbmcli I could use lower-case. Connecting with the SQL Studio, I needed an upper-case database name.
Try that out. David. ----- Original Message ----- From: "Derek M. A. Lee-Wo" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, February 11, 2003 10:14 AM Subject: SQLStudio cannot connect, error -709 > I'm trying to use SQLStudio from a Win2000 machine to connect to a two > SAPDB databases. I can connect to one, but I get the following error > when connecting to the other.... > > ODBC-Error:[SAP AG][SQLOD32 DLL][SAP DB]Unable to connect to data > source;-709 CONNECT:(database not running). return-code:SQL_ERROR > (-709) > > The databases are identical, except that one is on WindowsNT and the > other is on AIX. They both have the same database, tables, users, and > passwords. I'm using 7.3.0 Build 029-000-087-809 under WindowsNT and > version 7.3.0 Build 029-000-087-779 under AIX > > I have a Java/JDBC application and I can connect to both databases and > work with them successfully (from the same machine I'm trying to run > SQLStudio) so I know the databases are up and running. > > I can run the DBM GUI and I can connect to and administer both databases. > Same goes for dbmcli...it can connect just fine and I do "sql_execute" > to run SQL commands. > > Can anyone suggest what I can do or where I look to try and figure out > what is going wrong? I did a search of the archives, but the solutions I > found that pertain to this error don't apply to me. > > Derek > -- > Derek M. A. Lee-Wo > Email: (Home) [EMAIL PROTECTED] (Work) [EMAIL PROTECTED] > > "Those who will not risk cannot win" - John Paul Jones > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
