Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Code Support: ASP (Non-Forum Related)
 Changes from local intranet to web
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

kavaliotis
Starting Member

11 Posts

Posted - 31 May 2001 :  05:27:41  Show Profile
Hello guys, i have some asp pages and a database all uploaded in Brinkster.com. Because i was working on a local intranet (my PC) to test and prepare the pages, i don't know what i have to change in order to make them work on the web. What changes in the code do i have to make? One thing is DSNless connection, but can Dreamweaver do it automatically?

RaiderUK
Average Member

United Kingdom
577 Posts

Posted - 31 May 2001 :  05:35:18  Show Profile  Send RaiderUK a Yahoo! Message
no dreamweaver cannot do it automatically, but you can use a DSN less connection in DWUD 4, the best way is just to make the changes in the connections folder before you upload, just comment out the DSN and put in a DSN-less for going on the web and change back for locally.

Go to Top of Page

kavaliotis
Starting Member

11 Posts

Posted - 31 May 2001 :  06:08:01  Show Profile
OK,in my connections folder (C:\Inetpub\wwwroot\Connections) i have a file called DSN_Connection.asp and the code inside it is:

<%
' FileName="Connection_odbc_conn_dsn.htm"
' Type="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
MM_DSN_Connection_STRING = "dsn=DSN_Connection;"
%>

How do i change that in order to work with Brinkster.com? They say that i should use (for a DSNless connection that is) the following code in my asp pages:

Dim oConn, sConnString
Set oConn = Server.CreateObject("ADODB.Connection")
sConnString = "DRIVER={Microsoft Access Driver (*.mdb)};" & _
"DBQ=" & Server.MapPath("\MemberName\db\dbname.mdb") & ";"
oConn.Open(sConnString)


At this point you can define a SQL statement and execute it:

sql = "select * from myTable"
Set RS = Conn.Execute(sql)

But do i do that in my DSN_Connection file or in the pages? Especially in the login page of my site, i don't have anything like that because i used the "USER AUTHENTICATION" feature Of Dreamweaver UltraDEV 4..

Go to Top of Page

RaiderUK
Average Member

United Kingdom
577 Posts

Posted - 31 May 2001 :  06:14:43  Show Profile  Send RaiderUK a Yahoo! Message
try this.
Change connection file to.
<%
' FileName="Connection_odbc_conn_dsn.htm"
' Type="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
' MM_DSN_Connection_STRING = "dsn=DSN_Connection;"
MM_DSN_Connection_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("\MemberName\db\dbname.mdb")
%>

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.28 seconds. Powered By: Snitz Forums 2000 Version 3.4.07