RE: Unable to get Frontpage Dataview Catalog to see a Database Connection

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Wei-Dong XU [MSFT] (v-wdxu_at_online.microsoft.com)
Date: 05/20/04


Date: Thu, 20 May 2004 07:21:47 GMT

Hi David,

Have you tried to connect to the Database from UDL file in your client? If not, please have one test following up my steps:
1. create one txt in the desktop or any folder, for example: data.txt
2. change the .txt extension to .udl, save the name, data.udl
3. double click the udl file. The "Data Link Properties" window will pop up
4. click the Provider tab and choose the corresponding data provider, Oracle Provider-> Oracal etc.
5. click the "next>>" button
6. input the database server name and username/password
7. click "Test connection" to test the conneciton.
8. if the connection is ok, please exit the window
9. rename the data.udl to data.txt
10. open the data.txt, you will find the connection string saved in this text (for secure, the password will not be saved).
11. Then in frontpage, you can test to use this connection string to connect the database server in Data view.

Greatly appreciated you tell me the testing result!

Best Regards,
Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.


Quantcast