Results for "Author: leo mrozek"
This is an add-in that I wrote for VB6 when it was first released. The wizard creates a Message Box or Input box and lets you fully select the parameters for your box. See the zip file for the complete project to compile the DLL. Once complied, register the the DLL. Close VB and reopen VB. Go to Add-Ins and open the Add-In manager and check Loaded/Unloaded and Load on Startup. Close the Add-In Manager and the Wizard should be listed on your Add-ins list. There is an included document "MsgWiz.rtf" that explains how to use the program. I originaly released this as shareware and still has a crude copyguard contained within it. To register the wizard to get rid of the nag screen, the code is KXP4410. If you would like to register the code, the information is on the Help/About screen.
These 9 lines of VBSCript code access the OLE DB Service Provider Type Library that is installed with ADO and will build a connection string to ANY database supported by OLE DB. Simply launch the VBScript file enclosed in the attached ZIP file, on the first tab select your Provider (Access, Oracle, SQL Server, etc), Click Next and enter your connection info (login, password, server name, etc), click Test Connection to test connection and when ready, click OK. When OK is clicked it will popup a VB InputBox that has your connection string as the default value in the text box. Simply copy the string and click Cancel to end the script. The original Artical is from the 11th Annual VBPJ Tech-Tips issue and can be found in its entitity at www.vbpj.com in its archives.
This artile shows how to handle the processing of multiple recordsets returned from SQL Server to an ASP page. The result is that some of the ASP Processing is shifted to the SQL Server.
This is an add-in that I wrote for VB6 when it was first released. The wizard creates a Message Box or Input box and lets you fully select the parameters for your box. See the zip file for the complete project to compile the DLL. Once complied, register the the DLL. Close VB and reopen VB. Go to Add-Ins and open the Add-In manager and check Loaded/Unloaded and Load on Startup. Close the Add-In Manager and the Wizard should be listed on your Add-ins list. There is an included document "MsgWiz.rtf" that explains how to use the program. I originaly released this as shareware and still has a crude copyguard contained within it. To register the wizard to get rid of the nag screen, the code is KXP4410. If you would like to register the code, the information is on the Help/About screen.
These 9 lines of VBSCript code access the OLE DB Service Provider Type Library that is installed with ADO and will build a connection string to ANY database supported by OLE DB. Simply launch the VBScript file enclosed in the attached ZIP file, on the first tab select your Provider (Access, Oracle, SQL Server, etc), Click Next and enter your connection info (login, password, server name, etc), click Test Connection to test connection and when ready, click OK. When OK is clicked it will popup a VB InputBox that has your connection string as the default value in the text box. Simply copy the string and click Cancel to end the script. The original Artical is from the 11th Annual VBPJ Tech-Tips issue and can be found in its entitity at www.vbpj.com in its archives.
This artile shows how to handle the processing of multiple recordsets returned from SQL Server to an ASP page. The result is that some of the ASP Processing is shifted to the SQL Server.
This is an add-in that I wrote for VB6 when it was first released. The wizard creates a Message Box or Input box and lets you fully select the parameters for your box. See the zip file for the complete project to compile the DLL. Once complied, register the the DLL. Close VB and reopen VB. Go to Add-Ins and open the Add-In manager and check Loaded/Unloaded and Load on Startup. Close the Add-In Manager and the Wizard should be listed on your Add-ins list. There is an included document "MsgWiz.rtf" that explains how to use the program. I originaly released this as shareware and still has a crude copyguard contained within it. To register the wizard to get rid of the nag screen, the code is KXP4410. If you would like to register the code, the information is on the Help/About screen.
These 9 lines of VBSCript code access the OLE DB Service Provider Type Library that is installed with ADO and will build a connection string to ANY database supported by OLE DB. Simply launch the VBScript file enclosed in the attached ZIP file, on the first tab select your Provider (Access, Oracle, SQL Server, etc), Click Next and enter your connection info (login, password, server name, etc), click Test Connection to test connection and when ready, click OK. When OK is clicked it will popup a VB InputBox that has your connection string as the default value in the text box. Simply copy the string and click Cancel to end the script. The original Artical is from the 11th Annual VBPJ Tech-Tips issue and can be found in its entitity at www.vbpj.com in its archives.
This artile shows how to handle the processing of multiple recordsets returned from SQL Server to an ASP page. The result is that some of the ASP Processing is shifted to the SQL Server.
This is an add-in that I wrote for VB6 when it was first released. The wizard creates a Message Box or Input box and lets you fully select the parameters for your box. See the zip file for the complete project to compile the DLL. Once complied, register the the DLL. Close VB and reopen VB. Go to Add-Ins and open the Add-In manager and check Loaded/Unloaded and Load on Startup. Close the Add-In Manager and the Wizard should be listed on your Add-ins list. There is an included document "MsgWiz.rtf" that explains how to use the program. I originaly released this as shareware and still has a crude copyguard contained within it. To register the wizard to get rid of the nag screen, the code is KXP4410. If you would like to register the code, the information is on the Help/About screen.
These 9 lines of VBSCript code access the OLE DB Service Provider Type Library that is installed with ADO and will build a connection string to ANY database supported by OLE DB. Simply launch the VBScript file enclosed in the attached ZIP file, on the first tab select your Provider (Access, Oracle, SQL Server, etc), Click Next and enter your connection info (login, password, server name, etc), click Test Connection to test connection and when ready, click OK. When OK is clicked it will popup a VB InputBox that has your connection string as the default value in the text box. Simply copy the string and click Cancel to end the script. The original Artical is from the 11th Annual VBPJ Tech-Tips issue and can be found in its entitity at www.vbpj.com in its archives.
This artile shows how to handle the processing of multiple recordsets returned from SQL Server to an ASP page. The result is that some of the ASP Processing is shifted to the SQL Server.
This is an add-in that I wrote for VB6 when it was first released. The wizard creates a Message Box or Input box and lets you fully select the parameters for your box. See the zip file for the complete project to compile the DLL. Once complied, register the the DLL. Close VB and reopen VB. Go to Add-Ins and open the Add-In manager and check Loaded/Unloaded and Load on Startup. Close the Add-In Manager and the Wizard should be listed on your Add-ins list. There is an included document "MsgWiz.rtf" that explains how to use the program. I originaly released this as shareware and still has a crude copyguard contained within it. To register the wizard to get rid of the nag screen, the code is KXP4410. If you would like to register the code, the information is on the Help/About screen.
These 9 lines of VBSCript code access the OLE DB Service Provider Type Library that is installed with ADO and will build a connection string to ANY database supported by OLE DB. Simply launch the VBScript file enclosed in the attached ZIP file, on the first tab select your Provider (Access, Oracle, SQL Server, etc), Click Next and enter your connection info (login, password, server name, etc), click Test Connection to test connection and when ready, click OK. When OK is clicked it will popup a VB InputBox that has your connection string as the default value in the text box. Simply copy the string and click Cancel to end the script. The original Artical is from the 11th Annual VBPJ Tech-Tips issue and can be found in its entitity at www.vbpj.com in its archives.
This artile shows how to handle the processing of multiple recordsets returned from SQL Server to an ASP page. The result is that some of the ASP Processing is shifted to the SQL Server.
This is an add-in that I wrote for VB6 when it was first released. The wizard creates a Message Box or Input box and lets you fully select the parameters for your box. See the zip file for the complete project to compile the DLL. Once complied, register the the DLL. Close VB and reopen VB. Go to Add-Ins and open the Add-In manager and check Loaded/Unloaded and Load on Startup. Close the Add-In Manager and the Wizard should be listed on your Add-ins list. There is an included document "MsgWiz.rtf" that explains how to use the program. I originaly released this as shareware and still has a crude copyguard contained within it. To register the wizard to get rid of the nag screen, the code is KXP4410. If you would like to register the code, the information is on the Help/About screen.
These 9 lines of VBSCript code access the OLE DB Service Provider Type Library that is installed with ADO and will build a connection string to ANY database supported by OLE DB. Simply launch the VBScript file enclosed in the attached ZIP file, on the first tab select your Provider (Access, Oracle, SQL Server, etc), Click Next and enter your connection info (login, password, server name, etc), click Test Connection to test connection and when ready, click OK. When OK is clicked it will popup a VB InputBox that has your connection string as the default value in the text box. Simply copy the string and click Cancel to end the script. The original Artical is from the 11th Annual VBPJ Tech-Tips issue and can be found in its entitity at www.vbpj.com in its archives.
This artile shows how to handle the processing of multiple recordsets returned from SQL Server to an ASP page. The result is that some of the ASP Processing is shifted to the SQL Server.
This is an add-in that I wrote for VB6 when it was first released. The wizard creates a Message Box or Input box and lets you fully select the parameters for your box. See the zip file for the complete project to compile the DLL. Once complied, register the the DLL. Close VB and reopen VB. Go to Add-Ins and open the Add-In manager and check Loaded/Unloaded and Load on Startup. Close the Add-In Manager and the Wizard should be listed on your Add-ins list. There is an included document "MsgWiz.rtf" that explains how to use the program. I originaly released this as shareware and still has a crude copyguard contained within it. To register the wizard to get rid of the nag screen, the code is KXP4410. If you would like to register the code, the information is on the Help/About screen.
These 9 lines of VBSCript code access the OLE DB Service Provider Type Library that is installed with ADO and will build a connection string to ANY database supported by OLE DB. Simply launch the VBScript file enclosed in the attached ZIP file, on the first tab select your Provider (Access, Oracle, SQL Server, etc), Click Next and enter your connection info (login, password, server name, etc), click Test Connection to test connection and when ready, click OK. When OK is clicked it will popup a VB InputBox that has your connection string as the default value in the text box. Simply copy the string and click Cancel to end the script. The original Artical is from the 11th Annual VBPJ Tech-Tips issue and can be found in its entitity at www.vbpj.com in its archives.