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!

  • Congratulations Mike Lewis 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: *

  • Users: jadn
  • Order by date
  1. jadn

    How to toggle "Init" or "PaperFeed" pin on LPT port

    Hi, I need to toggle some pin (not a data signal) on an LPT port - but I can't write to an IO register to do it. Normal LPT ports have registers that can be used to control the port, but I have a USB to DB25 adapter which provides an LPT port but doesn't have a base-register (that I...
  2. jadn

    MS Access to invoke stored procedure that's located on an SQL Server

    follow-up: Looking at DNGs reply (again) made me think "If only I could run this command on the remote server"... ...well I'm sure the answer is obvious to most of you Acces gurus, but I guess you didn't notice this thread or feel like replying... I found joy following the MSAccess help for...
  3. jadn

    "'(unknown)' is not a valid path" but DSN is an SQL Server!

    Hi MrDenny, Thanks for your reply. While replying-back to you, I ran a few tests to be accurate. Well, to make a long story short, I found the problem. A previous incarnation of my program had left a DSN with the same name under USER DSN. It was only visible when logged-in as that...
  4. jadn

    "'(unknown)' is not a valid path" but DSN is an SQL Server!

    Hi, I wrote some code which is installed and working on the WXP dev. station and several W2K workstations. In the code an ODBC connection is made to DSN=RemoteDB;UID=;PWD=; (this through ADODB) "RemoteDB" is a System datasource (to an SQL Server) and the test panel works. However, on...
  5. jadn

    Routing and NAT (NOT) with WRT54GL & BEFSR41

    Hi Folks, I'm not network savy. If something here sounds way off-base, it probably is - please set me straight! I need to test a network device which has three ethernet ports - each with a unique IP address. The 3 IP addresses are always the same (say) 192.168.1.1, 192.168.2.1...
  6. jadn

    MS Access to invoke stored procedure that's located on an SQL Server

    Hi DNG, Thanks for the reply, but it's the "something like" part I'm a little fuzzy on. ;^) I tried your [TSQL?] "EXEC [ODBC; ..." and received the error: "Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE','SELECT', or 'UPDATE'" It seems MS Access queries are very...
  7. jadn

    MS Access to invoke stored procedure that's located on an SQL Server

    Hello! Is it possible for MS Access to invoke a stored procedure which is located on an SQL Server? The following MS Access query returns the "Tests" table (located on the SQL Server): SELECT * FROM [ODBC;Driver={SQL Server};Server=111.111.111.111;Database=MYDB;UID=MYUID;PWD=MYPW;].Tests...
  8. jadn

    how to view/edit numeric column in hexadecimal format

    Cool! Will keep my ears-open for possibility to upgrade to SQL 2005. Much Obliged!
  9. jadn

    how to view/edit numeric column in hexadecimal format

    Hi Cat, I'm no stranger to exponential-notation - just whining! ;^) In order to convert "1e3" to 1000, some string-parsing/entry-validation is going on behind the scenes - so the opportunity is there (at some level) for interpreting numeric-column entries in other numeric bases besides Decimal...
  10. jadn

    how to view/edit numeric column in hexadecimal format

    Thanks Cat. I'd have thought that when entering a value, the UI could have parsed a number entered as "b01101", or "xFF", or "d123" (of course I tried this first.) After-all, the UI figures-out a number entered as "1E3" ok! Oh-well, maybe seperate byte columns are "better-form" than one...
  11. jadn

    how to view/edit numeric column in hexadecimal format

    Hello, Sorry for this trivial question - hope I chose right forum... I'm manually editing a database/table in the "Sql Server Enterprise Manager". One of the columns is "int" type. This int is used bit-wise and it would be very helpful to view/edit column data in a hexadecimal format...
  12. jadn

    Can I use NT Authentication with server running as "System Account"

    Hi maswien, I added a [Local]"MyReadGroup" to the server, then added "MyReadGroup" as a Login in SQL Server. After adding a specific user, "myUser", to MyReadGroup, then myUser can connect. If I remove myUser from MyReadGroup, and add "MyDomain\Domain Users", then myUser can no-longer...
  13. jadn

    Can I use NT Authentication with server running as "System Account"

    Hi maswien, Thanks for the reply. When you say "add domain users to their group", do you mean to add users individually? Is it possible to grant permission to all "MyDomain" users without having to specify each specific user? Thanks!
  14. jadn

    Can I use NT Authentication with server running as "System Account"

    Hi, I'd like to use NT Authentication to allow Domain Users to connect (via ODBC connections) to an SQL Server (2000). The server is running under "System account". When adding myself as a Login on the server, I can connect from a client. I've also added a "MYDOMAIN\Domain User"...
  15. jadn

    [externally] invoking a user-defined function

    ... Apparently this is not, even theoretically, possible via ADODB. If anyone here knows otherwise, please reply! To quote another thread at www.egghead.com: " Sorry, Stefen, the ability to use user-defined VBA functions in a query is a feature provided by Access, and is therefore not...
  16. jadn

    [externally] invoking a user-defined function

    Hello, I wrote a Function ("funcFlush") and a Query ("qryFlush") that simply calls "funcFlush". If qryFlush is run in the Access IDE, the Function runs, but when I use ADODB to call the query, an error is returned 'undefined function "funcFlush" in expression'. Why would this...
  17. jadn

    So many object libraries to know, so little time

    Hi (again), Co-worker showed me how to call Functions from a Query. Don't need MS Access app. automation to run a Query! Problem solved.
  18. jadn

    So many object libraries to know, so little time

    Hi, I'm trying to write an application that needs to tell MS Access to run a Subroutine. I'm performing queries through ADODB, but it seems the only way to invoke a Subroutine is by using ADO "Microsoft Access x.x Object Library" (please tell me I'm wrong!). My program is supposed...
  19. jadn

    user-defined select criteria

    Hi folks, Thanks for all the replys. It's nice to know I was on the right track, and the WHERE-clause code will jump-start the stored-procedure work (TY Bob!). Thanks, too, for the security-heads-up related to SQL embedded in parameters (I like to think I write sturdy code, but that...
  20. jadn

    user-defined select criteria

    Hi, This seems like such a simple/common need that I'm reluctant to ask, but I just don't see a good generic solution for constructing an SQL query-string. The user will supply "QQuery" fields which will select records from "Tests". I don't know which fields the user will supply...

Part and Inventory Search

Back
Top