A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Data Source issues. ??data.access.pages



 
 
Thread Tools Display Modes
  #1  
Old October 11th, 2004, 12:21 AM
Phil
external usenet poster
 
Posts: n/a
Default Data Source issues. ??data.access.pages

This thread does not seem to exist???
"The URL you provided is invalid. Please correct it and
try again."


Subject: Data Source issues
From: "Ken Snell [MVP]"
Sent: 10/10/2004
1:45:25 PM

Try microsoft.public access.dataaccess.pages newsgroup!
--

Ken Snell
MS ACCESS MVP

"Philippe" wrote in
message
...
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:ConnectionStringProvider=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.





  #2  
Old October 11th, 2004, 12:59 AM
Phil - response to myself
external usenet poster
 
Posts: n/a
Default

ok, i just found out dap's are obsolete and read the three (actually more) kb
articles about how one can configure rds and should be using asp.net instead
so i understand this is a lost cause.
so i'll just trash the idea of using dap's and will go on with my life on
another route and another technology (and another db than A2k)... thanks Ken
for your reply anyway.

"Phil" wrote:

This thread does not seem to exist???
"The URL you provided is invalid. Please correct it and
try again."


Subject: Data Source issues
From: "Ken Snell [MVP]"
Sent: 10/10/2004
1:45:25 PM

Try microsoft.public access.dataaccess.pages newsgroup!
--

Ken Snell
MS ACCESS MVP

"Philippe" wrote in
message
...
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:ConnectionStringProvider=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.






  #3  
Old October 11th, 2004, 02:42 AM
Ken Snell [MVP]
external usenet poster
 
Posts: n/a
Default

Drat...I left out a .

microsoft.public.access.dataaccess.pages

--

Ken Snell
MS ACCESS MVP


"Phil - response to myself" Phil - response to
wrote in message
...
ok, i just found out dap's are obsolete and read the three (actually more)

kb
articles about how one can configure rds and should be using asp.net

instead
so i understand this is a lost cause.
so i'll just trash the idea of using dap's and will go on with my life on
another route and another technology (and another db than A2k)... thanks

Ken
for your reply anyway.

"Phil" wrote:

This thread does not seem to exist???
"The URL you provided is invalid. Please correct it and
try again."


Subject: Data Source issues
From: "Ken Snell [MVP]"
Sent: 10/10/2004
1:45:25 PM

Try microsoft.public access.dataaccess.pages newsgroup!
--

Ken Snell
MS ACCESS MVP

"Philippe" wrote in
message
...
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:ConnectionStringProvider=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.








 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Is this possible with Excel Chart? q582gmzhi Charts and Charting 1 September 8th, 2004 03:33 AM
data labels not linked to data source viveleroi0 Charts and Charting 8 August 19th, 2004 02:12 AM
Charts which automatically adapt to variable source data length Excel Engineer Charts and Charting 1 August 15th, 2004 12:47 PM
How to create graphs in a monthly report where the base data can change John Clarke Charts and Charting 3 June 25th, 2004 02:22 AM
Relink to new data source Syd Worksheet Functions 0 December 15th, 2003 10:00 PM


All times are GMT +1. The time now is 07:38 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.