Win95 problem - Miguel Angel Solórzano - com.mysql.lists.bugs

3 messages in com.mysql.lists.bugsWin95 problem

From	Sent On	Attachments
Tom Brown	08 Mar 2001 11:50
Michael Widenius	08 Mar 2001 12:21
Miguel Angel Solórzano	08 Mar 2001 16:21

Subject:	Win95 problem
From:	Miguel Angel Solórzano (mig...@mysql.com)
Date:	03/08/2001 04:21:28 PM
List:	com.mysql.lists.bugs

At 22:22 08/03/2001 +0200, Michael Widenius wrote: Hi! When you have the ODBC core already installed, the best work around is to use a script or batch file to install the MyODBC driver without the use of the setup program. The script only does the copy of the myodbc.dll at system directory and the registry entries. Below you see, a batch file sent by Jim Michaels for us.

Notes about the batch file:

- Assume that the Win Directory variable is Windows and the Win System variable is \Windows|System You should modify this values for a WinNT OS or when these variables are different: - The myodbc.dll should be the right one(Win9x or WinNT\Win2k)

rem -----Author: Jim Michaels rem -----copy the drivers where all good little ODBC drivers go copy myodbc.dll C:\WINDOWS\SYSTEM if errorlevel 1 goto bye copy myodbcd.dll C:\WINDOWS\SYSTEM if errorlevel 1 goto bye rem ----create a .REG file to make registry entries echo REGEDIT4>myodbc.reg echo.>>myodbc.reg echo [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\MySQL]>>myodbc.reg echo "APILevel"="2">>myodbc.reg echo "ConnectFunctions"="YYN">>myodbc.reg echo "Driver"="C:\\WINDOWS\\SYSTEM\\myodbc.dll">>myodbc.reg echo "DriverODBCVer"="02.50">>myodbc.reg echo "FileExtns"="*.txt">>myodbc.reg echo "FileUsage"="0">>myodbc.reg echo "Setup"="C:\\WINDOWS\\SYSTEM\\myodbc.dll">>myodbc.reg echo "SQLLevel"="1">>myodbc.reg echo.>>myodbc.reg echo [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBCDrivers]>>myodbc.reg echo "MySQL"="Installed">>myodbc.reg echo.>>myodbc.reg rem -----install the registry entries by executing the .REG file start /wait myodbc.reg rem ----clean up after we are done installing del myodbc.reg :bye

Regards, Miguel

Hi!

"by" == by way of John Calder <john@pixieware com> <Tom> writes:

by> This question has come up before. This message is probably the most detailed by> and serious example I have seen so I am passing it on. by> =========================================================================

by> Hello,

by> I'm a systems software analyst in county government here in North Carolina. by> I installed Red Hat Linux and MySQL on an HP Netserver, installed by> MyODBC on my Win95 PC, converted an Access database to the MySQL by> server, and did a demonstration for the programmers using MS Access. by> Then I sent the (Visual Basic) programmers back to their offices with a copy by> of MyODBC.

by> The programmer-in-charge went to install the MyODBC drivers (setup.exe) by> and got the following error message: by> "An error occurred while copying "C:\WIN95\SYSTEM\CTL3D32.DLL. by> Restart Windows and try installing again (before running any applications by> which use ODBC)."

by> Installations on other programmers' PC's failed as well. These programmers by> support multiple other ODBC applications using SQL Server / Winnt and by> Oracle / HP-UX, and they are afraid to fool with MyODBC on their PC's by> anymore. Go figure.

by> Anyhow, I would still like to undertand what is going on here? On my PC, by> CTL3D32.DLL is dated in 1995 and has a version of 2,26,0,0; the by> programmers report having a version dated in 1999 and a version that is by> much, much higher than mine.

by> Any help would be greatly appreciated.

by> Tom Brown by> System Software Analyst by> Forsyth County MIS by> 200 N. Main St. by> Winston-Salem, NC 27101 by> 1.336.727.2597 ext. 3002 by> ---------------------------------------------

The problem is that we are using Microsofts standard ODBC installation tool to install MyODBC. This problem is that it can't handle the case where some application is using ODBC while one installs a new ODBC driver.

The solution in this case is quite easy. Just press 'Ignore' when you get the above error and the resulting installation should work.

The main problem here is that we haven't had time to write our own installation tool for MyODBC but are relying on the tools that Microsoft has provided for us.

Regards, Monty

To request this thread, e-mail bugs...@lists.mysql.com To unsubscribe, e-mail <bugs...@lists.mysql.com>