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 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?
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 RelatedI 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 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.
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 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 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 Relatedmy 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 RelatedI 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 RelatedI 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 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.
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
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")
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" ....
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 RelatedI 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 RelatedI 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"
%> .
i want upload a txt file to remote server
View Replies View RelatedI 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:
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?
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.
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?
how 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:
IM trying to put up a small database in my website and having my visitors to search it. A record of this database will have four fields: The first one will hold a number, the second one a Street name, the third a City, and the fourth a picture. The database will be searched either by the number or by the city.
View Replies View RelatedI have 2 websites which are related in content and usage, both are database driven.
My question is, is it possible to connect to a .mdb database using asp on one website from another website.
I've got a database on my web server and when I create the connection using a custom connection string within Dreamweaver, it connects with no problems. However, Dreamweaver then doesn't see the tables in the database.
I know there's an issue with SP2 and Dreamweaver but I've installed the patch and it hasn't made any difference. Does anyone know of another work around?