Minesh Shah
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.
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.
And what exacly is your problem?
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.
idea is to search a database, from sharpoint search, which resides in network but out of the farm.
ANY assistane would be highly appriciated.
ASKER
to search content of various data inside the sql database
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
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.
ASKER
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.
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.
J.
ASKER
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.
J.
ASKER
could you please locate me to start with create a BDC....
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
ok