• Create ODBC DSN in C#

    In C#, can I programmatically create a new ODBC DSN? If so, what's the best way? Maybe use P/invoke? Thank you.

    ITKE969,885 pointsBadges:
  • How to export ODBC system DSNs on Windows

    Hello everyone, I'm in major need of help here. I'm on a Windows machine and I need to export my ODBC System DSNs. How can I do that? Has anyone done that before? Any help would be greatly appreciated.

    ITKE969,885 pointsBadges:
  • Connecting ODBC from Python in Windows

    I'm currently using Windows. How can I connect ODBC from Python? Should I use pyodbc for this? If not, what are some other good alternatives? Thanks.

    ITKE969,885 pointsBadges:
  • Error messaging when connecting to DB2 database through JDBC

    I've been trying to connect to our DB2 database through JDBC from Eclipse. I already have the JAR file but I keep getting this error message: Error occurred java.lang.ClassNotFoundException: com.ibm.db2.jcc.DB2Driver Error occurred java.sql.SQLException: No suitable driver found for...

    ITKE969,885 pointsBadges:
  • Connecting .NET to AS/400 using ODBC

    We are connecting .NET to AS/400 using ODBC when we call an SP in AS/400 from .NET, we are getting the null output. What might be the problem.??

    bharathtata30 pointsBadges:
  • Testing DB2 database connection

    I'm trying to test my connection to my DB2 database. Usually with my Oracle databases, I would just run 'SELECT' from dual but I know that's for Oracle only. How can I do this for DB2? Is there a specific SQL statement?

    ITKE969,885 pointsBadges:
  • How can I escape all CRLF chars in all column values when doing a select?

    Let's say I want to do: SELECT * FROM tableName But some columns' values have linebreaks, so in my MySQL console it breaks the formatting of the table. I know I can circumvent this by explicitly REPLACE()ing CLRF chars, but this requires me naming each column and is not very quick to type out, eg.:...

    hazzlewis5 pointsBadges:
  • iSeries DB2 – Have Physical File need to create Logical File to access Member

    I know very little about the iSeries (I can spell it is all). I am working with an ODBC connection to get to DB2 data on the iSeries. Everything is going extremely well other than 2 files that I need to access use members. These are the only ones that do on the entire system. I was told that I...

    mgrady15 pointsBadges:
  • Backup options for DB2 database

    I have a DB2 database that has over 150 GB of data. I'm using the built-in backup option to back it up daily. Here's my issue - it's taking a long time to finish. Is there another backup option I should look into? Thank you.

    ITKE969,885 pointsBadges:
  • Call stored procedures asynchronously on DB2 database

    I'm working on a DB2 database - would I be able to call my stored procedure from another procedure asynchronously? Thanks so much.

    ITKE969,885 pointsBadges:
  • Changing DB2 database column name

    On my DB2 database, I'm trying to rename the column name on one of my tables. How can I do that?

    ITKE969,885 pointsBadges:
  • Dump content from IBM DB2 schema into SQL text file

    For the past few days, I've been trying to dump content from a schema (that's from a IBM DB2 server) into a SQL text file. But I'm running into a dead end. What should I do here? Is there anything like mysqldump for MySQL? Thank you.

    ITKE969,885 pointsBadges:
  • Combine DB2 columns into single timestamp

    Hello all, I have a DB2 database that has two different columns: Date / Time. Can I combine these two columns into one single timestamp? Appreciate the help.

    ITKE969,885 pointsBadges:
  • View table structure of DB2 database

    Hello, can I view my DB2 table structure? What command should I use to do this? Thank you.

    ITKE969,885 pointsBadges:
  • Get current schema on JDBC DB2 connection

    As of today, I have a JDBC DB2 connection. Is there a way for me to get my current schema? Would a SQL statement work for this?

    ITKE969,885 pointsBadges:
  • Modify database line for EMBL format

    LOCUS SCU49845 5028bp DNA PLN 21-JUN-1999. Explain the above line from gene bank database. How would the line be modified so that it can be stored in the EMBL format?

    sourajoy35 pointsBadges:
  • Writing a hidden trigger against a SQL table

    How do I write a hidden trigger against a SQL table?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Where is a SQLite database file located on my Android device?

    I want to find the path to my SQLite database file in my android devices. Can I change the default save location to some other folder like Dropbox?

    hussain22juzer530 pointsBadges:
  • layer 2 & layer 3 switch

    Hi All, what is the basic difference between layer 2 & layer 3 switch. how can configure layer 2 & layer3 managable switch

    Psharma11760 pointsBadges:
  • Storing PDF files in MySQL as BLOBs

    Experts, Can you please help me? I need to store several PDF files into MySQL as BLOBs. How can I do that using PHP? You are the best!

    ITKE969,885 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