Search results for query: *

Good day I am trying to use the MS documented property of "Jet OLEDB:Connection Control" to limit connections to an Access database. However in Delphi there is a compiler error that the property is read only. This is the line of code : adoconnection1.properties['Jet...

Good day Does anybody know how to install the Crystal Report Dev Edition VCL on Delphi 6? Thanks in advance Yuben

I am using Delphi5 Professional. It does not come with ADO Express installed. Where can I get this? Thanks in advance.

I would like to access a shared folder on my network(peer to peer) from within VB. The folder is password protected on a Win98 machine. I know the password and can access the folder using explorer, but how do I do it using VB and the FileSystemObject(is there an alternative?). Your help is...

Thanks guys. It was not the cable. It seems that the drive was damaged when I removed it. The worst was that I tried another drive with the same problem. It was only on the third drive that I did not receive the error. Thanks for your help again.

I have a 3.5" and a 5.25" drive connected to a Pentium I machine. I removed the floppy drive, rebooted the machine to do some stuff. When I reintstalled the 5.25" floppy I get a floppy failure on boot-up. When I change the BIOS settings from 1.2MB to 360K the drive works fine...

I want to provide one mailbox for all users logging onto a W2K Pro machine i.e. all the users on the machine must be able to see the same mail items. However when each user logs on only the mail that was sent/received by that user is shown. All the users use the same mail account. I have...

Good Day I need to monitor a specific folder and run some code when a new file appears there. Is there an API that I could use to monitor the file system - preferably something that triggers an event when a new file is placed in the monitored folder. I currently monitor the folder using the...

I would like to create a report from within VB. i have defined a report variable as CRAXDDT.Report and assigned a report to it. I use the report designer within VB. I would like to assign a report by name to the report variable. I have tried this: set MyReport =...

You can do it using a "Pessimistic" lock type. However, this will only lock the table being updated and not the database.

thanks a million for your help.

the format is ISNULL(value,replacement value). this will substitute the 'value' with the 'replacement value' if value is null. e.g. ISNULL(Column1,0) will substitute null values in column1 with the value 0.

Check that the accounts for SQL Aagent and Server in Services. Make sure that they are what you think they are. Also check the name of the profile when you are testing - sometimes the name is cutoff. Also, there are some articles on the MS SQL Server website specific to Outlook and Messenger...

How do I embed an IF statement within a SELECT statement? I want to select values from a table using a view or stored procedure but one of the columns values must be based on the value of another column e.g. col1 col2 col3 1 10 12 2 15 13 3 20 14 4 25 15 SELECT...

Instead of trying to figure out why the DTS wizard is not working, which could take days, export your access table from within access to a textfile, excel file or some other file that the DTS also recognises. Then use the DTS to import the file. If you try long enough you may figure out what's...

Thanks for your help - makes sense. However I discovered be chance that it was my lan dns setting for internet access that was causing the problem - strange!

You can also try to change the default date format of SQL server from the enterprise manager : Rightclick on the server, select properties. Select server settings. Change the default language for user to British english (dd/mm/yy). SQL installs with 'English' as the default language which I...

You do not need to povide a value for an autoincrement field. A possible stored procedure statement would be: create procedure InsertTest @val1 integer, @val2 varchar(6), @val3 integer as insert SomeTable (Field2,field3,field4) values (@val2,@val3,@val4) The design of SomeTable: Field1...

I had a similar problem when I was passing a date value to a stored procedure from VB. Try cconverting your parameter value/s to a string and then passing it. This worked fine for me. Note : SQL must be able to convert the string value back to the data type required for this to work.

I am trying to connect to a SQL Server 7.0 database (SP2) running on Windows 2000 professional from a client machine running Windows 98. When I try to connect through the ODBC setup wizard I get a timeout error on the first try. If I try again immediately I can connect. If I try again after...