The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
Setup of the Library on the network
Posted: 10 Oct 06 8:01 PM
|
fiogf49gjkf0d I'm trying to setup the Library for our Network users but have had no success.
Here's the situation. We have no remotes, just single office. Want to be able to have central file repository where network user can access docs, URL's, templates etc from.
I have tried setting the paths etc in Administrator and when I load something into the library it only appears on my C: drive and not the network drive I have said the library is in. I specified the paths as UNC as well (\\server\directory\).
DO you need to run a SYNC server even though we have no remote databases to use the library? Whats the trick?
Anyone actually set it up correctly??
Thanks in advance. |
|
|
|
Re: Setup of the Library on the network
Posted: 11 Oct 06 8:09 AM
|
fiogf49gjkf0d I can't give you specifics on how to setup the library but I don't recall it being too difficult (it was a few years ago). But I know you do NOT need the sync server at all for the library. It just ends up being a file folder on your file server. It must be a shared folder and have sufficient permissions for saleslogix to save files there. |
|
|
|
Re: Setup of the Library on the network
Posted: 11 Oct 06 10:39 AM
|
fiogf49gjkf0d Hi Marc,
No, you do not need Sync Server running. You need to go into the Admin Library and "connect" the files to the SLX Library.
WGAdmin or Administrator
View | Library
Right click on Right hand pain
Add file
Browse, etc.
OR Add URL and follow the bouncing ball.
It is kind of a tedious pain - SLX is not File 'aware' until you give it specifics. It's just a browse and click sort of deal, but you have to do it for each file/URL. 
Carla |
|
|
|
Re: Setup of the Library on the network
Posted: 11 Oct 06 1:43 PM
|
fiogf49gjkf0d The Library defaults to C:\Documents and Settings\All Users\Application Data\SalesLogix\Library. This is the same exact location of the remote library, so it kind of makes sense.
I found this out in a virtual machine session where I forgot to connect the network (due to the cable being unplugged). It couldn't access the logging path so it proceeded to create files in the default location.
What this tells me is that if you are using the default blank database which is configured for \Library and \Documents, you really don't need to change anything for it to work. Both locations will default to Documents and Settings\All Users\Application Data\SalesLogix\ with or without a sync server configured. |
|
|
|
Re: Setup of the Library on the network
Posted: 11 Oct 06 6:26 PM
|
fiogf49gjkf0d Ok...have done that but I think part of the problem is that after you select the network share for the files to live in in WGAdmin and exit WGAdmin. The next time you go back in the paths are listed but if you click on the folder icon to select the path (it should go to the path listed right?) but it doesn't.
I had this problem ages ago in V4 and spent ages talking to the SLX techies about it. We couldn't resolve it so we gave up on it. Now though the company is ready to utilise it so it needs to be setup.
The file server is Windows 2003, the clients are all WinXP and the SQL server is SQL 2005. The path is a network share and all SLX users have rights to access it.
How does the SQL machine access this share? Is that the problem? Does it even need access or is the database just storing path links to these documents?
Do they need to be physically in this directory when I add them in using WGAdmin? Or can they be anywhere and in the "Add File" under the library section of WGAdmin, does it physically copy the file into the library as specified by they path??
Thanks again |
|
|
|
Re: Setup of the Library on the network
Posted: 11 Oct 06 6:50 PM
|
fiogf49gjkf0d | Ok...have done that but I think part of the problem is that after you select the network share for the files to live in in WGAdmin and exit WGAdmin. The next time you go back in the paths are listed but if you click on the folder icon to select the path (it should go to the path listed right?) but it doesn't. |
|
OK, If memory serves...
We had put some of our document folder files out on a \\fileserver as well. SLX did not know the difference, but that had to do with the way my networking team set it up. You need to trick the Actual folder into thinking it is on the C:\ Drive. However, this requires distributed file sevices. (So I am told!)
How does the SQL machine access this share? Is that the problem? Does it even need access or is the database just storing path links to these documents?
|
|
I am fairly certain SQL Server is not accessing the file itself. It is my understanding that it is merely holding a pointer to the files. Look at the result set in SQL with the following Select statement.
select L2.DirName, L2.FullPath, L1.* from Librarydocs L1
join LibraryDirs L2 on L1.DirID = L2.DirID
Do they need to be physically in this directory when I add them in using WGAdmin? |
|
Yes. I would suggest using browse just to make extra sure. (Tedium!)
Or can they be anywhere and in the "Add File" under the library section of WGAdmin, does it physically copy the file into the library as specified by they path??
|
|
Nope. It just takes the pointers. Also, once you create these pointers in the SLX Library, you can not move the files or the links won't work. They behave basically like hyperlinks do.
Good Luck!
Carla
|
|
|
|
Re: Setup of the Library on the network
Posted: 18 Oct 06 12:07 AM
|
fiogf49gjkf0d I noticed this error in the Event Viewer when trying to setup the path to the library.
Source : odbcdrv_open_cursor
Description : Could not execute SQL statement.
OLE DB Provider specific error: The statement has been terminated.
Cannot insert the value NULL into column 'FILEID', table 'SalesLogix.sysdba.LIBRARYDOCS'; column does not allow nulls. INSERT fails.
SQL: INSERT INTO "LIBRARYDOCS" ("REVISIONDATE","CREATEDATE","EXPIREDATE") VALUES (?,?,?)
SQL : INSERT INTO "LIBRARYDOCS" ("REVISIONDATE","CREATEDATE","EXPIREDATE") VALUES (?,?,?)
And still the records do not seem to want to update to show the UNC path to the library. I have tried manually updating the records but it makes no difference. Adding thing to the library simply copies them to c:\D&S\Sync\library directory.........
The share and permissions are set correctly. I'm on 6.1 with SP3. We have 6.2 but have not upgraded as yet.
Thanks |
|
|
|
Re: Setup of the Library on the network
Posted: 18 Oct 06 10:58 AM
|
fiogf49gjkf0d Oh my! It's not taking anything in! I hate to do this to you, but... I think you are going to have to call SLX support unless someone else has seen this. 
Carla |
|
|
| |
| |
| |
|