How to update ODBC database in Microsoft Excel

For our ODBC database, can I directly update it through Microsoft Excel? I'm able to view the tables on it but I need to modify some data. How can I do that?

ITKE1,067,645 pointsBadges:

Log queries from SQL Server or ODBC

Would I be able to trace or log queries that my application sends to SQL Server through our ODBC driver? Does ODBC have some sort of query logging? If there's another way, please let me know.

ITKE1,067,645 pointsBadges:

Transfer data from SQL Server to Microsoft Access

Hello, we need to move a large amount of data from a SQL Server database to a Microsoft Access database. The table structure is already setup. Is there anything from SQL I can use for the migration? Or do I have to use a ODBC data source? Thanks.

ITKE1,067,645 pointsBadges:

Connect iOS application to Sybase database using ODBC

I'm pretty new to mobile development (particular iOS). I need to make our new application connect to a Sybase database. I'm thinking of using ODBC. Does anyone know how to do this? Is there any documentation on this?

ITKE1,067,645 pointsBadges:

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,067,645 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,067,645 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,067,645 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,067,645 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,067,645 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,067,645 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,067,645 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,067,645 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,067,645 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,067,645 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,067,645 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,067,645 pointsBadges: