ODBC for dummies

This topic is empty.

Viewing 6 reply threads

Author

Posts
- February 11, 2003 at 2:10 pm #7680
  
  saudi
  Member
  
  Hi to all that have a heart for an absolute ODBC-newby !
  
  Lets say I have a acces-DB c:/test/an_acces_db.mdb on NT 4.0
  
  and I do not even know what a .dns -file is or should do ,
  
  what do I have to do , in order to get this into a
  
  MySQL database.
  
  Please tell me step by step what to do, to get me away from
  
  exporting to csv and loading with 'LOAD DATA INFILE'
- February 11, 2003 at 5:40 pm #13703
  
  Ritesh
  Member
  
  Quote:
  
  Hi to all that have a heart for an absolute ODBC-newby !
  
  SQLyog was made so that new-bies can take advantage of MySQL.
  
  Go to control panel and search for administrative tools. There will be an option Data Source ( ODBC ). Double click on it.
  
  Go to the System DSN tab. Create a new DSN by clicking on Add… button. In the list you will find all the datasources installed on your system. Select ACCESS.
  
  From ODBC Microsoft Access Setup….select proper options and your DSN will be created.
  
  Hope it helps.
- February 11, 2003 at 10:46 pm #13704
  
  kinjoJake
  Member
  
  Go to control panel and search for administrative tools. There will be an option Data Source ( ODBC ). Double click on it.
  
  I just installed SQLyog, clicked the icon SQLyog. I believe this to be the control panel but i fail to find the administrative tools. Is it hidden?
  
  WinMySQLAdmin 1.4 says it can't find the MyODBC. Know why this is.
- February 12, 2003 at 4:52 am #13705
  
  Ritesh
  Member
  
  Quote:
  
  I just installed SQLyog, clicked the icon SQLyog. I believe this to be the control panel but i fail to find the administrative tools. Is it hidden?
  
  What type of administrative tool you are talking about?
- February 12, 2003 at 5:21 am #13706
  
  saudi
  Member
  
  Hi Ritesh,
  
  everythimg worked fine , this does the same as the wizard ,
  
  but at the end I get this window:
  
  SELECT TABLE(S)
  
  You can choose one or more tables to copy. You can …
  
  But the List is empty (and the .mdb I assigned to the .dsn isn't).
  
  What is wrong ?
- February 12, 2003 at 5:34 am #13707
  
  Ritesh
  Member
  
  Are you sure you have created a correct DSN? Which version of Access you are using.
  
  Will it be possible to send us your .mdb file so that we can work on our side? If so then mail it to [email protected]
- February 13, 2003 at 6:54 am #13708
  
  saudi
  Member
  
  Thank you Ritesh ,
  
  you put me on the right track , my .mdb was not OK !
  
  I don't know why , but it worked with any other access-DB and even
  
  with access I wasn't able to open those tables anymore.
  
  Thanks a lot sqlyog is a great tool
Author

Posts