Search results for query: *

Zemp, Theres a cdonts.dll in c:\winnt\system32 - version 6.0 However SMTP is not installed on the box. I suspect that could that have caused the error ... We'll try installing SMTP next week . Do u agree with that. Thanks John

Hi All, I am using Visual Basic 6 with an app with the following code. Set NewEmail = CreateObject("CDONTS.newmail") The error msg .."Activex Component Cant Create Object" gets trapped I have "CDONTS for 1.2" and ADO 2.7 library checked in References. Any...

Bryan, Thanks for ur feedback ... Im actually not trying to perform a cascading delete .. since I am not deleting the Person first... SQL 2000 does not appear to be behaving properly here ...I know how to fix this anomaly by Nochecking the constraint ... But this behavior does not appear to...

An SQL Server 2000 Foreign Key Constraint Anomaly is occuring. The following tables exist in my database: Person Table Orders Table Pers_id on Orders is a Foreign Key referencing Pers_id on Person Table The following statements are executed in the following order: Delete from Orders where...

I want to upgrade a VB 4 16 bit app to 32 bit VB 4(for starters) But there are a couple in-house written 16 VBX bit custom controls that the app uses. I have the C source code of these controls .. How does one upgrade them to 32 bit OCX .. Is that even possible ... Is all I need 32 bit...

I will be upgrading SQL 6.5 to SQL 2000 .... and concerned there may problems when the latest MDAC (2.6 ?) is applied to the database Server .... There are currently two VB4 apps using SQL 6.5 and one Web app using SQL 7.0 .....The SQL 7 server will also be upgraded to SQL 2000 and the new...

Getting "Report was not exported" using Crystal 7 on a Web system ....when trying to export to RTF ....Exporting to Word doesnt work either.. Excel exporting works ..... Crystal 7 had been installed on several environements and export also fails .... Any ideas would be appreciated...

Is Microsoft's DBLIB-C library compatible with SQL-2000.....is it a valid low-level interface for SQL 2000 as in SQL 6.5 and SWL 7.0 Any feedback is welcome ... Thanks John

Essa ... I tried the exact same code u posted .. and I get 'variable @fcount must be declared' so I declared it outside the string ... when i print the string I get null .... I have to use the IN operator and I don't see another way to do this .... Any more ideas ... Thank u very much John

....... declare @z char(300) declare @list char(30) declare @fcount char(1) set @list = "(10,99999,999999)" set @z = "if exists(select * from titles where royalty in "+@list + ") set " + @fcount + "=1" exec (@z) Any help would be appreciated .. Thank u john

Yes ...That's it ! ... Thanks John

I know there's an MS Word 2000 option for displaying current dlls in memory .. I cannot remember how to access it .... Does anyone have any ideas .. Thanks John

Sorry .......but I need to do a Blinker 1.5 link on a Clipper 5.0 application I inherited ... (All we have is Blinker 1.5 and there's no chance of upgrading ) Can anyone please point me to some old Blinker Documentaion would contain the input parameter definitions etc ..... Thanks John

Using SQL 7.0 How can one tell if a trigger on a table is disabled ... I disabled a trigger but I can't find a system stored procedure that provides info as to whether the trigger is enabled or disabled. Thanks John

I had Found it after poking around Thanks John

Using SQL 7 ... Where on Enterprise Manager can I see the Foreign Keys on a Table .... "All Tasks" shows indexes and triggers but not Foreign Keys I know how to do it using system stored procs, however .... Thanks John

It worked when I finally pointed it to the correct database .....they changed the database name on me so I had to creat another ODBC connection Thanks.... John

Using Crystal reports with Sql Server 7 in a Web Environment ..... A String field is printing only 255 chars when in fact the same field in the Table and Stored procedure behind the report was modified to a length of 500 ... Cant figure out why the entire 500 chars in the field arent being...

...a simple connection to the Pubs database in MSSQL Sever 7 Adodc1.ConnectionString = "Driver=(SQL Server);Server=Myserver; Database=pubs; Uid=username;Pwd=password" Adodc1.RecordSource = "select * from titles" Set Text1.DataSource = Adodc1 Text1.DataField =...

Everyone thank you very much for ur responses .... I'm sure I can handle it from here ... Thanks John