Search results for query: *

I found exactly what I needed in thread 222-498611, code provided by Hypetia that worked great. Jim Varco jimv@varcconsulting.com

What is the preferred way to set an inital folder for the SHBrowseForFolder API function? Jim Varco jimv@varcconsulting.com

Zemp, Thanks, this is perfect. Jim Varco jimv@varcconsulting.com

Zemp, Thanks for the code, it worked great to build a list of servers. I was looking to build a list of attached SQL DB's, such as "Master", etc., can you help with that? Jim Varco jimv@varcconsulting.com

Can someone point me to a source for VB code to build a list of currently attached SQL DB's. This would be the same list as shown in ODBC Administrator in the "Change the default database to:" dropdown list for SQL Server connections. Jim Varco jimv@varcconsulting.com

Abelardo & HRoarke, Thanks for the great help! Jim Varco jimv@varcconsulting.com

Abelardo, Thanks for the help. Your suggestions fixed the problem I was having with adNumeric fields. Are there other data types that should be dealt with in a similar manner? Jim Varco jimv@varcconsulting.com

Thanks for the suggestions. Due to some special needs for this project, I need to use a programmatically created disconnected rs. The rs is created by reading and using the attributes of the source rs, so I am puzzled as to why I get the error when copying a numeric field value from one to the...

For use internally to my VB apps I sometimes create disconnectd recordsets, using the column properties of the connected recordset, then copy the desired data. The problem I have is that if the data is anything other than character, I get a "Multiple-step operation generated errors" error when...

Can anyone point me to code to build a list of currently attached SQL databases, using Visual Basic? Thanks Jim Varco jimv@varcconsulting.com

My thanks to both DrJoeJava & johnwm for the help. Got exactly what I need now. Jim Varco jimv@varcconsulting.com

Does anyone know how to delete all of the values under a specific Registry key, leaving any sub keys alone? I have code to delete a Registry key if you know the value name. I may not know the name, I need to loop through all of the values and delete them. Thanks, Jim Varco jimv@varcconsulting.com

I need to do some testing that requires me to be able to use both a DB with a trusted connection and also with SQL Login, not necessarily on the same DB. I am testing using a system running MSDE and am not seeing how to setup a SQL Login with user ID and password. Can anyone point me in the...

SQLBill, Thanks for the help. Yes, I did find the file you referenced, here is the contents: Starting Service ... Connecting to Server ... driver={sql server};server=.;UID=sa;PWD=;database=master [Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network...

I did some testing and found that while I was installing MSDE, all of the appropriate filess and folders were shown as being installed. However, after the error is generated most of the folders and files under MSSQL7 vanish, including the data and binn folders. Jim Varco jimv@varcconsulting.com

After running MSDE without issue for many months, it will no longer connect. I have tried reinstalling it, the install progresses to where it displays the "Starting Service" message and then reports an error. The error is "Setup failed to configure the server. Refer to the server...

I am having trouble removing tables that I no longer need from a report in v9. If I go into Database Expert and have tables "Table1", "Table2", "Table3" listed on the right and select "Table3" to remove it, I always get the first table, "Table1&quot...

Try changing the line that reads: CrystalRpt.ParameterFields.Item("EmpName").AddCurrentValue WrkName To: CrystalRpt.ParameterFields(1).AddCurrentValue WrkName You will need to confirm that this is the first parameter in the report, or change the index to the correct parameter number...

What is the preferred way to create and set environment variables within a VB app? I need a VB app to create & set some environment variables that will then be available to another app executed from within the VB app. After this app closes I want to destroy the environment variables previously...

I have a VB6 app that uses MAPI. Do I need to distribute any MAPI related files, and if so which ones? From time to time I have someone inform me the app is erroring out due to the lack of a MAPI file. Any help will be much appreciated. Thanks, Varco Jim Varco jimv@varcconsulting.com