How do I connect to a DSN in SQL?

From: "Mark - HIS" <MarkHIS@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Wed, 6 Apr 2005 03:59:06 -0700

I have a query to pull data from my MSSQL database, howver I need to use the
INSERT INTO statement to insert the results into a Sybase SQL Database on a
different Server to the one the MSSQL database is on.
I have set up the Sybase SQL Database as a DSN in the ODBC Administrator,
but how do I get the query send the results to the Sybase SQL Database. The
query will ultimately end up being in a 'Job' on the MSSQL Database to run on
a regular schedule.

.

Prev by Date: "Server does not exist or access is denied"
Next by Date: "Linked Table" from a .txt file in SQL Server?
Previous by thread: "Server does not exist or access is denied"
Next by thread: "Linked Table" from a .txt file in SQL Server?
Index(es):
- Date
- Thread

Relevant Pages

Re: fatal memory error after executing query on MSSQL server
... > Is the message I get when I execute a select query on a MSSQL database. ... 30MB is quite a lot of memory for a simple script to need -- ...
(alt.php)
fatal memory error after executing query on MSSQL server
... Is the message I get when I execute a select query on a MSSQL database. ... The connection to the server is established. ...
(alt.php)
Re: How do I connect to a DSN in SQL?
... >I have a query to pull data from my MSSQL database, howver I need to use ... > different Server to the one the MSSQL database is on. ... > I have set up the Sybase SQL Database as a DSN in the ODBC Administrator, ... > but how do I get the query send the results to the Sybase SQL Database. ...
(microsoft.public.sqlserver.odbc)
How do you connect to a DSN in SQL
... I have a query to pull data from my MSSQL database, howver I need to use the ... I have set up the Sybase SQL Database as a DSN in the ODBC Administrator, ...
(microsoft.public.sqlserver.setup)