Tampilkan postingan dengan label backup restore. Tampilkan semua postingan
Tampilkan postingan dengan label backup restore. Tampilkan semua postingan

Trying to connect Excel 2013 with Oracle - ORA-12154

I am trying to connect MS Excel into Oracle through Data Source ODBC
and im getting error ORA-12154

When I try to connect using ODBC it works find but
when I try to connect using TNS within Excel I get the error:
Message=ORA-12154
"could not resolve the connect identifier"

how to solve it??

here it's

To clarify Hambone's response, to connect Excel to Oracle via Oracle client driver without using TNS Names:

    1.Go to Control Panel > Administrative Tools > ODBC Data Sources
    2.Go to File DSN tab
    3.Choose Oracle driver (e.g. Oracle11gr1)
    4.Provide a name for the new data source (any name)
    5.When prompted for Service Name, enter host:port/servicename e.g. db123:1521/service123


How to Backup & Restore Blog Posts Using Blogger Import/Export Feature




Blogger has an awesome feature to download and save blog posts on your computer. Of course, you can later restore the posts as well. Additionally, you can also move your posts to some other blogging platform using the export feature or to some other Blogger blog. I'd highly recommend to regularly backup your posts. Check out the instructions to see how to do it.

1- Export or Backup Blog Posts to Your Computer


1. Chose Settings from the list of options. You can press the drop down arrow button to see more options.
2. In the Settings section, click Other from the left menu.
3. You'll see 3 options in Blog Tools. Click Export blog. A window will open where you'd have to click the Download Blog button.
4. An .XML file will be downloaded to your computer. Make sure to give it a proper name and keep it safe. This file will be used to restore your posts later.

2- Import or Restore Blog Posts From Your Computer


1. Chose Settings from the list of options. You can press the drop down arrow button to see more options.
2. In the Settings section, click Other from the left menu.
3. You'll see 3 options in Blog Tools. Click Import blog. A window will open where you'd have to browse the file on your computer & click the Import Blog button.
4. If you're importing posts from some other blog then make sure that Automatically publish all imported posts is not checked.
5Now your posts have been imported or restored.