Search results for query: *

Although your new video card uses it's own memory, it still requires more processor power than your old 4MB card. You are a little shy on processor power in my opinion to get the full benefit of your new card. I would try all of the lowest settings on the card and see if you get better...

edfair is probably correct as new mobos probably have been sitting around in the wharehouse for a while. But I would first test the battery if you have a tester, or take it to Radio Shack and have them test it. Also, before you do that use an eraser and clean the contact that holds the memory...

Hi: I am also trying to use the MS JDBC driver and am getting an exception with error message being the driver itself "com.microsoft.jdbc.sqlserver.SQLServerDriver" Here is the code I use to simply try and install the driver // Establish a connection to a SQL database using JDBC...

What operating system and if not Windows 2000, which version of DOS. Joe Logan Joseph Logan jlogan@softsource.net

The code needed to get the data directly into the variable is as follows Dim MyDatabase As ADODB.Database Dim MyRecordset As ADODB.Recordset Set MyDatabase = New ADODB.Recordset Set MyRecordset = New ADODB.Recordset MyDatabase.Open COnnectionString Set MyRecordset = MyDatabase dim...

The solution of breaking up your delete architecture is really the only way to go here. We had the exact same issue and we had tried everything within SQL Server to try and eliminate the TempDB Fillup. It is important to run the query analyzer and "watch" the tempDB closely. You...

First place a data control on your form. By default this is visible. Then click on a DatabaseName in the properties view. You can either enter the pathname, or browse to find the database that you want to connect to. You will now be connected when you load the form. To view the contents of...

Hi: Do you mean establishing a connection using an Active X user VB control? Joseph Logan jlogan@softsource.net

I use VB5 at work and VB6 at home for consultant gigs. There really isn't enough in way of benefits in VB6 to invest the extra money. The differences are fairly minor, although the ability to look into databases while debugging is a big advantage. Other differences are minor, such as the...

Hi: Below is the function I use to cover the entire screen with my form or whatever. I know it seems iverkill, but you need to do it this we to make it work across platforms. First you need to declare the following: Private Const SM_CXSCREEN = 0 Private Const SM_CYSCREEN = 1 Private Const...

Hi Michael: Can I see the actual code? I remember having a simlar problem and recall that it had to do with the syntax for the addnew or something. Thanks Joe Logan Joseph Logan jlogan@softsource.net

The error your getting simply means that one or more fields you are inserting/updating contain an invalid value (such as a string for a numeric field. I'm not sure what your field data types are but there is a mismatch somewhere for sure. Step through the code with the watch window showing the...

Hi: Do you have any error handling going on? If you have error handling, it is possible that the sub in the module is erroring out, thereby causing the code to drop to the error handler in the first form. If not, Try changing the sub to a function which returns a value telling you whether or...

Try the following dbcc checktable (syslogs) dump tran <database name> with no_log dbcc checktable (syslogs) dbcc perflog This seemas to work when all else fails!! Joseph Logan Softsource, Inc. Software Engineer jlogan@softsource.net

Did you ever find the reason for your create object error? I have the same problem... Joseph Logan Softsource, Inc. Software Engineer jlogan@softsource.net

This will sound crazy and I have no explanation for it. I had the exact same problem running Windows 2000 Server. I had 128Mb RAM and upgraded to 384Mb. After that, it worked fine. When I removed the extra RAM, it went back to freezing. Not sure if this will help or not since I can't see...

I wouldn't even try it. I even had problems with 128Mb installed on a server. I couldn't get the Active Directory going. I couldn't even go on the internet from the server for more than 5 minutes. It was also drudgingly slow. Once I upgraded to 256, it went fine. Joseph Logan Softsource...

From the above comments it should be clear that using long variable names is OK to do. Moreover, it is reccomended since someone debugging later will have a better chance of figuring out what is going on. The only issue has to do with spelling errors. When using long variable names, it may...