Omgili - forum search, search forums  
  

Discussions about database link

Displaying 1 - 10 out of 41,302 discussions.  
Time Frame: (Any time)   Minimum number of replies: (2)   Minimum number of discussing users: (0)
  |  

Page: 1   2   3   4   5   6   7   8   9   10  
Keep this page open to be updated with the newest discussions automatically.
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 on , 3 posts by 3 people.  
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).
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 on , 3 posts by 3 people.  
That connection!? I what to establish connection from sql server to oracle database link! Is that possible.
Is it possible to link to a MySql database that is on another server and hosted somewhere else entirely?
Started by on , 10 posts by 10 people.  
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.
Ask your Facebook Friends
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 on , 11 posts by 7 people.  
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.
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 on , 3 posts by 3 people.  
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.
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 on , 13 posts by 6 people.  
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'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 on , 3 posts by 3 people.  
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.
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 on , 3 posts by 3 people.  
EXEC ('RESTORE DATABASE ...') AT other_server_name That works fine.
OK, that was pretty silly.
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 on , 6 posts by 6 people.  
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.
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 on , 3 posts by 3 people.  
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.
Page: 1   2   3   4   5   6   7   8   9   10  

Related Message Boards & Forums

  • Stack Overflow
  • OTN Discussion : Database - General
  • Server Fault
Related Searches
link update database nod32    link an access database command button to a specific record in a report   
More Information


Forum Search About Omgili Help Plugins Forum/Board Owners Privacy

i
In Title
In Topic
In Reply
Exclude
Boost