Date field update using SQL

I need to add 2 years to a date field using SQL.

pugsgma10 pointsBadges:

Error message when executing SQL query through PowerPivot

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.

ITKE1,067,485 pointsBadges:

Java code is not closing JBoss database connection

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?

ITKE1,067,485 pointsBadges:

How do AS/400 stored procedures get output?

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...

bharathtata30 pointsBadges:

Synon tool in AS/400

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.

aswinisynon5 pointsBadges:

What are web transaction logs?

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?

kensoft30 pointsBadges:

Fix Microsoft printer error 2147500037

How can I fix MS error 2147500037?

Thedunes2115 pointsBadges:

Attach remote SQL database

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.

ITKE1,067,485 pointsBadges:

Connect DBI to MySQL database without password

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.

ITKE1,067,485 pointsBadges:

Importing SQLite database into Eclipse IDE

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.

ITKE1,067,485 pointsBadges:

Cannot expand the folder

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...

Justblessed5 pointsBadges:

Check SQL Server current connection pool size

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.

ITKE1,067,485 pointsBadges:

Enabling database logging on ASP.NET app

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).

ITKE1,067,485 pointsBadges:

Check dropped MySQL database connections

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...

ITKE1,067,485 pointsBadges:

Create a LF based on a particular member in a multimember PF

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?

ITKE1,067,485 pointsBadges:

SQLRPGLE: Not able to load data into subfile

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.

ravula755 pointsBadges:

Count SQLite database open connections

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.

ITKE1,067,485 pointsBadges:

Uploading CSV file data into MySQL database automatically

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?

ITKE1,067,485 pointsBadges:

Difference between SCSI and iSCSI

What's the difference between SCSI and iSCSI?

sathishpandian5 pointsBadges:

HP LTO Cartridge compatibility with HP Tape drive matrix

I need to know the HP LTO Cartridge compatibility with HP Tape drive matrix for HP MSL2024 tape library.

Kantipatil5 pointsBadges: