Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by zephyrhex

  1. zephyrhex

    Date View Web Part : error

    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...
  2. zephyrhex

    Sharepoint : Configuring Database Connection

    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...
  3. zephyrhex

    Sharepoint : Configuring Database Connection

    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...
  4. zephyrhex

    Date View Web Part : error

    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...
  5. zephyrhex

    Getting Sharepoint to Trust OLEDB - Access 2003 DB

    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
  6. zephyrhex

    Sharepoint : Configuring Database Connection

    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...
  7. zephyrhex

    Getting Sharepoint to Trust OLEDB - Access 2003 DB

    Apparently the only OLEDB providers Sharepoint trusts by default are the SQL providers...
  8. zephyrhex

    Sharepoint : Configuring Database Connection

    thanks for your help. i will look at that link and post back the results
  9. zephyrhex

    Sharepoint : Configuring Database Connection

    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...
  10. zephyrhex

    Sharepoint : Configuring Database Connection

    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...
  11. zephyrhex

    Sharepoint : Configuring Database Connection

    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...
  12. zephyrhex

    Sharepoint : Configuring Database Connection

    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...
  13. zephyrhex

    Sharepoint : Configuring Database Connection

    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...
  14. zephyrhex

    Sharepoint : Configuring Database Connection

    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
  15. zephyrhex

    Sharepoint : Configuring Database Connection

    also, i have Sharepoint Designer installed on a computer other than the one hosting the WSS site. is this causing the problem?
See more

Part and Inventory Search

Back
Top