Recent content by YL5956

Hello, I need to write a cobol program which submits a TSO EXEC command and captures the output. I don't know Cobol very well, and couldn't find any information on this subject. Can someone help me with this? thanks.

Recently, we upgraded our database to SQL 2000. Af the conversion, we started having intermittent problems connecting to the database. We are using a named instance of SQL 2000, upgraded the MDAC on the Coldfusion Server. I can verify the ODBC datasources without any problems but when the...

Hi, I want to copy the data from our Production Server to our test server. I don't want to recreate all the objects, just import the data. What is the best way to do this? I tried using the import wizard but the data didn't move over. What am I doing wrong? Thanks in advance for your help.

We are running coldfusion on an Extranet W2K server. The server is connecting to a SQL 7 database inside the firewall. Our database server was recently moved to Active Directory. After the migration, the Data sources in Coldfusion Administrator, on the Extranet Server, would no longer...

I am able to log on to our Windows 2000 Server using terminal services, but when I try to log out the screen goes blue and just freezes. For some reason it's not completing the log out sequence. Any suggestions?

We have a Coldfusion application that has the authority to delete and create SQL Server users. We are running into the problem where when we perform a delete the user account is removed from Enterprise manager, but when we try to recreate the account, SQL Server comes back with a user already...

I'm copying from a SQL 7.0 to a SQL 2000 database and my passwords are not being moved across correctly. I run the sp_help_revlogin script to move over the logins and then copy the database over using DTS. The problem I'm having is when I try to connect to Query Analyzer using one of the SQL...

Hi, Is there a way to rename an instance of SQL2000? Thanks.

Is there a way for Windows 2000 to kick off a script upon a server reboot? I know there is a way to run a script upon logon, but our server is going to be unattended and the script would need to run without someone having to log on. Thanks.

I'm running a query that select rows from a db2 subsystem and then cross-referencing those rows to a table on a different db2 subsystem. My query is running into a -512 error. Does anyone know why I'm getting this error? Select Pkg_name from RMS.COMPONENT where pkg_name is not in...

What I want to do is to stage all my scripts, tables, procedures, etc, in one folder. After the staging has completed, I would run the batch job and it'll load all the objects into SQL Server. I need to know how load the objects into SQL Server using batch. Thanks. yl5956

I was wondering if anyone know how I can use a batch script to exec procedures from a remote directory. I think OSQL would work but is there a more efficient way? The process I have in mind is to use the script to look at a particular directory and 'exec' every object in that directory. Thanks.

Hi, I'm setting up user to connect to a SQL Server 7.0 database on Windows 2000 using ODBC. The Server doesn't let them connect unless they are made administrators on the machine. I don't to grant them admin rights. Is there another group I can add them to and have them be able to connect to...

I did that. Here is what my server shows but I still get the same error message. I'm sure I'm doing something wrong. Thanks. name minimum maximum config_value run_value ------------- --------- ----------- ------------ --------- allow updates 0 1 1...

Here is the message I'm getting from Query Analyzer after running the script to create the stored procedure. Server: Msg 259, Level 16, State 2, Procedure sp_dba_to_allow_non_sa_to_change_password, Line 63 Ad hoc updates to system catalogs are not enabled. The system administrator must...