Thanks to the input from David and Markus, I managed to get it to work. I had to specify the database in all uppercase (My database name was a mixture of upper and lower case letters)
Derek On Tue, 11 Feb 2003 11:55:51 -0800, "David Griffiths" <[EMAIL PROTECTED]> said: > 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 > > > -- 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
