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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
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 09:00 PM |