RE: Unable to get Frontpage Dataview Catalog to see a Database Connection
From: Wei-Dong XU [MSFT] (v-wdxu_at_online.microsoft.com)
Date: 05/20/04
- Next message: Peter Holpar: "QueryProvider constructor causes NullReferenceException"
- Previous message: Wei-Dong XU [MSFT]: "RE: Substituting new Context.User.Identity for Authentication in SPS 2003"
- In reply to: David McKenzie: "Unable to get Frontpage Dataview Catalog to see a Database Connection"
- Next in thread: David McKenzie: "Re: Unable to get Frontpage Dataview Catalog to see a Database Connection"
- Reply: David McKenzie: "Re: Unable to get Frontpage Dataview Catalog to see a Database Connection"
- Messages sorted by: [ date ] [ thread ]
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.
- Next message: Peter Holpar: "QueryProvider constructor causes NullReferenceException"
- Previous message: Wei-Dong XU [MSFT]: "RE: Substituting new Context.User.Identity for Authentication in SPS 2003"
- In reply to: David McKenzie: "Unable to get Frontpage Dataview Catalog to see a Database Connection"
- Next in thread: David McKenzie: "Re: Unable to get Frontpage Dataview Catalog to see a Database Connection"
- Reply: David McKenzie: "Re: Unable to get Frontpage Dataview Catalog to see a Database Connection"
- Messages sorted by: [ date ] [ thread ]