Recent content by Varco

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