Search results for query: *

Hi, When I try & do this (in SQLServer v7 sp3): alter table tblCountry add constraint FK_tblCountry_tblCountry FOREIGN KEY (ship_to_country) references tblCountry (countryky) I get the following error: Server: Msg 547, Level 16, State 1, Line 1 ALTER TABLE statement conflicted with COLUMN...

Hi, I'm running Domino Server 5 on NT Server 4 (SP6). I'm trying to provide access to user's mail via a web browser. I currently can log in to notes via the client, but on doing so, certain screen elements are not rendered in the browser & when the cursor is passed over them return messages...

Hi, I've had a couple of 56kbps modems installed on COM2 on an NT Server4 machine. (I don't think it matters, but the models are a Maestro Jetstream V90 Voice external & a 3Com US Robotics 56K Fax/EXT). Both install OK & are instantly recognized by Remote Access Server (RAS). Both will answer...

Ok - I've looked at the boot.ini file & yes, it seems I can now remove the (non-default) boot option of WinNT 4 Server setup. I don't want to do this if I'm leaving the system in some kind of unresolved state. Should I run setup? If I do, can I kind of do it in a non-destructive or do nothing...

Didn't have the guts to edit boot.ini directly, instead used a config interface to select default startup OS. Then did as you advised above & RAS is now happily back on the system, thanks :) Only problem is that NT Server 4 Set-up is still an option at boot-time & I don't want it to be. How do I...

Hi All, I wanted to re-install RAS on NT Server 4 (Service Pack 6) & so ran Windows NT 4 Set-up from the CD (thinking it would give me software (re-)install options. To my horror, it seemed to be just doing the stuff for a system re-install & now, after exiting Set-up, I find an extra...

Hi there, I've got a query which returns a result set like this: ColA ColB ColC ColD A1 B1 C1 D1 A1 B1 C2 D2 A1 B1 C3 D3 A2 B2 C4 D4 ie, multiple values of cols C & D for a value of A & B (which are 1 to 1). I want a...

Well, thanks to all who responded. I've noted your responses for the future, but the problem was fixed by the reinstallation of IIS. Go figure... Regards, GAM

Hi All, Whenever I have a page that invokes another via response.redirect I get a "HTTP 500 - Internal Server Error" from our web server (IIS III on Win2000). Any ideas? T.I.A GAM

Hi again, Well, I have found the error. I lied about the fact that rsTopArea was being set properly. This in conjunction with the (just discovered) fact that the VBScript does not use short-circuit evaluation of Boolean expressions meant that the second half of the expression was having...

OK - you asked for it. I was trying to avoid (obviously) posting the whole shebang, but here it is... <%@ LANGUAGE=&quot;VBSCRIPT&quot; %> <!--#include file=&quot;adovbs.inc&quot; --> <!--#include file=&quot;OrderTrackingSubs.inc&quot; --> <!--#include file=&quot;QueryBuilding.inc&quot; --> <%...

Hi All, I'm quite new to ASP & have a (probably) simple ASP syntax error. The code is: ... <% If blnFromRS AND rsTopArea.RecordCount > 1 then%> ... to which the VBScript compiler responds: Error Type: Microsoft VBScript runtime (0x800A01A8) Object required: ''...

This is what I get when I try that statement: Server: Msg 170, Level 15, State 1, Line 204 Line 204: Incorrect syntax near 'TRIGGERS'.

Just what _exactly_ are you trying to do? What table do you want to detect the update/insert on & then which table do you want to insert/update? At the moment, it looks as 'tho the answer to both is cube control, & that doesn't make sense to me. Sorry, I need a bit more clarification. GAM

Hi, I had created a whole set of triggers which controlled the data entered into a system. I had tested them with T-SQL statements in a test database & they seemed to work fine. I've since dropped all of them & recreated some of them in the test db & one in the prod database. None seem to...

Christine, For a start, I'd get the declarations done before anything else - that's just good programming. Also, I thought that &quot;if update&quot; only applied (specifically)to a field, 'tho I'm not sure. Also, you said you wanted an insert into cube_control table, but your insert...

Hi, We have some Japanese characters stored in Unicode format. Does anyone have any idea how we would get them converted to 8-bit for display in a Web page? Navigator apparantly can't handle Unicode, at the moment. T.I.A, GAM

To clarify, we are using sql-server ID security with SQL Enterprise Manager. Whether this uses ODBC or not, I don't know. We _don't_ want to use NT authentication. We would like the user to be prompted _once_ for a login & then not subsequently. This seems to be possible for RapidSQL, but not...

Hi, At the moment, we seem to have only 2 ways of connecting to SQL Server 7 (running on NT 4): 1 - We log in with no password supplied & then have to supply a password each time we wish to do anything in any of the databases. 2 - We log in with password already supplied & don't have to...

Well, the problem has been solved by a helpful developer/support person for our Financials Package. He said those 3 little words; &quot;SET NOCOUNT ON&quot;. Context is: CREATE TRIGGER <trig name> ON <table> FOR <UPDATE,INSERT,DELETE> AS SET NOCOUNT ON blah, blah, blah Hope this helps some...