FW: Everything works except odbc connection for WebSql... ?? What to do?

[Auer, Wolfgang]

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):

1. SQL Studio
2. Database Manager
3. 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

---

Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now