Can Connect To A Database On A Remote Server But With An Error

I 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?

View Replies


ADVERTISEMENT

Connect To A Database On A Remote 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:

View Replies View Related

Connect To A REMOTE Database

In my latest school project, i would need to use ASP to connect to a remote database that is NOT located on the ASP server. I was wondering if this is possible?

View Replies View Related

Connect To A Remote Server To Grab Data

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.

View Replies View Related

Database On Remote Server

I try to get data from a database which is on an other server. I can view the files on this server via the directory "t:" from the machine the ASP pages are on.

Constring:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=t:database.mdb"

Error:
't:Database.mdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.

View Replies View Related

Open A Database Connect From One Server To Another

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 Related

Error: The Transport Failed To Connect To The Server

I'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
%>

View Replies View Related

Error: The Transport Failed To Connect To The Server.

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
' -------------------------------------------------------

..........

View Replies View Related

CDONTS.NewMail.1 Error '80020009' Unable To Connect To Server

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:

View Replies View Related

How To Use “RDS.Connect” To Connect To A MS Access Database?

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:

View Replies View Related

Example Of “RDS.Connect” To Connect To A MS Access Database?

The example I am working from uses the following code which does not work:

RDS.Connect = "Provider='sqloledb';Integrated Security='SSPI';Initial

Code:

View Replies View Related

Error Connecting To MS SQL Server 2005 Database

My Active Server Pages Application is unable to connect to MS SQL Server 2005 Database while the existing application works fine connecting to SQL Server 2000.

View Replies View Related

Connect 2 Server?

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........

View Replies View Related

How To Connect Ftp Server From ASP

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 Related

Connect With Sql Server

how 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 Related

How Do I Connect To The Server?

I 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 Related

Connecting Web Server And Remote Db Server Via Asp

my prob is i have 2 different computers, one that runs my asp pages and the other my database server (mySQL). im working on my local and trying to connect my remote database with my remote webserver using DSNless connection string as more advisable. Code:

View Replies View Related

Local Server To Remote Server

I am not an expert but I am trying to create an application where I need to connect my website to the user's(basically my client) database in access and then I will read the values from the database in the local drive and upload all the values in the database at my webspace. I will have everything like the database name and the password....so how can I do this

View Replies View Related

I Am Trying To Connect With Database

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 ?

View Replies View Related

Asp Connect To Database

I 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.

View Replies View Related

Connect To Database

I'm having a hard time figuring out what type of database is used and where the file is located and how the script is even acessing it. From what I've done in the past with ASP a file was always used that had a DSN, username, and password.how this code is access the database without a username/password/DSN? I've tried using the login info in the line that is commented out (line 2) but it wouldn't let me in so I guess this isn't being used.
Code:
Set objDbConn = Server.CreateObject("ADODB.Connection")
'objDbConn.Open "driver={SQL Server};server=db1.host.com;database=databasename;uid=login;pwd=password;"
objDbConn.Open application.contents("strconn")
Set rsQuery = Server.CreateObject("ADODB.Recordset")
rsQuery.ActiveConnection = objDbConn
rsQuery.open "sp_MajorList"

Set rsetQuery = Server.CreateObject("ADODB.Recordset")
rsetQuery.ActiveConnection = objDbConn

View Replies View Related

Best Way To Connect To Database

I have seen 2 techniques to connect to database and was wondering which one is the best (i.e put less pressue on the database and time wise)

set getRecords = Server.CreateObject("ADODB.Recordset")
getRecords.ActiveConnection = mlConn
getRecords.Source = "SELECT * FROM myDB"
getRecords.CursorType = 1
getRecords.LockType = 3
getRecords.Open()

----OR----

set getRecords = mlConn.Execute("SELECT * FROM myDB")

View Replies View Related

Trying To Connect To A Database.

I am currently trying to get back into ASP and have begun looking at an old webpage I developed some years ago, it was fully functional back in 2002 and I had it up and running with no problems. I have just recently bought a new PC with Windows Vista Home Premium on it and installed IIS. When I try and connect to my data base I get the following error message retunred:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Disk or network error.

/joynermorgan/take_registration.asp, line 50

Line 50 looks like this:

writeDB.Open "joynerm" ....

View Replies View Related

Connect To The Database

What is the best way of connecting to a database? Is it creating an application level variable which is shared by all users ? Or is it a session level variable for each session ? Or is it a connection in each procedure ? Or Should it be like opening the connection when the database is accessed and closing it immediately which means multiple opening and closing in the same procedure.

View Replies View Related

Connect To A Ms Sql Database

I am learning asp and its going smoothly however I seemto not know how to connect to mssql. Can someone show me an example and where I output information from the database and do queries?

View Replies View Related

ASP.NET Database Connect

I am trying to connect to an Access database that I have setup through .NET. I have been able to do it with ASP by setting an ODBC connection and using ASP:

<%
strconn = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("access_databaselocalFinder.mdb")
set strconn = server.createobject("adodb.connection")
strconn.open "DSN=localfinder"
%> .

View Replies View Related

Remote Server

i want upload a txt file to remote server

View Replies View Related

Remote Server

I work with dreamweaver 8. I use the tools provided within dw to create my asp features etc. I downloaded a news script to save time since its a very low budget site, but I need to customise how its displayed.

The news script connects using a Server.MapPath connection. I would like to be able to work locally using a dsn. dsn=nwnews; but I would like to be able to change that connection to work on the remote server for testing etc.

This is Dreamweavers Connection file: Code:

View Replies View Related

FSO On Remote Server

We're wanting to upload files and save them to a different server on the network (Windows 2000) from the web server. The upload works fine but we cannot copy files, using the File System Object, to this other server folder.

what is required in terms of mapping and registering the folder so that the web server can link to it?

View Replies View Related

Remote Server By FSO

I just want to delete a file in a server by FSO. My code is:

Set objFSOD = Server.CreateObject("Scripting.FileSystemObject")
objFSOD.DeleteFile Server.MapPath(".") + "Greetings" + sFileName1,
True
Set objFSOD = Nothing

When I check the code locally, everything is fine. I have two remote servers. When I check the code in each servers, one is fine and other is thrown a error. But the error msg is in Korean language while I'm not korean, that is why I can't read the error
msg. What would be the error msg about? The sFileName1 was always correct every time I checked.

View Replies View Related

Remote Server

Currently we have a site that allows users to listen to mp3 files. It is creating bandwidth issues. So we want to move the mp3 files to an ISP that caps bandwidth usage. Ours is currently burstable.

Now I am able to do the following:

Set fs = CreateObject("Scripting.FileSystemObject")
If fs.fileExists(music_file) Then
'show music file
Else
'do not show a link for file
End If
set fs = nothing

Is it possible to do the same thing, but on a remote server?

View Replies View Related

Connect To A MSsql Server

how do i connect to the server using asp?

View Replies View Related

Connect To News Server

can anyone tell me if it is possible to use asp to connect to a news group, such as this?

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved