Results 1 to 11 of 11

Thread: Hi!

  1. #1
    Join Date
    Jan 2015
    Posts
    5

    Unanswered: Hi!

    Hi DBFOrums,

    I am going to be using MYSQL (and ODBC) for a project at work and for some personal projects. I look forward to learning more about databases in general, and just wanted to stop by and say "hi".

    Kind Regards,
    Ben David

  2. #2
    Join Date
    Sep 2009
    Location
    San Sebastian, Spain
    Posts
    880
    Hi Ben,

    what programming languages are you going to use? If you are going to use PHP look at using the PDO framework which by changing the data source type the same code can be re-used.
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    http://www.it-iss.com
    Follow me on Twitter

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I read this question as using MySQL via ODBC. I agree that using PDO is a good idea if ben.david is using PHP and also wants to be able to easily switch between database engines/servers/etc.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  4. #4
    Join Date
    Jan 2015
    Posts
    5
    Thank you both for the responses Pat and itiss. I'm going to check out that PDO right now.

    Kind Regards,
    Ben David

  5. #5
    Join Date
    Jan 2015
    Posts
    5
    I'm not seeing any SQL Anywhere drivers in PDO:

    Would they be necessary to connection to a SQL Anywhere database? I just found out the database I am going to be connecting to is a SQL Anywhere 10 database with the ODBC connector.

    Cheers,
    Ben David

  6. #6
    Join Date
    Sep 2009
    Location
    San Sebastian, Spain
    Posts
    880
    SAP SQL Anywhere was formerly owned by Sybase. Sybase and Microsoft co-operated a long time ago to create MS SQL Server. The underlying engine is the same for SQL Server as it is for SQL Anywhere. In theory this should work so I would try this and see if it works and let us know?

    Alternatively there is also http://pecl.php.net/package/PDO_SQLANYWHERE/
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    http://www.it-iss.com
    Follow me on Twitter

  7. #7
    Join Date
    Jan 2015
    Posts
    5
    Hi It-Iss,

    I didn't know that the technology is based on SQL server - that's really helpful information, thank you. It's going to take me a bit of time before I try it - if I do - I'm still learning quite a bit. Being new to the database landscape can be a bit confusing. We have this SQL Anywhere database at work we want to connect to and work with either in MYSQL, phpMyAdmin, or the equivalents as that is where our skill-set lies, but it's a pretty big rabbit hole!

  8. #8
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Strictly speaking its t'other way round. SQL Server is based on Sybase's technology, although it has moved quite a bit since the origInal agreement.

    ...what me nit picking.....
    ...never
    I'd rather be riding on the Tiger 800 or the Norton

  9. #9
    Join Date
    Sep 2009
    Location
    San Sebastian, Spain
    Posts
    880
    You can also use bcp to extract the data from the SQL Anywhere database and then upload using LOAD DATA INFILE on MySQL to load this into the database.
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    http://www.it-iss.com
    Follow me on Twitter

  10. #10
    Join Date
    Nov 2003
    Posts
    2,933
    Provided Answers: 12
    Quote Originally Posted by it-iss.com View Post
    SAP SQL Anywhere was formerly owned by Sybase. Sybase and Microsoft co-operated a long time ago to create MS SQL Server. The underlying engine is the same for SQL Server as it is for SQL Anywhere.
    That's not true.
    SQL Anywhere evolved out of a product called WatcomSQL (http://en.wikipedia.org/wiki/Watcom_SQL). It was initially bundled with PowerBuilder (a RAD tool aimed for client/server programming). After PowerSoft was acquired by Sybase, WatcomSQL was renamed to SQL Anywhere (http://en.wikipedia.org/wiki/SQL_Anywhere#History)
    Unless SQL Anywhere was completely rewritten from scratch since then, it does not share any code with the actual SQL Server Enterprise (or Microsoft SQL Server).

    WatcomSQL was actually pretty amazing: a full blown relational database server including a procedural language that fit on a single 1.44MB floppy disk - back in the 90s!
    Last edited by shammat; 02-08-15 at 15:42.
    I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags: http://www.dbforums.com/misc.php?do=bbcode#code

    Tips for good questions:

    http://tkyte.blogspot.de/2005/06/how...questions.html
    http://wiki.postgresql.org/wiki/SlowQueryQuestions
    http://catb.org/esr/faqs/smart-questions.html

  11. #11
    Join Date
    Sep 2009
    Location
    San Sebastian, Spain
    Posts
    880
    Hi Shammat, I stand corrected!! I had been under the impression that Sybase had just rebranded their server to SQL Anywhere but you are correct it is based on WatcomSQL.
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    http://www.it-iss.com
    Follow me on Twitter

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •