|
Home > Archive > MS SQL Server ODBC > May 2005 > How do I connect to a DSN in SQL?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
How do I connect to a DSN in SQL?
|
|
| Mark - HIS 2005-04-06, 7:01 am |
| 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.
| |
| Chris Lee[MS} 2005-05-10, 3:23 am |
| Have you considered using DTS to do this?
"Mark - HIS" <MarkHIS@discussions.microsoft.com> wrote in message
news:98C63863-8BB9-4415-B6D8- D23F32DBD5DB@microso
ft.com...
>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.
>
|
|
|
|
|