Hi,
I'm taking data from mainframe and processing it using SQL Server
2000. Now I take data from mainframe as .txt file and loading it to
the sql server 2000. How can I connect SQL Server 2000 to mainframe to
get the data.
Thanks
ShafeekOne way is to ftp the file to the distributed environment such as a Windows
file server or on the SQL Server box and then use DTS or Bulk insert/bcp
utilities.
"Shafeek Khalidh" <itsprobablyme@.msn.com> wrote in message
news:f086c89e.0307110827.5936d7bb@.posting.google.com...
> Hi,
> I'm taking data from mainframe and processing it using SQL Server
> 2000. Now I take data from mainframe as .txt file and loading it to
> the sql server 2000. How can I connect SQL Server 2000 to mainframe to
> get the data.
> Thanks
> Shafeek|||Why don't you try Extended Stored Procedure.
Because you can use C to write DLL, you can do almost anything in it.
Include connect to mainframe, and get some data, certianly you can put it
into server if you want.
cheers
"Shafeek Khalidh" <itsprobablyme@.msn.com> wrote in message
news:f086c89e.0307110827.5936d7bb@.posting.google.com...
> Hi,
> I'm taking data from mainframe and processing it using SQL Server
> 2000. Now I take data from mainframe as .txt file and loading it to
> the sql server 2000. How can I connect SQL Server 2000 to mainframe to
> get the data.
> Thanks
> Shafeek
Showing posts with label mainframe. Show all posts
Showing posts with label mainframe. Show all posts
Monday, March 19, 2012
Wednesday, March 7, 2012
Connecting to a Datacom DB data source
I recently installed SQL Server 2000 Reporting Services and connect to
a number of disparate data sources -- except a CA Datacom/DB
(mainframe) data source.
Any ideas on how to connect to the mainframe data so that it has the
look and feel of an ODBC database? And if so, what are the products
involved?
Thanks,
RBollinger
I'm using CA-Visual Express to hit Datacom through the Client ODBC Driver. It's a bit tricky with the authorities. You have to make sure they're set at the ODBC level if you want more than read-only access. We've not quite worked out the details on this yet. However, you can import any datacom table through the same ODBC driver using MS Access and perform all queries through there. (Not graceful, granted, but it does work!)
Good Luck,
rrowe.
a number of disparate data sources -- except a CA Datacom/DB
(mainframe) data source.
Any ideas on how to connect to the mainframe data so that it has the
look and feel of an ODBC database? And if so, what are the products
involved?
Thanks,
RBollinger
I'm using CA-Visual Express to hit Datacom through the Client ODBC Driver. It's a bit tricky with the authorities. You have to make sure they're set at the ODBC level if you want more than read-only access. We've not quite worked out the details on this yet. However, you can import any datacom table through the same ODBC driver using MS Access and perform all queries through there. (Not graceful, granted, but it does work!)
Good Luck,
rrowe.
Connecting to a Datacom DB data source
I recently installed SQL Server 2000 Reporting Services and connect to
a number of disparate data sources -- except a CA Datacom/DB
(mainframe) data source.
Any ideas on how to connect to the mainframe data so that it has the
look and feel of an ODBC database? And if so, what are the products
involved?
Thanks,
RBollingerI'm using CA-Visual Express to hit Datacom through the Client ODBC
Driver. It's a bit tricky with the authorities. You have to make sure
they're set at the ODBC level if you want more than read-only access.
We've not quite worked out the details on this yet. However, you can
import any datacom table through the same ODBC driver using MS Access
and perform all queries through there. (Not graceful, granted, but it
does work!)
Good Luck,
rrowe.
rrowe
---
Posted via http://www.mcse.ms
---
View this thread: http://www.mcse.ms/message535356.html
a number of disparate data sources -- except a CA Datacom/DB
(mainframe) data source.
Any ideas on how to connect to the mainframe data so that it has the
look and feel of an ODBC database? And if so, what are the products
involved?
Thanks,
RBollingerI'm using CA-Visual Express to hit Datacom through the Client ODBC
Driver. It's a bit tricky with the authorities. You have to make sure
they're set at the ODBC level if you want more than read-only access.
We've not quite worked out the details on this yet. However, you can
import any datacom table through the same ODBC driver using MS Access
and perform all queries through there. (Not graceful, granted, but it
does work!)
Good Luck,
rrowe.
rrowe
---
Posted via http://www.mcse.ms
---
View this thread: http://www.mcse.ms/message535356.html
Subscribe to:
Posts (Atom)