Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. gamcall

    Problem creating FK referring to same table

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

    Browser accessing Notes mail gives <applets> not found

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

    Modems on NT Server4 not answering other modems

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

    How to remove setup option at Boot / RAS

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

    How to remove setup option at Boot / RAS

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

    How to remove setup option at Boot / RAS

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

    Suppression of duplicate values in columns

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

    Response.redirect breaking asp pages

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

    Response.redirect breaking asp pages

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

    Simple syntax error.

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

    Simple syntax error.

    ...Info</a></td> <% else %> <td>** n.a **</a></td> <td>** n.a **</a></td> <td>** n.a **</a></td> <% End If %> </tr> <% rsBottomArea.MoveNext Loop%> </table> <%Else%> No orders listed <%End If%> </form> <p> </p> </body> </html> Thanks...
  12. gamcall

    Simple syntax error.

    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: ''...
  13. gamcall

    Triggers not firing.

    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'.
  14. gamcall

    Creating 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
  15. gamcall

    Triggers not firing.

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

    Creating Triggers

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

    Unicode (Japanese char data) conversion to 8-bit

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

    Manner of logins/connections to SQLS 7 in Enterprise Mgr

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

    Manner of logins/connections to SQLS 7 in Enterprise Mgr

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

    Connection is busy with results for another hstmt [ODBC Error]

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

Part and Inventory Search

Back
Top