|
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
, 3 posts
by 3 people.
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).
|
|
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
, 3 posts
by 3 people.
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.
|
|
1) When a script gets data from the database using the db.Model.get_element_by_id("id") method, what id does it refer to, and how can you get it from the database.
2) If you get a result using this method, does that result maintain a link to the database...
Started by chustar on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
There is no "link"; the ID or key your question about "how would you update an entry in the database:
Finally, greeting.put() saves worry about things like "maintaining ....
Of the two is present, or None if neither are, by k.id_or_name() .
|
Ask your Facebook Friends
|
Is it possible to link to a MySql database that is on another server and hosted somewhere else entirely?
Started by HollerTrain on
, 10 posts
by 10 people.
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.
|
|
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
, 3 posts
by 3 people.
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.
|
|
Are there any tricks to transferring and/or sharing the Resource Links across multiple PHP pages? I do not want the server to continue connecting to the database just to obtain another link to the same user in the same database.
Remember that the link...
Answer Snippets (Read the full thread at stackoverflow):
If your user opens one page every minute, it's far better to have the database connection closed of Mysql over other heavier-weight....
Database connections take up.
Children end up sitting around, holding idle database connections open.
|
|
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
, 3 posts
by 3 people.
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.
|
|
I wish to move a database between two servers, I have backed the database up from the first server and done a database restore on the 2nd server, so far so good.
However our application make use of a lot of database users that are defined in the database...
Started by Ian Ringrose on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
I found the following script somewhere - run it on the original server and it will create a stored procedure called 'sp_help_revlogin' which generates another script to run on the destination server, creating all user accounts with the same passwords ... .
|
|
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
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at serverfault):
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 Harry Vermillion on
, 6 posts
by 6 people.
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.
|
