i upgraded my vb6 database from sql 2000 to sql 2005 server.The same vb code is not working.What changes should i make in the code sothat it can work in sql 2005??
You’ll want to change out to using the SQL 2005 OLE driver. All the T/SQL code should work fine. At a prior company we had a VB6 application which was using a SQL 2000 database. We upgraded to SQL 2005 with no problem. We were using about 98% stored procedures. What errors are you getting, [...]
View Answer
| July 8, 2008 8:09 AM
Software maintenance, SQL Server 2000, SQL Server 2005, SQL Server upgrades, VB, Visual Basic 6
You’ll want to change out to using the SQL 2005 OLE driver. All the T/SQL code should work fine. At a prior company we had a VB6 application which was using a SQL 2000 database. We upgraded to SQL 2005 with no problem. We were using about 98% stored procedures. What errors are you getting, [...]
View Answer
| July 8, 2008 8:09 AM
Software maintenance, SQL Server 2000, SQL Server 2005, SQL Server upgrades, VB, Visual Basic 6
How to count all the unique users for Domains from all NAB groups.
Among the nearly infinite numbers of doing this, here are some ideas. Create a copy of the view “Groups.” Call the new view “Group Members Full”. Delete all the columns except the Group column. Add a new Categorized column before Group. Call that column “Name.” Choose the field Members as the contents for the column. [...]
View Answer
| July 7, 2008 2:30 PM
Application development, Developing secure applications, Lotus, Lotus Domino, NAB
Among the nearly infinite numbers of doing this, here are some ideas. Create a copy of the view “Groups.” Call the new view “Group Members Full”. Delete all the columns except the Group column. Add a new Categorized column before Group. Call that column “Name.” Choose the field Members as the contents for the column. [...]
View Answer
| July 7, 2008 2:30 PM
Application development, Developing secure applications, Lotus, Lotus Domino, NAB
Intercept the Paste command in VB.NET
Try adding the function to the OnChange event or the MouseClick event (I think that both exist).
View Answer
| July 6, 2008 8:09 PM
Development, VB.NET, Visual Basic .NET
Try adding the function to the OnChange event or the MouseClick event (I think that both exist).
View Answer
| July 6, 2008 8:09 PM
Development, VB.NET, Visual Basic .NET
Recording cell value changes to another cell in excel using a macro
Thank you for visiting ITKE. We are happy to help you with solving specific IT questions, but need as much information as possible to do so. Let us know about the problem you are trying to solve, how you are approaching it and what work you’ve done so far, and we can help guide you [...]
View Answer
| May 14, 2013 10:31 AM
Excel 2003, Excel macros
Thank you for visiting ITKE. We are happy to help you with solving specific IT questions, but need as much information as possible to do so. Let us know about the problem you are trying to solve, how you are approaching it and what work you’ve done so far, and we can help guide you [...]
View Answer
| May 14, 2013 10:31 AM
Excel 2003, Excel macros
How to call a COBOL program from Java
Hi, I’m not a java person and it’s been mnay years since I’ve used COBOL, so maybe I’m stating the obvious here, but if the user doesn’t select CANCEL, then you should do a COMMIT to apply your changes. I’m also assuming that your data files are journalled as necessary to work correctly within the [...]
View Answer
| July 4, 2008 12:03 PM
COBOL, Java, Web services
Hi, I’m not a java person and it’s been mnay years since I’ve used COBOL, so maybe I’m stating the obvious here, but if the user doesn’t select CANCEL, then you should do a COMMIT to apply your changes. I’m also assuming that your data files are journalled as necessary to work correctly within the [...]
View Answer
| July 4, 2008 12:03 PM
COBOL, Java, Web services
Linked Servers????
Check out a product called Spiceworks….works great for me and includes a help desk…. From Ritchie1: the linked server idea should required the least amount of work on your part if the data is already stored in a sql server database. There is no need to write an application to parse it etc then put [...]
View Answer
| July 4, 2008 9:46 AM
Database, Enterprise Manager, Linked servers, SQL, Windows Server, Windows Server 2003
Check out a product called Spiceworks….works great for me and includes a help desk…. From Ritchie1: the linked server idea should required the least amount of work on your part if the data is already stored in a sql server database. There is no need to write an application to parse it etc then put [...]
View Answer
| July 4, 2008 9:46 AM
Database, Enterprise Manager, Linked servers, SQL, Windows Server, Windows Server 2003
Creating and importing data into a relational database
Start with getting your all your requirements laid out. After you have them, you can start dealing with your database design. You may want to see if your group has someone with some more design experience as it sounds like your database design may be rather complex. This probably isn’t the best database to be [...]
View Answer
| July 4, 2008 9:30 AM
C#, Microsoft Excel, Relational database management software
Start with getting your all your requirements laid out. After you have them, you can start dealing with your database design. You may want to see if your group has someone with some more design experience as it sounds like your database design may be rather complex. This probably isn’t the best database to be [...]
View Answer
| July 4, 2008 9:30 AM
C#, Microsoft Excel, Relational database management software
Concentrate more than two fields together into one field in SQL
SQL Server doesn’t have the STRIP and CONCATINATION functions which were mentioned in the prior version of the answer. You use the + sign to join the strings together, something like this. <pre>SELECT FirstName + ', ' + CASE WHEN MiddleName IS NULL THEN '' ELSE MiddleName + ', ' END + LastName FROM YourTable</pre> [...]
View Answer
| April 19, 2013 9:06 AM
Concatenate, CSV, SQL, SQL Server
SQL Server doesn’t have the STRIP and CONCATINATION functions which were mentioned in the prior version of the answer. You use the + sign to join the strings together, something like this. <pre>SELECT FirstName + ', ' + CASE WHEN MiddleName IS NULL THEN '' ELSE MiddleName + ', ' END + LastName FROM YourTable</pre> [...]
View Answer
| April 19, 2013 9:06 AM
Concatenate, CSV, SQL, SQL Server
Mainframe COBOL – The OVERFLOW Condition.
I believe there is an ON SIZE ERROR option which allows the application to do a function, such as DISPLAY ……. I think you need to specify this in the source code – and unfortunately, the only way to implement this is to search/add this option to your source code. You might want to look [...]
View Answer
| July 3, 2008 2:45 PM
COBOL, Error handling, Programming Languages, z/OS
I believe there is an ON SIZE ERROR option which allows the application to do a function, such as DISPLAY ……. I think you need to specify this in the source code – and unfortunately, the only way to implement this is to search/add this option to your source code. You might want to look [...]
View Answer
| July 3, 2008 2:45 PM
COBOL, Error handling, Programming Languages, z/OS
Is SAP generates any signal for outside application(Such as visual Basic) after generating Picking List (MB26) ?
there are multiple ways to generate a signal for a non-SAP application, or to interact directly with a non SAP application. BAPI / BADi can be used to communicate directly from an external program (usually, but not limited to a C variant) and an SAP structure of Function. This is a to and fro type [...]
View Answer
| July 3, 2008 3:52 AM
Picking List, SAP, Visual Basic
there are multiple ways to generate a signal for a non-SAP application, or to interact directly with a non SAP application. BAPI / BADi can be used to communicate directly from an external program (usually, but not limited to a C variant) and an SAP structure of Function. This is a to and fro type [...]
View Answer
| July 3, 2008 3:52 AM
Picking List, SAP, Visual Basic
Javascript calendar display works fine in IE7 & FF, but not in Opera.
This only took a couple of min. to track down, so ignore the other members’ non-answers. They shouldn’t get points for that. There seems to be a bug in Opera (might be fixed in 9.5) when using the Date constructor with 0: <pre>var lastDate = new Date(String(monthNum+1)+”/0/”+String(yearNum));</pre> In FF and IE this sets the date [...]
View Answer
| July 2, 2008 8:27 PM
Calendar, firefox, IE7, JavaScript, Opera, Web development
This only took a couple of min. to track down, so ignore the other members’ non-answers. They shouldn’t get points for that. There seems to be a bug in Opera (might be fixed in 9.5) when using the Date constructor with 0: <pre>var lastDate = new Date(String(monthNum+1)+”/0/”+String(yearNum));</pre> In FF and IE this sets the date [...]
View Answer
| July 2, 2008 8:27 PM
Calendar, firefox, IE7, JavaScript, Opera, Web development
Including a primary key in a nonclustered index in SQL Server 2005
Yes, it is perfectly fine to include the primary key as a column within an index.
View Answer
| July 2, 2008 8:01 PM
Index, Primary keys, SQL performance, SQL Server 2005
Yes, it is perfectly fine to include the primary key as a column within an index.
View Answer
| July 2, 2008 8:01 PM
Index, Primary keys, SQL performance, SQL Server 2005
Looking for a database name query in SQL
If you run the following query on SQL Server it will tell you the name of the database you are in. <pre>SELECT db_name()</pre> As fr as I know there is no code that can be run on both SQL Server and Oracle to find out what platform you are connected to.
View Answer
| July 2, 2008 7:59 PM
Database, Query, SQL, SQL Query, SQL Server
If you run the following query on SQL Server it will tell you the name of the database you are in. <pre>SELECT db_name()</pre> As fr as I know there is no code that can be run on both SQL Server and Oracle to find out what platform you are connected to.
View Answer
| July 2, 2008 7:59 PM
Database, Query, SQL, SQL Query, SQL Server
SSL blocked on WiFi card
Hi, Robanglin This could be a problem with changed firewall settings on your wireless access point/wireless router BR, Petko
View Answer
| July 2, 2008 4:18 PM
802.11, Cisco VPN, Dell Inspiron 300M, HTTPS, Port 443, SSL, TrueMobile 1300, Wi-Fi, Windows XP, Wireless PC cards
Hi, Robanglin This could be a problem with changed firewall settings on your wireless access point/wireless router BR, Petko
View Answer
| July 2, 2008 4:18 PM
802.11, Cisco VPN, Dell Inspiron 300M, HTTPS, Port 443, SSL, TrueMobile 1300, Wi-Fi, Windows XP, Wireless PC cards
SAP Security outside in
hi, i don’t know much about VB… but its UNBELIVEABLE that all the users in your company are using SAP_ALL. the risks to this, is simply unquantifiable… if a VB application is connecting to your SAP system to view information, like you said, there has to be an RFC connection between both systems, in which [...]
View Answer
| July 2, 2008 1:45 PM
SAP, SAP security, Security Program Management, VB, Visual Basic
hi, i don’t know much about VB… but its UNBELIVEABLE that all the users in your company are using SAP_ALL. the risks to this, is simply unquantifiable… if a VB application is connecting to your SAP system to view information, like you said, there has to be an RFC connection between both systems, in which [...]
View Answer
| July 2, 2008 1:45 PM
SAP, SAP security, Security Program Management, VB, Visual Basic
Exporting stored procedure results into an XML file in SQL Server
In your SELECT statement add the FOR XML AUTO command to the end of the statement. <pre>ALTER PROCEDURE YourProcedureName AS SELECT * FROM Table FOR XML AUTO GO</pre> You can then use SSIS, sqlcmd (osql if SQL 2000) or BCP to export the data to a file.
View Answer
| July 2, 2008 6:37 AM
SQL Server, Stored Procedures, XML
In your SELECT statement add the FOR XML AUTO command to the end of the statement. <pre>ALTER PROCEDURE YourProcedureName AS SELECT * FROM Table FOR XML AUTO GO</pre> You can then use SSIS, sqlcmd (osql if SQL 2000) or BCP to export the data to a file.
View Answer
| July 2, 2008 6:37 AM
SQL Server, Stored Procedures, XML
Copy past in excel using VB
Hi Krishna, Use this code. It will help you Sheet1.Columns(“G:G”).Cut Sheet1.Columns(“B:B”).Select ActiveSheet.Paste Regards, Nitheen Rao T 09881154349 Try putting this code in the Macro. <pre>range(“B1″).value = “” range(“B1″).value = range(“H1″).value range(“H1″).value = “”</pre> Then put a value in the H1 field and run the macro.
View Answer
| July 2, 2008 6:22 AM
Excel macros, Microsoft Excel, VB, VBA, Visual Basic for Applications
Hi Krishna, Use this code. It will help you Sheet1.Columns(“G:G”).Cut Sheet1.Columns(“B:B”).Select ActiveSheet.Paste Regards, Nitheen Rao T 09881154349 Try putting this code in the Macro. <pre>range(“B1″).value = “” range(“B1″).value = range(“H1″).value range(“H1″).value = “”</pre> Then put a value in the H1 field and run the macro.
View Answer
| July 2, 2008 6:22 AM
Excel macros, Microsoft Excel, VB, VBA, Visual Basic for Applications
remote access in C#
I found the answer myself. If someone has the same problem, you need to add <identity impersonate=”true”/> in your web.config. Then if you use directoryinfo to open a remot folder which is located on a server, a pop-up windows will come up and ask for the username and password to connect to the folder.
View Answer
| July 1, 2008 3:15 PM
C#, Remote access
I found the answer myself. If someone has the same problem, you need to add <identity impersonate=”true”/> in your web.config. Then if you use directoryinfo to open a remot folder which is located on a server, a pop-up windows will come up and ask for the username and password to connect to the folder.
View Answer
| July 1, 2008 3:15 PM
C#, Remote access
Google and Yahoo are adding search capabilities for flash files
Hi, What’s the question? Or is this just a comment or statement about this news? Regards, Martin Gilbert. I forgot to ask whether this will change the scenario of current SEO industry? Does SEO expert have to take an extra efforts to develop a SEO strategy? What will be the long term effects of this? [...]
View Answer
| July 1, 2008 12:27 PM
Adobe, Flash, Google, SEO, Web development, Yahoo
Hi, What’s the question? Or is this just a comment or statement about this news? Regards, Martin Gilbert. I forgot to ask whether this will change the scenario of current SEO industry? Does SEO expert have to take an extra efforts to develop a SEO strategy? What will be the long term effects of this? [...]
View Answer
| July 1, 2008 12:27 PM
Adobe, Flash, Google, SEO, Web development, Yahoo
How do I create a web based application in SQL Server?
SQL Server 2005 is a database product, it uses tools that are web-based, such as ‘Reporting Services’ which are really programs running on IIS which is a web-server. The .Net languages you can write in SQL Server 2005 is an alternative to SQL you can’t use it to do anything other than data manipulation or [...]
View Answer
| July 1, 2008 8:14 AM
.NET, C#, SQL Server 2005, VB.NET
SQL Server 2005 is a database product, it uses tools that are web-based, such as ‘Reporting Services’ which are really programs running on IIS which is a web-server. The .Net languages you can write in SQL Server 2005 is an alternative to SQL you can’t use it to do anything other than data manipulation or [...]
View Answer
| July 1, 2008 8:14 AM
.NET, C#, SQL Server 2005, VB.NET
