Re: HELP - Storing Full Text Catalog to Different Location
- From: "John Kane" <jt-kane@xxxxxxxxxxx>
- Date: Thu, 4 Aug 2005 19:32:38 -0700
Dino,
Well, the error message is clear "Access is denied to 'C:\Documents and
Settings\username\MyDocuments', or the path is invalid."
Did you try using sp_fulltext_catalog and create a FT Catalog using the same
path? or perhaps specifically reference 'C:\Program Files\Microsoft SQL
Server\Mssql\Ftdata' enclosed in double quotes? Do the folders "username"
or "MyDocuments" exist?
SQL Server BOL title "sp_fulltext_catalog" for the path states
"[@path =] 'root_directory'
Is the root directory (not the complete physical path) for a create action.
root_directory is nvarchar(100) and has a default value of NULL, which
indicates the use of the default location specified at setup. This is the
Ftdata subdirectory in the Mssql directory; for example, C:\Program
Files\Microsoft SQL Server\Mssql\Ftdata. The specified root directory must
reside on a drive on the same computer, consist of more than just the drive
letter, and cannot be a relative path. Network drives, removable drives,
floppy disks, and UNC paths are not supported. Full-text catalogs must be
created on a local hard drive associated with an instance of Microsoft® SQL
ServerT.
@path is valid only when action is create. For actions other than create
(stop, rebuild, and so on), @path must be NULL or omitted."
Hope that helps!
John
--
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"Dino Buljubasic" <dino@xxxxxxxxxxxxxxxxxxx> wrote in message
news:fs05f1lapksvfr4i0lgot578hubm1te3gj@xxxxxxxxxx
> 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_
.
- References:
- HELP - Storing Full Text Catalog to Different Location
- From: Dino Buljubasic
- HELP - Storing Full Text Catalog to Different Location
- Prev by Date: Re: Server: Msg 7619: Cannot build FTcatalog
- Next by Date: Any Full-Text Guru's - Need help with a query
- Previous by thread: HELP - Storing Full Text Catalog to Different Location
- Next by thread: RE: HELP - Storing Full Text Catalog to Different Location
- Index(es):
Relevant Pages
|
