• Testing ODBC entry for Linux to SQL Server connection

    Hello, We have this ODBC entry that we need to test to see if it connects our Linux server to SQL Server. Before this, we need to make sure the entry is configured correctly too. Can anyone points us in the right direction?

    ITKE1,005,525 pointsBadges:
  • Import Microsoft Access database into MySQL

    I'm currently on a Windows machine with a Microsoft Access database. I need to import that into MySQL on another Linux web server. Here's what I'm doing right now: Exported as text file Copied with FTP Loaded into MySQL Is there a better process for this? Any help would be appreciated.

    ITKE1,005,525 pointsBadges:
  • Relational database normal form

    Consider a relation scheme R(A,B,C,D) where A is candidate key. With no information about FDs involved, then R is in which normal form? Is it First Normal form or Second normal form or BCNF or Third normal form?

    Asimb5 pointsBadges:
  • Connection of DSN to SQL Server has stopped working

    My Linux application uses DSNs to connect to our SQL Server. For some reason, the connection has stopped working and I can't find the DSN's credentials. What should I do here?

    ITKE1,005,525 pointsBadges:
  • How to check if a table exists in MySQL server

    Hi, To connect to my MySQL server, I've been using an ODBC connection. Is there a way to check if a table exists in my database? And if it's not there, how can I create one?

    ITKE1,005,525 pointsBadges:
  • 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.

    ITKE1,005,525 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.

    ITKE1,005,525 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.

    ITKE1,005,525 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...

    ITKE1,005,525 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?

    ITKE1,005,525 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.

    ITKE1,005,525 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.

    ITKE1,005,525 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?

    ITKE1,005,525 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.

    ITKE1,005,525 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.

    ITKE1,005,525 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.

    ITKE1,005,525 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?

    ITKE1,005,525 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