Questions & Answers

  • 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,000,495 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,000,495 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,000,495 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,000,495 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,000,495 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,000,495 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,000,495 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,000,495 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,000,495 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,000,495 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,000,495 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:
  • Connecting MySQL database to another computer

    I recently created a MySQL database and it's using localhost as the host. Now I need a co-worker to do some testing but I'm not sure how we can connect to it from another machine. This is also on Windows 7.

    ITKE1,000,495 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following