Search results for query: *

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.

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...

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...

How do I setup Ad hoc updates to the system catalogs? Thanks.

Hi, I am copying a database from one server to another. I used a DTS package to move over all the database objects. I did a compare and everything is identical. I was told that SQL Logins and passwords are moved over by DTS but won't work correctly. How do I link up the SQL Logins on my new...

Hi, I'm trying to setup replication on SQL Server 7.0. I'm encounter the following errors. The license for this installation SQL SErver does not permit the Log Reader Agent to run at the Publisher. Could no get license information correctly. Can anyone help with this? What am I doing...

Hi, I want to create a scheuduled task that copies files from our local drive to a network share. I mapped the network share and is able to connect to it. I use the XCOPY command in my batch job to copy the files. When I execute the batch file stand alone it runs successfully but when I try...

Hi, I'm creating permissions for users that needs to connect to a SQL Database using a ODBC connection. I'm can't seem to grant them authority to connect to the ODBC data source unless I add them to the administrator role. Is there another role that would allow them to connect? I don't want...

Hello all, Looking at the query below I should not be inserting any rows into table1 where the an_seq field already exist. The results are consist with the select query in terms of I only retrieve rows from table2 that current do not exist on table1 but when I try to insert the new rows into...

Hi, How can I see the password column in the Sysxlogin table on the master database? I see that they are encrypted by is there a way I can see them in regular ASCII? Thanks.

Hi, I'm testing our application and I'm running into this error. Has anyone encountered this and how can you resolve it? Thanks ODBC Error Code = 01000 (General warning) [Microsoft][ODBC SQL Server Driver][SQL Server]Changed database context to 'master'. The error occurred while...

Hi, I'm trying to copy a database from our production environment to our test. Currently the production server is performing replication. What is the best method to setup replication on our test server. We are using SQL 7.0 I moved the prod database over. Should I moved the replicated...