linux - How can I use PHP to connect to ODBC to DB2 on Windows 2003? -


my old server:
- windows 2003 server
- ibm db2 udb version 8.1
- odbc: user dsn:

my odbc connection


there .net webapps connect mydb using odbc, now.

but windows 2003 end of support microsoft on month. so, want move it.

the problem: don't know .net @ all. current .net webapps closed source , cannot contact provider company (it defunct).

i want tables db2 php (running in ubuntu 14.04 desktop). use pdo odbc connect. seems on skills. desktop on same subnet lan windows 2003 server (ping , ok), telnet server2003 ip port 5000 ok.

i stuck after install odbc, config in desktop... nothing works.

who helps me? every appreciated. there no words show appreciation!

in addition configuring , troubleshooting php access db2 via pdo odbc, need migrate db2 8.1 server , clients, if any, newer db2 release level (ibm ended support db2 udb 8.1 in may 2009). fortunately, ibm offers no-cost version of db2 called express-c, authorized production use. current release, db2 express-c 10.5 fix pack 5, can accommodate databases 15 terabytes in size.

if turns out company has active db2 license available application, forget express-c , install whatever db2 server edition covered license.

to move data out of db2 udb 8.1, you'll need export contents of each table separate file , import them new database. db2move utility can assist process iterating through tables in database, saving typing export statements yourself.

once db2 data migrated new database, can install db2 client on linux php server , test connectivity. keep file size down, ibm offers variety of db2 client downloads, can add confusion 1 need. odbc , php applications, should download ibm data server driver package or, safe, larger ibm data server client contains drivers , client libraries. sure client download same version , fix pack level db2 server (e.g. 10.5 fix pack 5).

ibm's online documentation , php manual have bit of information connecting php applications db2.


-

Comments

Post a Comment

Popular posts from this blog

round image using picasso in android -

provide url's regarding , xml code this,it having errors in image view phase package com.example.circularimageview; import android.content.context; import android.content.res.typedarray; import android.graphics.bitmap; import android.graphics.bitmapshader; import android.graphics.canvas; import android.graphics.color; import android.graphics.colorfilter; import android.graphics.matrix; import android.graphics.paint; import android.graphics.rectf; import android.graphics.shader; import android.graphics.drawable.bitmapdrawable; import android.graphics.drawable.colordrawable; import android.graphics.drawable.drawable; import android.net.uri; import android.support.annotation.colorres; import android.support.annotation.drawableres; import android.util.attributeset; import android.widget.imageview; public class circleimageview extends imageview { private static final scaletype scale_type = scaletype.center_crop; private static final bitmap.config bitmap_conf
Read more

OpenCV OpenCL: Convert Mat to Bitmap in JNI Layer for Android -

there several posts converting mat bitmap using utils.mattobitmap() function. i'm assuming function can called in java layer after importing utils class. i want transfer data memory address pointed uint32_t* bmpcontent; in code below. jniexport void jnicall java_com_nod_nodcv_nodcvactivity_runfilter( jnienv *env, jclass clazz, jobject outbmp, jbytearray indata, jint width, jint height, jint choice, jint filter) { int outsz = width*height; int insz = outsz + outsz/2; androidbitmapinfo bmpinfo; if (androidbitmap_getinfo(env, outbmp, &bmpinfo) < 0) { throwjavaexception(env,"gaussianblur","error retrieving bitmap meta data"); return; } if (bmpinfo.format != android_bitmap_format_rgba_8888) { throwjavaexception(env,"gaussianblur","expecting rgba_8888 format"); return; } uint32_t* bmpcontent; if (androidbitmap_lockpixels(env, outbmp,(void**)&bmpcontent)
Read more

python - How to remove the Xframe Options header in django? -

i have made page has iframe . inside iframe want show multiple different links article facebook, or news, or youtube video or other possible url. but, due xframe header, unable so. referred following link: https://docs.djangoproject.com/en/1.8/ref/clickjacking/ , django xframeoptionsmiddleware (x-frame-options) - allow iframe client ip but didn't help. my settings.py file's middleware_classes is: middleware_classes = ( 'django.contrib.sessions.middleware.sessionmiddleware', 'django.middleware.common.commonmiddleware', 'django.middleware.csrf.csrfviewmiddleware', 'django.contrib.auth.middleware.authenticationmiddleware', 'django.contrib.auth.middleware.sessionauthenticationmiddleware', 'django.contrib.messages.middleware.messagemiddleware', 'django.middleware.clickjacking.xframeoptionsmiddleware', ) from http://django-secure.readthedocs.org/en/latest/middleware.html , found using
Read more