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


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

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

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

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

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

Can't Connect To MySQL Server

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

View Replies View Related

Connect To Database On Another Domain

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

View Replies View Related

Connect To Database In Dreamweaver

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?

View Replies View Related

Connect To Database Problem...

set conn = Server.CreateObject("ADODB.Connection")
conn.Open ("DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=sportteam;")

this is my connection to mysql.....
but, when i use looping from market table........
then, get id from market to sum bet table.....

is quick slow........
around 70-80 second.....

why quick slow.........?

my connection have problem?

View Replies View Related

Not Able To Connect The Web Pages To The Database

i am not able to connect the web pages to the database I am using the code as follows:

<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "d:/Inetpub/webdata/db1.mdb"

set rs=Server.CreateObject("ADODB.recordset")
rs.Open "Table1", conn
%>

View Replies View Related

Connect To Access Database?

I am connecting to a microsoft access database using ASP. It works perfectly if i put all the code in every page i access a database with.

However i have created a useDatabase.asp file which contains functions for connecting to the database. I use an include statement and call the function but seem to always receive an error which dissappears when i remove the function and paste the code. Code:

View Replies View Related

Connect To 2 Database With 1 Provider.

I am using the following to connect to SQL Server. How can connect to 2 database with this?

strProvider = "Driver={SQL Server};SERVER=myserver;UID=user;PWD=password;DATA BASE=myDatabase;"

I do not want to code the Database name and user in the query, as below:

[database].[user].[table]

View Replies View Related

Connect 2 Ms Access .mdb Database

is it possible to connect 2 ms access .mdb database? can anyone advise me how u connect 2 ms access .mdb?

View Replies View Related

Connect To Your Database Oracle 9i

How do you connect to your database(oracle9i) upon clicking a button? Let's say I have a text box which ask for a specific date, then upon clicking the button, the script will connect to the database and extract records based on the input date.

View Replies View Related

Connect To MySQL Database

I'm a PHP developer and i've been asked to do some development for a site which is on a web server which only supports ASP. I had planned to have a bash at writing an ASP program (first time) on this server which will interact with a MySQL database on another web server (my company's web space).

Would this be possible, or should I try and set up the database on the same server as the ASP pages (this may cost money, which is why i'm hoping the first option will be possible)?

View Replies View Related

Connect MS Access Database

tell the easy way to connect a database to ASP and also html from in wchich text connect with ASP file whcih are conncected with database .

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 Access Database Using ADO

Anyone have any idea what I am doing wrong. I have included the asp pages and the database, in hope that someone can tell what I am lost on. This page never loads when i try to open it in the browser.

View Replies View Related

Connect With Access Database

using XP pro with IIS to develop offline asp data access site. Suddenly, my DSNs and odbc drivers have disappeared - the only thing I can think of is that an XP auto update has done this in some way.

Can anyone tell me how to get hold of and re-instal odbc drivers to allow me to connect with ACCESS data bases.

View Replies View Related







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