Tag Info

New answers tagged

0

Maybe using different windows users to start different sql instances as another layer of security can be good idea. Also you can put MDF files in the separate directories with different windows users being able to access the directory. And start different named instances with different users that can access required MDFs.


1

You cannot run OS commands in a MySQL CLI nor in MySQL Workbench. Why would you do that (except for trying to hack a machine via an SQL connection)? If you need to run an OS command, open a normal shell window (that still stands). Update: The system command only works on Unix like OSes (http://dev.mysql.com/doc/refman/5.6/en/mysql-commands.html), e.g. Linux ...


1

I did it the easy way of starting a Windows MySQL 5 instance and coping the data files over. I was able to mysqldump to get what I needed.


0

You are going to love this. Just install mysqld as a Windows Service. Ready ? From the Windows DOS shell (ran as Administrator), go to the folder where mysqld.exe is located Run this mysqld --install That's it. You can go to ControlPanel Administrative Tools Service When the Services Window opens, scroll alphabetically can you will see MySQL as a ...


0

You mention you have tried SQL*Plus and Toad; what is your client operating system, Windows? Unix? See NLS_OS_CHARSET Environment Variable that is an environment variable set on your client to a value that your client understands and supports. If you are on Unix, invoke the locale command and see what LANG or LC_ALL is set to; you may need to set ...


1

The chinese characters are decoded correctly with utl_i18n.unescape_reference. In fact they just aren't displayed properly in your query result which might not support those special characters. You can confirm that with this SQL Fiddle. It is the client which is respsonsible to display the characters appropriately. If the client can not display a ...


0

The issue could be because of remote location of Oracle Installer. Copy the installer into location drive and run the installer as Administrator should resolve the issue.


0

I fixed the issue by going into Configure TOAD Options --> Schema Browser --> Data and Grids and there I unchecked Enable FK Lookup



Top 50 recent answers are included