Questions & Answers
Active Directory, AS/400, Backup, Business Intelligence, Career Development, CIO, CRM, Data Management, Database, DataCenter, Development, Hardware, IBM DB2, IBM iSeries, IT Strategy, Linux, Lotus Domino, Lotus Notes, Microsoft Access, Microsoft Excel, Microsoft Exchange, Microsoft Exchange 2003, Microsoft Exchange 2007, Microsoft Outlook, Microsoft Outlook 2003, Microsoft Outlook 2007, Microsoft Windows, Microsoft Windows 7, Microsoft Windows Server 2003, Microsoft Windows XP, Mobile, Networking, Oracle, Routers, RPG, RPGLE, SAP, Security, Servers, SQL, SQL Server, SQL Server 2005, Storage, Virtualization, Visual Basic, VoIP, VPN, Windows 10, Windows Server, Windows Server 2008 ...VIEW ALL TAGS
- Business Intelligence
- Career Development
- Cloud Computing
- Content Management
- Data Management
- Desktop Management
- Email Administration
- IT Strategy
- Lotus Domino
- Microsoft Exchange
- Microsoft Windows
I need to add 2 years to a date field using SQL.
For the past several hours, I've been trying to execute my SQL query through PowerPivot but I keep getting this error message: "Unable to convert a value to the data type requested for table (massive hex string) column (name)". Then I tried SSMS and it worked fine. What's causing the issue? Thanks.
We noticed that somewhere in our Java code, it's opening a DB connection but not closing it. It's pretty difficult to debug since it's a huge batch process. This is on JBoss. How can we find out which part of the code is not closing it?
I have created a CL which calls an RPG program. Now I have to create a stored procedure which calls the CL! As RPG normally sends back the output to CL! How should I send back the output to SP? Will SP normally pick it or is there any command to send back the output to stored procedure (SP). I have...
What is Synon? If I learn Synon, how will be my future? Is it good to learn Synon as a fresher.? Approximately how many clients would be using Synon.
What are Web transaction logs, and how do they work in combination with registration forms, shopping cart databases, cookies, and Web bugs to help firms understand how customers behave online?
How can I fix MS error 2147500037?
I have a SQL database that's stored on a remote server. Would I be able to attach it in SSMS? I tried to map it with a drive but that's not showing up as an option.
In DBI, I'm trying to connect to our MySQL database as a user without a password. Is that possible? Basically - I just want to grant access to myself without having to put in a password.
My friend and I are creating an Android app and just installed SQLite too. The database has already been created (with several tables). Now - here's where we are stuck. How can we import that database into Eclipse IDE? Thanks.
My manager gave me edit rights to her inbox & calendar and I received an email stating she gave me these permissions. I went into my account settings to add her to my mail folders and when I click on her name, I get the "Cannot Expand the Folder error." I have the same permissions for two other...
Hello, How can my team check the connection pool size in SQL Server? We just need the current size. Is there a query for us to do this? Thanks so much.
Can I enable database logging inside of my ASP.NET app? This is on Visual Studio / SQL Server 2008 and we're trying to see the database activity between the app and the database (particularly the logging).
One of our clients uses PHP to connect to MySQL. Now, for security reasons, both the PHP scripts / MySQL DB are on two different Linux servers. Now, they're saying that the database connections keep dropping out / timed out. Is there a way to see in MySQL if that's true? We already checked the...
Hi, How can I create a LF using crtlf command based on a particular member in a multimember PF? Where I have to specify the member name?
Loaded the data into subfile with SQLRPGLE - prepare statement and cursor and now if I go back and again tried to load back, not able to load the data to the subfile.
On my SQLite database - would I be able to count the open connections? Is there an API to do this? If not, what's the process? Thank you.
Would I be able to upload my data, that's in a CSV file, into a MySQL database automatically? I need this because the database has to get updated from a path folder. Can anyone help?
What's the difference between SCSI and iSCSI?
I need to know the HP LTO Cartridge compatibility with HP Tape drive matrix for HP MSL2024 tape library.