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

[Auer, Wolfgang]

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