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
-----Original Message-----
From: Bob Acker [mailto:[EMAIL PROTECTED]]
Sent: Dienstag, 3. Dezember 2002 03:41
To: Auer, Wolfgang; [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Everything works except odbc connection for WebSql... ?? What
to do?
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
