SAP GUI 7.10 installation guide

Previously I’m using SAP GUI 6.40 on my vista operating system. At the beginning, SAP GUI is running fine, all the t-codes I access are displayed correctly. But in time, maybe after 2 days intensively use of this 6.40 version, I started to experience trouble. The SAP GUI collapse whenever I attempted to run certain t-code (i think it’s the t-codes that I quite often access).

So I search through google how to solve this problem. I found in several forums that other users are experiencing the same problem, and recommended to upgrade to SAP GUI version 7.10 which is dedicated for windows vista. They also told me to download the latest patch for version 7.10 as well.

So, as they said, I downloaded SAP GUI 7.10 from SAPs’ ftp server along with the patch provided, while I’m writing this, the latest patch is patch level 8.

Here are the step by step installation of SAP GUI 7.10:

1. If you don’t have .NET framework installed on your computer. Please install the .NET framework version 2.0 or the latest release. (I use the .NET framework 3.5)
2. Extract the SAP GUI 7.10 zip file on one folder (you can name it whatever you want, example: SAPGUI-710) under the directory C:\Program Files\Windows. If you don’t extract the installer on the previously specified location, you will receive an error message saying: Failed to open/parse setup script. Please check if the script file ’setup/NwSapSetup.xsc’ exists. Though you check that the file referred by the error message is actually exist on folder setup.
3. Then the installation wizard interface will come out. Next all you need to do is follow the installation wizard, it’s pretty easy to follow, you simply just click next.
4. When you finish installing SAP GUI 7.10, now it’s time to execute the patch.
5. Unzip the patch wherever you want.
6. Run the executable patch file.

Finally, you will now have the SAP GUI 7.10 on your computer. I have test this new version several times, and now the SAP GUI doesn’t collapse even though I access a t-codes for many times. I think it runs normally now

oracle: record inserted via sqldevelopers’ query executor is missing

I experience this problem while i was working with sqldeveloper (which downloaded from oracle homepage). I connect to a database, execute some “insert query” (insert into TABLE values……), then sqldeveloper said that all the records are successfully inserted. I check back to the table, refresh the table, and i saw that the records I previously inserted are there. So I assume everything is okay. I close the sqldeveloper (i don’t remember whether I disconnected from the database before I close the sqldeveloper, or not).

As i mentioned on the title, the next time I open the table via the same sqldeveloper, the previous inserted records are gone. I don’t know, maybe it’s because i was using the query executer. But here’s what I do to solve the missing records inserted via sql developers’ query executer:

1. Input query via sqldevelopers’ query executer.
2. Check the table to make sure the records are successfully inserted.
3. If so, then I disconnect from the database.
4. Then reconnect again to the database or exit the sqldeveloper.

It seems to be that the sqldeveloper commit to the database when it’s disconnected from the database. I assume, when the records are claimed to be successfully inserted, sqldeveloper only commit it locally, not directly to the database. So when I close sqldeveloper without disconnecting from database, the records was not yet committed to the actual database.

Well, i don’t know if it’s true, but it sure solve my problem

activate the oracle environment on xampp for windows

The first time we install xampp for windows, by default, the only active database connection is MySQL. Therefore, if user wants to activate connection to oracle database, user needs to set it up first. How to activate/set up oracle database connection in xampp for windows? Here are some things i did to successfully activate oracle connection:

1. To check whether your oracle setting has been activated or not, go to phpinfo, look for string oci8. If string found it indicate that connection to oracle is available, otherwise to activate connection do the following steps:
2. Open all php.ini files in xampp folder (or you can open only the currently used php.ini file by looking at the phpinfo), then make the following necessary changes:
3. Find string extension=php_oci8.dll. You’ll find there’s a semicolon ‘;‘ ahead of the string.
4. Remove the semicolon to activate the oracle extension.
5. Save the php.ini file.
6. Install oracle client. Simply just install it on your computer, there is no settings required. You can download it from this oracle site.
7. Activate or restart xampp.
8. To make sure that connection to oracle database has successfully activated, go to phpinfo. Find string: oci8. If founded, then now xampp can communicate with oracle database.

Works for me

Hello world!

Welcome to WordPress.com. This is your first post. Edit or delete it and start blogging!