Loading ...
Sorry, an error occurred while loading the content.
 

Re: dbext & mysql

Expand Messages
  • David Fishburn
    ... dbext v5 is currently in beta2. The main feature of v5 is a DBI layer, which I have been testing with MySQL. I had already added these samples to the dbext
    Message 1 of 5 , Jul 30, 2007
      On 7/30/07, zzapper <zzapper@...> wrote:
      >
      > Hi
      > (been trying to post this for weeks, no apparent success!)
      >
      > Anyone got a hello world example of setting up dbext with mysql
      > using .vimrc or not

      dbext v5 is currently in beta2.
      The main feature of v5 is a DBI layer, which I have been testing with MySQL.

      I had already added these samples to the dbext documention. Please
      let me know if more are required. Each database can have their
      specific connection settings, I am not a frequent MySQL user. So if
      you find you need additional settings, let me know and I will add it
      to some of these samples.


      7.4 Connection profiles examples
      *dbext-connect-profiles-examples*

      Here are some sample profiles I maintain. These can help when trying to
      setup your own: >
      " SQL Anywhere (Normal, DBI and ODBC)
      let g:dbext_default_profile_cons = 'type=ASA:dsnname=cons'
      let g:dbext_default_profile_ASA_DBI =
      'type=DBI:user=dba:passwd=sql:driver=SQLAnywhere:conn_parms=:driver_parms=AutoCommit=1;PrintError=0'
      let g:dbext_default_profile_ASA_DBI_demo10 =
      'type=DBI:user=dba:passwd=sql:driver=SQLAnywhere:conn_parms=ENG=demo10;DBN=demo:driver_parms=AutoCommit=0'
      let g:dbext_default_profile_ASA_ODBC =
      'type=ODBC:user=dba:passwd=sql:dsnname=SQL Anywhere 10 Demo'

      " Sybase ASE
      let g:dbext_default_profile_ASE =
      'type=ASE:user=sa:passwd=whatever:srvname=my_server:dbname=ml8'

      " IBM DB2
      let g:dbext_default_profile_DB2 =
      'type=DB2:user=db2admin:passwd=whatever:dbname=SSD:bin_path=C:\Programs\IBM\SQLLIB\BIN'
      let g:dbext_default_profile_DB2_cons_1d =
      'type=DB2:user=mlink:passwd=whatever:dbname=db2_2a:host=my_lab_box:port=60000'

      " MySQL
      let g:dbext_default_profile_mysql_local =
      'type=MYSQL:user=root:passwd=whatever:dbname=mysql:extra=-t'
      let g:dbext_default_profile_mysql_local_DBI =
      'type=DBI:user=root:passwd=whatever:driver=mysql:conn_parms=database=mysql;host=localhost'
      let g:dbext_default_profile_mysql_local_ODBC =
      'type=ODBC:user=root:passwd=whatever:dsnname=mysql'

      " Oracle
      let g:dbext_default_profile_ORA =
      'type=ORA:srvname=ffs42ga:user=john:passwd=whatever'

      " Postgress
      let g:dbext_default_profile_PG = 'type=PGSQL:user=postgres'

      " Microsoft SQL Server
      let g:dbext_default_profile_SQLSRV =
      'type=SQLSRV:user=sa:passwd=whatever:host=localhost:replace_title=1'

      " SQLite
      let g:dbext_default_profile_POPFile =
      'type=SQLITE:SQLITE_bin=C:\Programs\POPFile\sqlite.exe:dbname=C:\Programs\POPFile\popfile.db'



      HTH,
      Dave

      --~--~---------~--~----~------------~-------~--~----~
      You received this message from the "vim_use" maillist.
      For more information, visit http://www.vim.org/maillist.php
      -~----------~----~----~----~------~----~------~--~---
    Your message has been successfully submitted and would be delivered to recipients shortly.