Link to home
Start Free TrialLog in
Avatar of Minesh Shah
Minesh ShahFlag for India

asked on

search sql 2005 db from moss 2007 farm

Dear Friends,

Idea is to search a sql 2005 database from intranet based moss 2007 farm,
this sql 2005 database is sitting inside the network and is hosted on win 2003 server.
(this is one of the databases that is hosted on some server).

kindly advise.
 
Avatar of Kobe_Lenjou
Kobe_Lenjou
Flag of Belgium image

And what exacly is your problem?
Avatar of Minesh Shah

ASKER

there is no problem, i want to drag it!
idea is to search a database, from sharpoint search, which resides in network but out of the farm.

ANY assistane would be highly appriciated.
to search content of various data inside the sql database
SOLUTION
Avatar of Kobe_Lenjou
Kobe_Lenjou
Flag of Belgium image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
exactly.
One way to do it might be to create BDC (Business Data Catalogs), then create Search Scopes based on the BDC(s) you created.

If you are looking for lookups within an InfoPath Form then you can open a direct connection (OLEDB/ODBC) from within the Form to any MSSQL Server to resolve a specific field.

J.
thank you so much friends,
i was just wondering if there are any good links to strat up to search non-sharepoint sql 2005 database from moss 2007 search.
Do you know already which fields you are going to search or do you want some kind of free-hand SQL Tool or ManagementStudio Interface within SharePoint?

J.
yes i know the fields.
Then all you need to do is to create a BDC, then create a Search Scope on that BDC (basically indexing it) which would allow searching it like any other indexed data.

J.
could you please locate me to start with create a BDC....
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ok