From: Bill Koob Date: March 18 1999 3:15am Subject: ODBC installation and use List-Archive: http://lists.mysql.com/mysql/463 Message-Id: <3.0.5.32.19990317211529.007c1520@minn.net> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" I am running on a local win95 machine not connect to a network until I go on the internet. Server version 3.21.29a-gamma-debug prot ver 10 is the mysql ver The odbc driver is 2.50 ver?? that works for 95 & Nt. You have to change some file when you finish installing in NT as I understand it. I know I am suppose to find and use some program called dump???? but I've already have too much time in this non pay / no compensated quest to stop a complete take over by the evil M****S***. MY COMMENTS ARE TO THE LEFT OF THE INSTRUCTIONS. Per the instructons I was able to find. ODBC with mySQL NOTE: You must have a mySQL database table or tables set up in order to access the database. RESULT Requirements: Windows 95 or NT 4.0 OK 1. Download the ODBC Download myodbc 2.50.xx for Windows95 or NT from here. Ok 2. Unzip the file into a temp directory and run program "setup.exe" Ok 3. From the "Install Drivers" window, choose MySQL. Ok 4. After installing the MySQL ODBC driver, the install program will show the "Data Sources" window. Click "Add." Note: On Windows NT 4.0, you'll get a message saying "This application uses the old version of CTL3D32.DLL..." Just ignore it for the moment. Ok 5. From the "Add Data Source" Window choose MySQL from the list box and click the OK button. xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx HERES WHERE THE PROBLEM BEGINS. 6. Fill out the fields in the DSN setup window. A. You can use any unique identifier for the Windows DNS name and description ANY MEANS WHATEVER I ENTER I enter "MYSQL" B. Enter the name of the "mySQL Database"* I have a database called test at c:\mysql\data\test I enter test C. Enter the server name* I entered 171.0.0.1 as it was the workaround to running the thing on a local machine and not a network I have a file called hosts in the c:\win95 directory with "127.0.0.1 localhost" in it. D. Enter the "user"* koob (previously entered whenever a password was required) E. Enter your password for "password"* bill (previously entered when ever a password was required) F. Enter the port number* left blank as default will be entered per some read doc. G. Click on OK. "it states install is successful." *Get these values from your server administrator or provider technical support. This will setup a MySQL DSN on your local PC. You may start using the MySQL Data Source in your PC programs. How to set up MS Access 97 to access your mySQL COMMENTS database via ODBC ok 1. Open MS Access and create a new database. ok 2. From the file menu, choose File and then Get External Data and then Link Tables. ok 3. From "Link" window that comes up, choose ODBC Databases. Here I get the same 4. From the "Select Data Source" Window, choose menu I got when I the DSN name you've setup for your online mySQL installed the odbc database. If you haven't already done so, see driver instructions here. Click the OK button. I select a the db 5. From the "Link Tables" window, select the table called test in you want to attach and click the OK button. c:\mysql\data\test 6. ODBC could prompt you for the primary key Microsoft insists I column in that table, if it can't find it. use a different dir. Specify one and that's it! The online mySQL (basically it fails table is now attached to your local access here) database: 7. You may open the table, update, inset or delete records. To attach all database tables, follow the above steps for each table in your database. FOLLOWING THE ABOVE SEVEN STEPS USING THE SAME DATA AS IN THE ODBC INSTALLATION LEADS ME TO A DEAD END - where after entering all the same data as entered in the installation in the same installation type window it just goes away. I think it has something to do with the server name unless i'm suppose to enter "mysql" there. The only other thing I can think of is I do not have a datetime in my table - that surely wouldn't cause it to fail without use of the table would it? ------------------------------------------------------------------------ Have a great Hunt wkoob@stripped WetDog owned by Wet Dogs http://www1.minn.net/~wkoob/ My personality is something like this Mit der dumheit nicht gotter selbst vergeben.