Discussions about database link

Possible to link to another database link? We have an existing database link in an Oracle database that links to data in a Sql Server database. Now, a 2nd Oracle database needs to use that same data. Due to security setup, the 2nd Oracle database cannot "see" the Sql Server database, but it can... Started by Shane on Tuesday, January 19, 2010, 3 posts by 3 people.   Read the full thread at stackoverflow Discuss this with your friends on Facebook Answer Snippets (Read the full thread at stackoverflow): From Database 2, you could then query: SELECT: (assumes db link to DB1 connects.... However, even if it doesn't work, you can still create a view in Database 1 that points to a table in your SQL Server Database. Not do it right now).

Access database - links to SQL Server and Oracle The application part of my database is in Access 2003, and I use tables that are linked from SQL server. Now, I have some tables that I have to link from an Oracle database. I link them through and ODBC connection and it works fine. Is it possible to ... Started by Jasmin on Tuesday, October 27, 2009, 3 posts by 3 people.   Read the full thread at stackoverflow Discuss this with your friends on Facebook Answer Snippets (Read the full thread at stackoverflow): That connection!? I what to establish connection from sql server to oracle database link! Is that possible.

Website Here, Linking to Database There on other Server? Is it possible to link to a MySql database that is on another server and hosted somewhere else entirely? Started by HollerTrain on Friday, August 28, 2009, 10 posts by 10 people.   Read the full thread at stackoverflow Discuss this with your friends on Facebook Answer Snippets (Read the full thread at stackoverflow): The most common production deployment has the database application will be connecting to some.... To MySQL Database Server yes, however, performance (bandwidth, latency) may be an issue depending://www.connectionstrings.com/mysql Certainly.

Database link from one Oracle database Hi everyone! I have 2 databases. I need to create a database link to copy a table from one of the database to another. Both of them are Oracle 10g v2 Please advice me on how can I go about it. I am trying to avoid import and export. What are the options... Started by user645399 on Tuesday, September 28, 2010, 11 posts by 7 people.   Read the full thread at oracle Discuss this with your friends on Facebook Answer Snippets (Read the full thread at oracle): Dear user645399, You can create a database link with the following syntax.... If both databases are reachable over network from each other, then you can create a "database link" and pull the data from source database.

Web (anchor) link to a Notes database Hi Is there a way to create a regular web (or anchor) link that will open a Notes client and display a pre-determined database from the workplace? Thanks in advance. Ronnie Started by rnnbrwn on Monday, September 07, 2009, 3 posts by 3 people.   Read the full thread at stackoverflow Discuss this with your friends on Facebook Answer Snippets (Read the full thread at stackoverflow): Regards Thorsten Thorstens answer should work for databases on servers aswell: notes://[server.... Hi, try this for a local database: notes:///[drive]:/[path_to_notes_data]/[database.nsf] This will open the database in the notes-client.

Database link from one database to a Hi All, I have Oracle 10 g database in windows 2008 server and the remote database is Oracle 11g. I want to copy the tables from the remote database into my database. The script should run daily and the rows updated in the remote database should be copied... Started by user5160274 on Saturday, May 05, 2012, 13 posts by 6 people.   Read the full thread at oracle Discuss this with your friends on Facebook Answer Snippets (Read the full thread at oracle): This process ia a daily.... This process ia a daily process ie., what are rows updated in the remote database should entire table from the remote database to my database using database link. database link.

Oracle Database Link - MySQL Equivalent ? Oracle's database link allows user to query on multiple physical databases. Is there any MySQL equivalent ? Workaround ? I want to run a join query on two tables , which are in two physical databases. Is it possible in MySQL ? Started by Palani on Wednesday, October 14, 2009, 3 posts by 3 people.   Read the full thread at stackoverflow Discuss this with your friends on Facebook Answer Snippets (Read the full thread at stackoverflow): If your external .... This requires that the currently. Can do a work-around if the databases are on the same machine, by just adding the database-name the dbname.tablename`-syntax to access tables outside the current database scope.

SQL 2005 RESTORE DATABASE on a linked server I'm trying to copy a database from one server to another by backup and restore. I've created steps in an agent job to backup the database to file and to xcopy the file over to the other server. I'm trying to do the restore now, and it's not working. The... Started by Richard Gadsden on Wednesday, June 03, 2009, 3 posts by 3 people.   Read the full thread at serverfault Discuss this with your friends on Facebook Answer Snippets (Read the full thread at serverfault): EXEC ('RESTORE DATABASE ...') AT other_server_name That works fine. OK, that was pretty silly.

Programatically link SQL Server tables in a new Access 2007 database I manage an SQL Server 2005 Database and I would like to give read-only access to the necessary tables to a group of 20-30 networked users who are able to use the GUI in MS Access 2007 to write or modify their own queries to the database, with some help... Started by Harry Vermillion on Wednesday, October 14, 2009, 6 posts by 6 people.   Read the full thread at stackoverflow Discuss this with your friends on Facebook Answer Snippets (Read the full thread at stackoverflow): I just wrote an article last week detailing a way to quickly link all tables in an SQL Database Example (link.... Use FILE | GET EXTERNAL DATA | LINK TABLES). Development machine, create a DSN for your SQL Server database.

Whats a good way to protect a link database from automatic scrapers? I have a large link database, that I would want to protect against others who would want to copy them. Is there anything I can do other than force people to enter a CAPTCHA before each link? Started by Yegor on Tuesday, September 01, 2009, 3 posts by 3 people.   Read the full thread at stackoverflow Discuss this with your friends on Facebook Answer Snippets (Read the full thread at stackoverflow): This approach may not be appropriate if you support before going to the protected link? We might be able to provide better advice that way.. To request a page from your site before accessing a link.