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
