Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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!

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

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

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

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.

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

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

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