just wanted to update this with more info...
it appears that if the database is on the same server as WSS, you can share the folder and other computers can see the data ... but i don't have it working completely yet.
my local computer can view the data only if i am viewing it on the server at...
i think i've figured out when it displays on the local computer and when it does not.
it will display on my local computer if i am also viewing the same page on the server at the same time. if i close the browser on the server, then i can no longer view the data from my local computer. if i...
well, through testing i discovered that the database has to be on the server hosting WSS, but you can share that folder.
i just cant get the permissions or sharing or connection string path right so that people who are not on the server can see the web part data.
it works fine when i view it...
i was finally able to successfully implement the Data View web part to an MS Access database.
it works fine on the server on which WSS is installed. i can view the Access data in sharepoint -- no problem.
but when i try to view the page on another machine, i get:
An error occurred while...
here is the syntax:
stsadm -o setproperty -propertyname data-retrieval-services-oledb-providers -propertyvalue DB2OLEDB;IBMDADB2;MSDAORA;OraOLEDB.Oracle;SQLOLEDB;Microsoft.Jet.OLEDB.4.0
yes, that is the right path.
with a little more google work, i found this:
http://www.wssdemo.com:8080/Pages/mdb.aspx?menu=Articles
following those instructions, i was able to use the Data View web part with Frontpage and establish a custom connection to an MSAccess database.
thanks for your...
no.
and according to this site:
http://www.connectionstrings.com/
i am using the right format for an Access database.
if it were a SQL database, i don't think i'd have to use the Edit String option. i think i could just fill in the server name, etc.
i have verified that the frontpage and...
server error: an error occurred while retrieving the list of Databases from c:\test\test1.mdb: the web server cannot connect to the specified data source because the query may contain errors, the data source may be unavailable or configured improperly, or your Web site is behind a proxy server...
here are some other things i've tried:
move test1.mdb to the server hosting WSS.
try sharepoint designer from local desktop with path to the server:
tried :
c:\test\test1.mdb
\\servername\test\test1.mdb
tried adding a share with full control permissions for everyone to the folder on the...
i tried this and i am still getting the same error.
here is what i did:
on my local desktop, i set up sharing (full control, everyone) on the folder in which the Access database resides.
i then verified that i can access the folder from the server.
on the server hosting WSS, i set up a system...
let me make sure i understand the structure correctly.
i have Sharepoint Designer installed on my desktop computer. that desktop computer is also where i have the Access database located.
in Sharepoint Designer, i am using the Database Connection. i use the Edit Connection String option and...
no, the access database is on my local desktop. the sharepoint site is on the server.
sharepoint designer 2007 is also installed on my local computer.
thanks
i am using Sharepoint Designer 2007
Access 2003
WSS site
i am trying to view data from my Access DB in the sharepoint site. when i go to the Data Source Library, i select Database Connections and try to establish a connection by using the following connection string...
i have resolved this issue
MAS does not like the name FAX on a printer other than WINFAX. so i had to rename the Brother PC-Fax to something that did not include the word "FAX" in it.
then, in MAS, do NOT preview the report. select the fax-printer-which-does-not-include-fax-in-the-name and...
we have a networked brother fax machine. the brother software installs a brother pc-fax printer in "printers and faxes" in MAS, we can send faxes with the brother software by previewing the report and then selecting print. this launches the brother software for faxing. the fax goes through...
i have fixed the problem.
got rid of the subreports.
since my datbase tables were linked based on the product field, i was able to list out all products in all datasources by using the first product field in the line of links between tables. i used that first product field in the group...
crystal 8.5 ODBC to SQL DB
i have added the two databases to the report, and they are linked based on ItemNumber.
for my group definition, i have:
global stringVar itemNum;
itemNum := {IM5_TransactionDetail.ItemNumber} + {IM5_TransactionDetail_1QM3.ItemNumber};
itemNum;
that returns nothing...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.