RE: HELP - Storing Full Text Catalog to Different Location

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

Are you utilizing MSDE or SQL Server Express? Full-Text is not installed or
supported on either.

"Dino Buljubasic" wrote:

> Hi,
>
> I am building a database install aplication that among all other
> stuff, creates and populates full-text catalogs for my database.
>
> All this is done in VB.net and SQL Server 2003
>
> My application works fine, here is the come sample:
>
> oSQLServer = CreateObject("SQLDMO.SQLServer")
> oSQLServer.connect(strServer, strUserID, strPassword)
>
> ' enable full-text indexing for provided database
> oSQLServer.Databases(strDBName).EnableFullTextCatalogs()
>
> ' create full text catalog and add it to the collection
> Dim strFullTextCatalogName As String
>
> strFullTextCatalogName = strCatalogPrefix & "_documenttitle"
> oFullTextCatalog = CreateObject("SQLDMO.FullTextCatalog")
> oFullTextCatalog.Name = strFullTextCatalogName 'name
> oFullTextCatalog.RootPath = strCatalogPath 'location
>
>
> ' create full-text catalog on the server and add it to
> ' the collection of full-text catalogs
>
> oSQLServer.databases(strDBName).fulltextcatalogs.add(oFullTextCatalog)
>
> However, I get an System.Runtime.InteropServices.COMException
> exception with additional information as:
>
> Additional information:[Microsoft][ODBC SQL Server Driver][SQL
> Server]Access is denied to 'C:\Documents and
> Settings\username\MyDocuments', or the path is invalid. Full-text
> search was not installed properly.
>
> The path to which access is denied is the value of my variable
> strCatalogPath that I assign to my full-text catalog RootPath
> property. (see code sample above)
>
> How can I fix this error. Please help.
>
> Any help will be appreciated,
> _dino_
>
.

Relevant Pages

  • RE: Installing SP4 on SQL 2000
    ... SQL Server 2000 SP3a, x86 ... It seems like there is issue on your install. ... MCITP: Database Administrator ... "David G" wrote: ...
    (microsoft.public.sqlserver.setup)
  • RE: Installing SP4 on SQL 2000
    ... As you said this is a fresh install, so it should not be an issue. ... If you are installing are installing a fresh version of SQL Server 2000, ... MCITP: Database Administrator ... "David G" wrote: ...
    (microsoft.public.sqlserver.setup)
  • Re: Why do I need to restart the SQL service?
    ... > I use Wise Installation utility to install MSDE 2000A. ... what I do within the app is: ... Check to see if the database exists. ... > SQL Server does not exist or access denied. ...
    (microsoft.public.sqlserver.msde)
  • Re: SQL SERVER 2008 Express + SP1
    ... Again there are three service pack setups which are provided by Microsoft. ... Are u sure you are using correct version for your install? ... DB Dev SQL Server 2005 ... Script level upgrade for database 'master' failed because upgrade step ...
    (microsoft.public.sqlserver.setup)
  • Re: sa password was inadvertently changed. With a kicker...
    ... Call the vendor of the new software product, and ask them what the> install script sets the SA password to when installing the product. ... Put the database files back where they should> be, ... >> I have a SQL Server 7 Standard edition server running in a ...
    (microsoft.public.sqlserver.security)