i have 2 database server...........
i have a pages that need to get data from 2 server.......
so, i open connection when want to get data.....
but this page, i need to get data from 4 table in server1 and 3 table from server2......
table in server1 have relationship with table server2.....
so, i always open connection to server1 and get data..then close.....then open connection to server2 and close........
I want to connect my ftp server using ASP,how can i connect? Is there any method to do this. If any one knows the solution please let me know. I know how to connect database on ftp server,but now i want to connect to ftp server only. If any related solution urls for this problem please let me know.
View Replies View Relatedhow to connect asp with sql server, i dont know any steps,because i am newbie to this envoronment,so kindly tel each ang every step.
View Replies View RelatedI am about to do the first step of this ASP stuff - have created the file.asp and thankyou.asp and want them into the right folder. But I dont understand how to use IIS to connect to the server, I am renting webspace from somewhere else.
View Replies View Relatedhow do i connect to the server using asp?
View Replies View Relatedcan anyone tell me if it is possible to use asp to connect to a news group, such as this?
View Replies View RelatedI recently got an error message from the Java release:
j2rel.4.2_05
regarding
c:program filesjavaj2rel.4.2_05injpiexp32.dll
This message came in a .log file to my desktop, and since then, every once in a while I get this following error while trying access my pages in which I am creating. Code:
I tried setting up formmail ASP based on Matt's cgi script but only got these errors when submitting this page: http://www.a2zli.com/surveycl56.htm
Formmail v1.3 detected the following errors:
error no.: -2147220973
description: The transport failed to connect to the server.
I am about to migrate my asp web pages from a previous well functioning connection with Access 2003 to SQL Server 2005 Express Edition instead.
I have created a database in SQL Server called "test_db". As far as I know I have not set any particular user id or password for the database.
In this microscopic database I have onnly a single table called "name" and in this table I have two columns called "fname" and "lname". I have two records stored in the name table. What I want to achieve is simply to display these two records in my asp-page.
How can I achieve this and what am I missing here?
My website connects to a remote sql server. Application works fine when I run from Visual Studio. But when I run the site from IIS, it shows an error.
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
I have my access database on a xp workstation setup as a web server using IIS. I am trying to access the mdb from another web server, but when I run my code below I keep getting :
Microsoft ADO/RDS error '800a20ff'
Internet Server Error. Code:
I have had a web server up an running for a while based on Access 2003 and asp code. Now I have decided to upgrade the database to SQL Server 2005 (not the express edition). The problem is that I just can't get it to work properly.
During the installation I was prompted for an instance name (I chose the default radio button). I am using windows authentication on a Windows 2003 Server OS.
I have created a database called "testDB". This database has only 1 table called "testtable" and this table consists of a single column called "name" with just 4 records. I want to display these records in my webpage.
The code below works fine with Access 2003 but how should it be changed to work with SQL 2005 too? Code:
I have two servers is it possible to open a database connect on one server to access the database on the other. If so can anyone give me an example of the path.
View Replies View RelatedThe aim is to get it working on this machine so I can port everything to a Enterprise Version but can't get around this error for the last two days. Code:
View Replies View RelatedI'm using this coding but get some error. i can't understand this line
.Item(sch & "smtpserver") = "<enter_mail.server_here>"
mail server means which server im used help me
error:Error Type:
CDO.Message.1 (0x80040213)
The transport failed to connect to the server.
<%
sch = "http://schemas.microsoft.com/cdo/configuration/"
Set cdoConfig = CreateObject("CDO.Configuration")
With cdoConfig.Fields
.Item(sch & "sendusing") = 2 ' cdoSendUsingPort
.Item(sch & "smtpserver") = "<enter_mail.server_here>"
.update
End With
Set cdoMessage = CreateObject("CDO.Message")
With cdoMessage
Set .Configuration = cdoConfig
.From = "basvbas@yahoo.com"
.To = "basvbas22@yahoo.com"
.Subject = "Sample CDO Message"
.TextBody = "This is a test for CDO.message"
.Send
End With
Set cdoMessage = Nothing
Set cdoConfig = Nothing
%>
I have a form in my website and keep getting this error I was wondering if anyone could help out with this error message I keep getting
<!--#include file="email_validation.asp"-->
<%
Dim strMailFrom
Dim strMailTo
Dim strMailServer
Dim strMailSubject
' -------------------------------------------------------
' Stuff you need to change
' -------------------------------------------------------
..........
Theres a script that bypasses ODBC and connects directly to .mdb database for asp scripts , is anyone familiar with this? I dont even know if its a .asp script.
View Replies View RelatedI eventually managed to create a connection between my IIS LocalHost ASP WebPages and my database located on a website on the net. Here is the solution:
Dim conn, connect
set conn=server.CreateObject ("adodb.connection")
connect = "Provider=MS Remote; Remote Server=http://www.example.com; Remote Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & server.mappath("database_filedatabase.mdb") & ";"
conn.Open connect
When I point my connection to my database on the net like in the code above I get the following error:
Error Type:
Microsoft ADO/RDS (0x800A2011)
Internet Server Error: Object/module not found.
Any Suggestions?
I am facing a problem that i am unable to connect to Live Communication Server using my own UI. Actually i want to access the API's in LCS through my own UI(which is a messenger UI),which i am using to implement chatting messenger in my project.
The main reson is that i dont know the code to connect to this LCS and what namespace shld i use so that i can access all the functionality of my LCS 2005.
The coding is to be done in c#. I could have used the MS OFFICE Communicator direcltly but i have to use my oen UI and thus i need to connect to this LCS...
I am wondering if it is possible to have an asp script, called script1.asp sitting on a server called server1. when this asp script runs, i want it to connect too a different server (called server2) somewhere else in the world and grab data, maybe an xml file.
Is this possible? and if so what is the process called (and/or function names etc) that can help me do this, so i can look them up in google and get cracking on the code.
I get the follow error on a linux box that is running sun asp:
CDONTS.NewMail.1 error '80020009' unable to connect to server
The error occurs when the Send Command is Executed. Here is my code:
The example I am working from uses the following code which does not work:
RDS.Connect = "Provider='sqloledb';Integrated Security='SSPI';Initial
So I tried the following, but still no go. Code:
The example I am working from uses the following code which does not work:
RDS.Connect = "Provider='sqloledb';Integrated Security='SSPI';Initial
Code:
I am getting:
Error Type:
Microsoft VBScript runtime (0x800A01A8)
Object required: ''
/theborg/includes/dbconnect.asp, line 4
I can't figure it out. It worked fine while testing in access. Though there is no data in the SQL database yet. But when I try to populate the data I get the same result
dbconnect.asp:
Code:
<%
Dim objConn
objConn = Server.CreateObject("ADODB.CONNECTION")
objConn.Open "DSN=Assimalation"
%>
Homepage.asp
Code:
i have file and database on remote server, and i want to connect via DSN. i make DSN over there. and when call that dsn in code. it gives null user error.
if i pass user id and password with dsn it connect other wise error occurs
if i have a DSN then why i should pass it again.
how can i solve it.
I got read a lot of attachment about how to connect ASP to SQL server but i still got problem about it. either i use which ways(there are 2 ways connect it)... it always has this error.
Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.
May I know what is it mean? how to solve it
I have uploaded a *.mdb to a remote server. ive setup a dns there for the mdb, ive done a test on the mdb on the remote server- all is ok. But when i try to connect to the dns/mdb via the dreamweaver interface, i get this error message:
http://www.britanniacabinets.com/error.gif
I have an existing web app on a remote server that I want to manage as a web project on my local box with Visual InterDev. But when I create a new project in VID and connect to the web server, I cannot connect to the existing web app.
At the "Specify your web" dialog box I choose "connect to existing web on server" but the only option that shows up is <root web>. I cannot overwrite this option with the name of the web I want to connect to
I can see this web application in the IIS Manager on the remote server and it is configured as a web application. It accessible in a browser. Why won't it show up in Visual InterDEV?
My asp application is connect to oracle database. However, when i try to open the default page, an error occurs and i receive this message:
- Error Type:
Microsoft VBScript runtime (0x800A01B6)
Object doesn't support this property or method: 'MoveFirst'
The code that is causing this error is following:
Code:
<%
Dim objConn
Dim rsForums
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "dsn=ORCL9; uid=toy; pwd=yes;"
Set rsForums = Server.CreateObject("ADODB.Recordset")
rsForums = objConn.Execute ("SELECT * FROM Forums ORDER BY Forum ASC")
rsForums.MoveFirst
%>
<table width="100%" align="center" cellspacing="0" cellpadding="6" border="1">
<tr>
<td width="60%">
<p><b>Forums</b>
</tr>
<%
While Not rsForums.EOF
%>
<tr>
<td><a href="forum.asp?ForumID=<%= rsForums("ForumID") %>"><B><%= rsForums("Forum") %></B></a>
<BR>
<BLOCKQUOTE>
<%= rsForums ("Description")%><BR>
<SMALL>[Total Posts: <%= rsForums("Posts") %>] [Last Post on <%= rsForums("LastPost") %>]</SMALL>
</BLOCKQUOTE>
</tr>
<%
rsForums.MoveNext
Wend
rsForums.Close
The forums table in the oracle database has 2 lines of records, and it should not occur this error. Do you have any idea what is happenning?
I'm trying to create a connect string, but I might have a unique situtation. When connecting to Query Analyzer, I connect using RUNAS specifying domain and username. Is it possible to create a connect string given the above requirements? Here's what I'm trying to use:
<%
Set demoConn = Server.CreateObject("ADODB.Connection")
demoPath="DRIVER={SQL Server};" & _
"SERVER=myserver;UID=username;" & _
"PWD=pw;DATABASE=qdb"
demoConn.open demoPath
%>
I am trying to connect to my access DB. I am developing my site in Dreanweaver and I have the site hosted already. I want to use the hosts server as my testing server.
When I create a connection string to the DB I have to use the servers directories. ex: e:/hshome/site/something.mdb When I try to add a server behavior to a form it can't find the DB. What am I doing wrong ?
I am running a website on anintranet on one domain and trying to connect to a SQL database that is in another domain. The server that is running the website does not have SQL Server installed on it. I've looked at many different variations to set this up but none have been successful so far.
View Replies View RelatedI have an access database that I need to put online for basic viewing. However, the database is also used by other people for updating and report printing. The web server and the access database are on two seperate servers. I cannot connect directly to the database cause if somebody has it open, the website will not work and for some reason I cannot connect to to database across servers. I tried a linked database, but asp will not recognise it.
I know that I could put all the reports and stuff online, but I have till next week
and I do not think that I can do it in this short a time. Any ideas will be helpful and if there is code that I need to manipulate I could try to do it. And also I do not have rights to configure the IIS option on the servers.