Bob Acker writes ----------->
Please see thread copy below.
Wolfgang -- I have not received a reply to your last message re the
proper ODBC
driver to use... even tho the 'improper' driver seems to work. Could
you add
anything to this?
Folks, I appologize in advance for including such a long thread... but
the information
contained therein seems to answer this question...
Panos wrote: ---------------------->
I have installed SAPDB, Rel.7.3, as part of the SAP Web Application
Server (WAS), Rel.6.10. So far, it seems to work fine. I have also =
installed the Web tools package. The database management part of these
tools ('webdbm') works O.K., the SQL part ('websql'), however, leaves me
in the dark. I call up the URL, that it mentioned in the Installation
Guide (http://satellite:85/websql), I enter the proper connection
parameters (Server =3D "satellite", Database =3D "WA1", Username =3D =
"domain", Password =3D "domain"), I click on the "Logon" button and the
browser goes to a "silent" page, where only the "SAPDB" logo is =
displayed (on the upper-right corner of the screen) and, also, the "Web
SQL" title is displayed on the upper-left side of the screen. No =
functionality (menus, fields, buttons, etc.), no nothing!
The very same thing happens when I try to reach "websql" through the
Web Agent Administration tool ("waadmin"), only, in that case, I get a
totally "white" (blank) screen into the browser (no logos - no titles).
Am I doing something wrong? Can somebody, please, hint me to get the
Web-based SQL-studio to work?
Bob Acker replies ------------------>
Panos, I ran into the same problem.
Here is a copy of the thread that describes the problem and solution
that worked for me:
Wolfgang --
Thanks for your reply...
Ok, based on your note I took a look in ODBC Data Source Administrator,
and found the driver you are speaking of SAP Web 7.3 version 7.03.00.00
dated 10/23/2002. I had not configured it as a data source... What
was configured and working as a data source for all the SAPdb front end
tools was the SQLSTUDOODBCDRIVER Version 7.04.03.00 dated 9/23/2002.
Here is what I did:
1. Tested websql in the browser to make sure it was working. It was.
2. Configured the SAP Web 7.3 Driver as a data source.
3. Tested websql in the browser. It did not work. No error was
displayed, but only sap background showed up. No page elements.
4. Removed the SQLSTUDIOODBCDRIVER.
5. Tested websql in the browser again. Still did not work as described
in 3 above.
6. Removed the SAP Web 7.3 Driver as a data source.
7. Added the SQLSTUDIOODBCDRIVER as a data source
8 Tested websql in the browser. IT WORKS.
9. So -- since this is the only way it seems to work for me, I am a
little troubled that you may not support this in future <grin!>.
This may be contributing to the issue:
1. Although you can name the data source in the ODBC administrator,
none
of the SAP tools ask for the name of the data source -- they ask for
the
name of the database.
2. Therefore if you have installed multiple drivers for a given
database
(because your different tools want different drivers), how does the
tool know which driver to use?
3. Suggestions:
a. Make one driver that works with all the tools and works for non SAP
external connections as well or --
b. Make the login for the tool reference the System Data Source Name
rather than the database name -- avoiding confusion as to which data
source a tool should use.
Of course -- I may be missing something here <grin!>...
In the current setup, is the suggested way to install the database and
tools to have multiple drivers (some for one tool set and some for
another)? If so, how does the tool see the correct driver given only a
database rather than a data source login?
I would like to set up the system in a way that will be supported by
SAP in the future... Any suggestions, given my results above?
Best wishes!
Bob Acker
Wolfgang wrote ----->
Hi Bob,
I am surprised that WebSQL works with the ODBC Driver from SQL Studio.
Because WebSQL brings it's own version of the ODBC Driver. There is no
guarantee that this combination will work in the future. The driver
name
that WebSQL uses is SAP DB Web 7.3. I wonder how you managed WebSQL
working with the SQL Studio ODBC Driver? The driver from the setup
odbc73-setup.exe has nothing to do with WebSQL and SQL Studio. It is
just a standalone driver setup.
Regards
Wolfgang
Wolfgang --
Thanks for your reply. I did get the thing to work, but did a complete
re install on a clean machine to do it. One of the problems was
probably using the wrong ODBC driver. I note the ODBC driver that
works is called: SQLSTUDIOODBC Version 7.04.03.00 9/23/2002. This is a
different driver than what downloads on your interfaces page in
odbc73-setup.exe (which is actually a newer driver, but does not seem
to work with websql). It is also a different driver than was sent to me
with the cd dated May 2002. The good news is that it works with all
the front end tools.
I did not find anything in the docs stating that is the one to use (as
opposed to the others)... of course it does install with the SQLStudio
windows tool... and the driver name might be a giveaway (but you dont
find that out until after you do the install).
I have put together detailed clear install instructions (a how I did
it) for the install of the 7.3 database, windows & web tools for Windows
2000, as part of message batch #655 which I posted yesterday. It is
available as a word doc to anyone who asks, and eventually we will
place it on the www.timberpass.com website as a resource...
Best wishes!
Bob Acker
Timberpass Technology Group
Mead, CO
970-535-4228
"Auer, Wolfgang" <[EMAIL PROTECTED]> wrote:
Hi Bob,
the websql setup should have installed and registered an odbc driver
SAP
DB Web 7.4 (or SAP DB Web 7.3).
It seems that on your computer the driver is not registered. Please
Check Start->Settings->Control Panel->Adminisitrative Tools->Data
Sources (Drivers)
or check the two registry pathes
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\SAP DB Web 7.3
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers
If you find that the odbc driver is not installed search for the
program
odbcreg.exe to install the driver.
regards
Wolfgang
-----Original Message-----
From: bob acker [mailto:[EMAIL PROTECTED]]
Sent: Samstag, 30. November 2002 06:55
To: [EMAIL PROTECTED]
Subject: Everything works except odbc connection for WebSql... ?? What
to do?
Dear Sap Folks --
I have made some progress in getting the SAP tools to work against the
TST instance. So far, the following work (Win2k):
SQL Studio
Database Manager
Web DBM
What does not work is WebSQL.
When I try to connect to my data source I get the following:
ODBC-Error: [Microsoft][ODBC Driver Manager] Data source name not
found
and no default driver specified return-code: SQL_ERROR (0)
I am using the same server (localhost), database: TST, user: DBA,
password: DBA for all 4 tools (3 of which work).
Any clue on what to do?
The driver I am using is the current driver from the web site for 7.3
(odbc73-setup.exe) from interfaces odbc driver for win32.
I got WebDBM to work by taking a look at the wa.reg file in the
web/config directory and modifying all registry entries to conform to
my
file structure. This worked for webdbm and for websql (at least it now
displays) but websql will not connect.
Any assistance would be gratefully appreciated!
Best wishes!
Bob Acker
Mead, Colorado, USA
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
