Access to | data | database unless you use Telnet to the software logon ISP's server, you are not able to connect to the database via DSN. Here are a few ways to connect you beyond your ISP and make it easy to connect to your database:
1.SQL Server
<%
CStr = "PROVIDER=SQLOLEDB; Server=<ip address>;d atabase=<dbname>; "
CStr = CStr & "network=dbmssocn;uid=<uid>;p wd=<pwd>"
Set conn = Server.CreateObject ("Adodb.connection")
Conn.Open CStr
' Connect with NETWORK=DBMSSOCN to avoid errors caused by admin naming
%>
2.Oracle
<%
CStr = "provider=oraoledb.oracle; Server=<ip address>;D ata "
CStr = CST & "source=<dbname>; User id=<uid>; Password=<pwd> "
Set conn = Server.CreateObject ("Adodb.connection")
Conn.Open CStr
%>
3. Access
<%
CStr = "Driver={microsoft Access Driver (*.mdb)};D bq="
CStr = CStr & Server.MapPath ("/<pathtofile.mdb>")
Set conn = Server.CreateObject ("Adodb.connection")
Conn.Open CStr
%>
4. If you have Jet 4.0 installed, this is a better way to connect.
<%
CStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data source="
CStr = CStr & Server.MapPath ("/<pathtofile.mdb>")
Set conn = Server.CreateObject ("Adodb.connection")
Conn.Open CStr
%>
