Re: Data Source issues
From: Ken Snell [MVP] (kthsneisllis9_at_ncoomcastt.renaetl)
Date: 10/10/04
- Next message: Nick: "Re: No fields listed on my form in form view"
- Previous message: Philippe: "Data Source issues"
- In reply to: Philippe: "Data Source issues"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 10 Oct 2004 16:45:25 -0400
Try microsoft.public access.dataaccess.pages newsgroup!
--
Ken Snell
<MS ACCESS MVP>
"Philippe" <anonymous@discussions.microsoft.com> wrote in message
news:241e01c4af01$8729d3f0$a301280a@phx.gbl...
> Hi,
> Since i cannot find a section for 'data access pages',
> here is my post here. My issue is so weird I am sure it
> is a trivial one, but I am completely stuck:
>
> I have a problem with data access pages (DAP) data
> sources. The generated code in my DAP's reads (portion
> of):
>
> <a:ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;User
> ID=Admin;Data Source=C:\myfolder\mydb.mdb;Mode=Share Deny
> None;
> etc...
>
> A preliminary comment: I have read extensively web pages
> from MS and other sources, and everywhere it is said to
> use a URN or a URL for the data source statement. But i
> am still hitting the wall: every time I try to indicate a
> different data source than the original data source (my
> db on my c:\) in the Properties of the DAP, my access
> 2002 (office XP develper) crashes, and tells me that
> nothing can be located anymore, that save mode is
> disabled, and that i should re install office xp
> developer... note: I trust i am current with all SP's
> including WXP Pro SP's. Now here are the tests I have
> performed:
>
> 1. when I run my DAP on my development pc, the mdb
> indicated in the 'data source=' statement is of course
> found and the data access page yields its results (it is
> a report saved as a data access page)...
>
> 2. when I push my DAP on my staging web server, and
> access the data access page from my pc over the Internet,
> of course the mdb found is the one from my C: drive too
> on my development pc...
>
> 3. since I read the litterature, and since my development
> machine would crash every time i try a new data source,
> and since I am a stubborn and persistent kid, i then
> edited the DAP on the staging web wever using notepad,
> and tried various combinations: if for instance i
> indicate data source=\\myserver\myshare\mydb.mdb (on the
> staging server), and i open the DAP from the server's
> browser itself (I have my own hardware and DNS and IIS
> server running MS windows server 2003, so tecnically i
> know i have the latest mdac, etc...), then it works
> (because the data access page is being opened directly on
> that machine, as opposed to being opened via the
> Internet, so the server's C: and other drives are being
> seen). As well of course a statement such as 'data
> source=E:\myfolder\mydb.mdb' (where E: is a drive
> associated with the stating web server), works from the
> server's browser. But does not work when i come in from
> the Internet on my pc.
>
> I tried http://www.mydomain.com/thisfolder/mydb.mdb, as
> well as numerous other combinations that all kind of make
> sense to me, and then no luck... the error message 'data
> provider could not be intialized', is followed by 'not a
> valid file name'.
>
> So either i am very tired, or very thick, but i am at a
> loss to understand why this is happening. If i could get
> the proper syntax to input in the 'data source='
> statement then i guess my problem is solved?
>
> Thank you very much for your help.
>
>
- Next message: Nick: "Re: No fields listed on my form in form view"
- Previous message: Philippe: "Data Source issues"
- In reply to: Philippe: "Data Source issues"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
Loading
