CodeCharge Studio
search Register Login  

Web Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> ASP

 Remote Server Access database connection

Print topic Send  topic

Author Message
L
Posted: 03/03/2004, 11:29 AM

I am trying to connect from an ASP page to an Access database that resides on the D drive on a distant server outside the web servers network. What would be the syntax of the connection string. Here is the one I used on my local PC with a copy of the database on my local PC.

Provider=MICROSOFT.JET.OLEDB.4.0;Data Source=C:\inetpub\wwwroot\\MyDB.mdb
kevind
Posted: 03/03/2004, 1:34 PM

If the physical path of the database is not on the Web Server or mapped to another drive from the Web Server to the DB Server then, this is not possible using Access.

You need to use MS SQL.

That's my experience.

Kevin

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

PHP Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.