DEploying data access pages - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Other Forums

MS Access

DEploying data access pages

Author

Topic

alex.k
Starting Member

2 Posts

Posted - 2004-02-03 : 05:00:49

Hi, I have created a few Data Access pages using Access2000.When I run them through the database all is fine, when try to run the pages through IIS Iam getting only the Label of the page but none of the fields or any data, the rest of the page is blank,no errors are shown.
Both the database and the web pages are saved in My local machine in a folder under Inetpub\wwwroot.
I have Windows XP professional with office 2000 and IE 6.00.
I have read the MS article:
http://msdn.microsoft.com/library/en-us/dnacc2k2/html/deploydap.asp?frame=true&_r=1
and as a result have changed a few settings
ie setting UseRemoteProvider=True, created an MSADC virtual directory and mapped to the appropriate location in C:\.
I have modified the MSDFMAP.ini file to inlude ReadWrite access , given read write access to the web folder using Explorer,nothing so far has made any difference.
Could anybody please offer any advice why Icannot see these pages.
Regards
Alex

Stoad
Freaky Yak Linguist

1983 Posts

Posted - 2004-02-03 : 06:06:01

When you created/saved your pages was the mdb file in C:\Inetpub\wwwroot?
I mean its current location. Otherwise, if you firstly saved the pages and later
after that you moved your *.mdb in wwwroot, then certainly the pages can't
work, because of wrong connection strings in their HTML codes:

<a:ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;
Data Source=D:\test\db1.mdb;Mode=Share Deny None;Jet OLEDB:System database=
"";Jet OLEDB:Database Password=""
</a:ConnectionString>

alex.k
Starting Member

2 Posts

Posted - 2004-02-04 : 05:38:27

Yes, my connection seems to be Ok.This is the string below.
<a:ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=D:\Inetpub\wwwroot\ScreenTest\Screens.mdb;Mode=Share Deny None;Jet OLEDB:System database="";Jet OLEDB:Database Password=""</a:ConnectionString>

Recreated the database-Data access page in another machine running NT4,IE6,IIS4,Access 2000 but it does not make any difference,still
only getting the page title.
Any other suggestions?
Thanks

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources