To integrate the C/S structure of the ERP system reports in the project, I have to find a way to use BDC. BDC is an esoteric part of moss2007. I have never worked hard to study its usage in detail before. This is not the end of the article!
First, I found a BDC generate tool on the Internet. I found a BDC Mata man. After a lot of effort, I finally got down. The development version cannot connect to Oracle, let me see what the BDC file of the Oracle database cannot do! Depressing! Later I found that my sdk1.2 version already contains an editor. I was so excited that I had to install it quickly. As a result, I had a wrong Installation File (directly install it using the installation file under the editor ), an error is always reported. The more urgent the error is! I thought Microsoft made something unusable! Later, I finally found that there was a setup in the folder at the upper level, so the installation knew that this thing actually needed a database! Completely dizzy!
After installation, I immediately went to test the connection to the Oracle database, but found that the Oracle client needs to be installed locally. Otherwise, there is no oracle driver! After the driver is installed, the connection string of Oracle is copied, and the database name is modified, I thought everything would be fine. Now I can immediately create the BDC file of the Oracle database, A window is displayed. error: the unsupported keyword "provider" is displayed. This will completely fall down!
I asked a friend in the group to tell me how to change the connection string. One day later, I looked at it carefully and thought it was still a problem to choose the data source driver. Then I connected Oracle with owc on the machine and created a perspective. This indicates the connection string. Take a closer look at the connection string in owc, which is very different from the description file in the BDC Editor, that is, the provider, which is not in the example. So I copied the connection string in owc directly. Guess what? Done! Connected!
Conclusion! Do not be intimidated by difficulties, or blindly believe it. If you have more brains and hands-on skills, the chances of success will naturally increase! Of course, you cannot be overly confident! Recently, I often think that Microsoft has bugs, so I often suspect that! Then I will share my discussions on what I think is a bug.
