Recent content by rhofing

Hello, I am trying to create a connection to an Lotus Notes database in a DTS package. I am using the Lotus NotesSQL ODBC driver from IBM to create the connection. After specifying the Notes server, database and user info I get the following error: Package Error Error Source: Microsoft OLE DB...

Hello, I need to be able to derive which colours, and their percentages, that make up a solid color image (a square) for a chemical analysis application I am writing in VB.NET. For example, a pink square. I need to be able to determine which colors are being used (red and white in this case) and...

I use both Profiler and Performance Monitor, depending on my needs.

I am running SQL 2000 on a W2K box (setup by someone else who is no longer here). I start up the Performance Monitor and the SQL counters are missing (various others are available). The application log contains the following message: The configuration information of the performance library...

At the risk of sounding like a mathematical moron I have a question about DBCC SHRINKDATABASE. How is the actual free space calculated based on the percentage free value specified in the command? I take an example from BOL: mydb data file contains 6 MB of data, if you specify a...

Hello, I would like to call the DAO DBEngine.compactdatabase method to compact an Access database before I populate it with new data. I need to run this as part of an ActiveX task in a DTS package. Can someone show me a VBscript code sample to accomplish this? Many thanks! Ric

Hello, I have a DTS package that inserts and deletes data in an Access database. I want to compact the Access database using the compactdatabase method. This is a DAO object. I will need to do this from an ActiveX task. Can someone show me some sample code or explain how to do this? Thanks...

Can someone point out a good resource (book, web site ,etc) on creating extended stored procedures? BOL contains only one example. C++ books of course do not cover this (not any that I have looked at any rate). Thanks! Ric

I am using SQL 7. I would like to create an extended stored procedure using VB6. Is this possible? I created a number of functions in VB6, created the DLL and copied it to \mssql7\binn and register it (as per BOL). When I try to use it I get the following error message: Cannot load the DLL...

Hello, we are considering using Transactional replication here to replicate a production database to another server that the users can use for adhoc queries and report generation. My replication experience is limited. I would like to get some opinions from others as to what kind of performance...

Hello, I have an application that will need to store a confidential PIN # (much like an ATM card). I want to store this value encrypted. However, sometimes customers forget their PIN and I need to be able to tell them what it is (after they have passed the authentication process of course)...

The name of the database is usd, and the owner of the tables is also usd. I want to change the owner to ahd (database name does not change). The ahd user does exist. Ric

Here is the code: -- this script uses a cursor to extract the names of all the -- user tables. It then builds an SQL string dynamically to change -- the owner of each of the tables. set nocount on declare c1 cursor dynamic for select [name] from usd.dbo.sysobjects where xtype='U' declare...

Hello, I am running a job that uses a cursor and dynamic sql to change the object owner of all the tables in a database. The problem is that the owner is changed for most of the tables, but not all. This varies with each running of the script. If I run the scipt in Query Analyzer it works...

Hello, I would like to create Excel spreadsheets that contain a bar chart using ASP and the Excel object. I have written the ASP code to connect to the database and run the stored procedure that returns the data. I now want to use the recordset to create the chart and then save the .XLS...