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

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

Hello, I am looking for a learning reference, preferably on the 'Net, that will help me learn how to use ActiveX with DTS. I have looked in BOL but their coverage is somewhat skimpy. Thanks everyone! Ric

Hello, I have a form that contains a select list. As the user scrolls through or mouses over the options in the list I would like to trap the event but I don't know what event applies. I tried the onBlur and onChange events but this did not work. My eventual goal is to use the event to change...