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!

Recent content by mdav2

  1. mdav2

    Record level locking on a table

    Thanks for the ideas I'll do some more reading and take on board what you guys have suggested. I don't have the time to redesign\re-code the system at the moment so I was trying to just do an a like for like change and we will then review it to fit with our new ICT strategy. I'll update this...
  2. mdav2

    Record level locking on a table

    I have a visual foxpro system that I am migrating to a sql server database. The system uses pessimistic record which I would like to replicate with the connections to SQL server. I connect to the database using ODBC authenticating via active directory. The steps of processing that usually...
  3. mdav2

    Regular expression won't work with special characters

    I have a string of text produced from a proprietary system that contains several values that I am interested in. Ideally I would have liked to be able to get this as individual field values however the suppliers say they can't produce this data. Ridiculous, I know but I can't do anything about...
  4. mdav2

    Can I parameterise SQL for checking for the existence a table?

    Many thanks Borislav, i spent ages pulling my hair out on this one, the bit of hair I have. It was trying to accommodate the double single quote that caught me out. Looks like I've learnt my one new thing for today! It also warrants a star. Mark Davies Warwickshire County Council
  5. mdav2

    Can I parameterise SQL for checking for the existence a table?

    I have the code below which I am going to use in the setup of databases. It works but I want to parametrise the database name in the "if exists select * ..." statement. I am very new to SQL Server and have tried to find examples of basic selects using the "EXEC" command with where clauses that...
  6. mdav2

    Using active directory to connect to a database without having to set up an ODBC

    I stripped out some of the unnecessary stuff from the file DSN and got it down to just the following. It was the trusted_connection that made the difference. The parts I removed were the WSID, ID and DESCRIPTION lcDSNLess = "DRIVER=SQL...
  7. mdav2

    Using active directory to connect to a database without having to set up an ODBC

    Cheers Mike, I have looked at that and just tried adding the elements that made sense. I'll try it with all the settings and see if that works. Mark Davies Warwickshire County Council
  8. mdav2

    Using active directory to connect to a database without having to set up an ODBC

    I have a SQL server database that has been set up to be accessed through active directory. To access it I have created a SQL Server ODBC DSN using the wizard in the ODBC manager and can connect with the following code: STORE SQLSTRINGCONNECT('dsn=saw_live') TO gnConnHandle IF gnConnHandle <...
  9. mdav2

    Check password entered by the user is valid in active directory

    Cheers for the responses people. I'll have to find some time to look at this and if I get it working I'll post back what I did and some code. Mark Davies Warwickshire County Council
  10. mdav2

    Check password entered by the user is valid in active directory

    Is there any way to have the user enter a password and check it against their password in active directory? We used to have a library called GPLIB that did this with NOVELL and are looking for something similar. I've looked at the posts referring to windows passwords but these don't seem...
  11. mdav2

    Is there any way to count the number of occurances in a field?

    A simple count and group would sort this unless I am missing something: EG Select status, count(status) from table group by status Mark Davies Warwickshire County Council
  12. mdav2

    Using (IN) command in the where clause from values in form

    Tried that PHV and it works a treat. Mark Davies Warwickshire County Council
  13. mdav2

    Using (IN) command in the where clause from values in form

    Thanks, will check that out and see if I can get it too work. I really do hate access sometimes. Makes easy things very hard to achieve. Mark Davies Warwickshire County Council
  14. mdav2

    Allowing users to select multiple items for use in query

    Database background: ==================== The database is currently split into the data as one database and the forms, queries and reports in another database. Both databases sit on a file server and are used by multiple users. Problem: ======== I want to create a form that allows users to...
  15. mdav2

    Using (IN) command in the where clause from values in form

    I've not written the actual database so was just making the example up based on what it's doing. I have since knocked up a simple example. The code wasn't 100% accurate, I meant it as an example of what it should be the proper query is as below: SELECT inputdata.* FROM inputdata WHERE...
See more

Part and Inventory Search

Back
Top