Search results for query: *

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

Hello all, I opened the performance monitor on our server today and all the SQLServer counters are missing. This is the first time I have tried this on this server. It was installed some time ago by someone else (who is not here anymore) so I don't have a lot of details about the the...

I tried to create a new DTS package on my development server(via Enterprise Manager) and I received an error message saying that it could not find mdt2fw.dll I checked my production server (which does not have the DTS problem) and I copied this .dll from prod to dev in the appropriate folder...

Hello, I recently tried to create a new DTS package on my development server and I received a message the file mdt2fw.dll was missing. I checked and it was not on the server. I then checked production and the file was there so I copied it over to developement. Now when I try to create a new...

I actually tried that but it turned out to be too error-prone. That is why I was thinking of trying to find some way to scrub the file before the import.

I need to import a .csv file into a table. The file however is not straight forward. It is divided into sections, each section has a 4-line header. The first line is a series of dash characters, the second is a long string that describes the contents of that section of the report and the...