136407Re: dbext and sqlplus without tnsnames
- Feb 26 5:17 PM--On Tue, Feb 26, 2013 at 6:32 PM, Vitor Eiji Justus Sakaguti <vitoreiji0@...> wrote:
I'm trying to setup a dbext environment on a Windows machine to
connect to a remote Oracle database.
However, I don't have write access to tnsnames.ora and cannot add the
proper entry for the database to which I need to connect.
I tried several different forms of profile setting, according to the
very examples in the help fileTwo suggestions:1. :DBSetOption display_cmd_line=12. Try each profile setting.- Show us the profile string you used.- Show us the sqlplus cmd line generated.- Show us the error.
but whatever I did, when I tried to
execute somthing I saw that a cmd.exe was run with something like
cmd.exe /c sqlplus -S "myUser/myPass@myServiceName"
@C:\Users\More\Path\dbext.sql > C:\You\Get\The\idea\sdkfg.tmp 2>&1The :DBSetOption above will show you this cmd line in the normal dbext output buffer.From the dbext.txt I suspect the example that you want to use for your profile is:let g:dbext_default_profile_ORA_Extended = 'type=ORA:user=scott:passwd=tiger:srvname=(description=(address=(protocol=TCP)(host=localhost)(port=1521))(connect_data=(server=dedicated)(service_name=10gR2)))'Also, if you continue have problems can you run::DBGetOptionAnd post it's contents with your other output from above.David
You received this message from the "vim_use" maillist.
Do not top-post! Type your reply below the text you are replying to.
For more information, visit http://www.vim.org/maillist.php
You received this message because you are subscribed to the Google Groups "vim_use" group.
To unsubscribe from this group and stop receiving emails from it, send an email to vim_use+unsubscribe@....
For more options, visit https://groups.google.com/groups/opt_out.
- << Previous post in topic Next post in topic >>