I'm using ibm streams 4.2 in centos 6 . I'm trying to use the operator odbcappend to insert the tuples from the file source to a table in my sql db. So I'm trying to connect ibm streams to my sql db. However, I'm using xampp php my admin for my sql. I tried so many ways for the connection but it doesn't work.
Related Questions in DATABASE
- When dealing with databases, does adding a different table when we can use a simple hash a good thing?
- How to not load all database records in my TListbox in Firemonkey Delphi XE8
- microsoft odbc driver manager data source name not found and no default driver specified
- Cloud Connection with Java Window application
- Automatic background scan if user edit column?
- Jmeter JDBC Connection Configuration Parametrization of Database URL for accessing SQL Database
- How to grant privileges to current user
- MySQL: Insert a new row at a specific primary key, or alternately, bump all subsequent rows down?
- Inserting and returning autoidentity in SQLite3
- Architecture: Multiple Mongo databases+connections vs multiple collections with Express
Related Questions in CONNECTION
- How would I be able to use a file in visual studio project on any computer?
- Connection was not closed. Connection's current state is open
- Android check WIFI status (disconnected or user changed WIFI)
- How to include the current user's path on a file?
- DB2, Hibernate, JPA: Schema does not exist
- I get 530 access denied in ftp connection after some upgrade in my internet connection
- Java telnet connection to request new tor identity
- Why did my application stop connecting using HTTP, and how can I debug it?
- C# send data to remote server
- Apache Server (xampp) doesn't run on Windows 10 (Port 80)
Related Questions in IBM-STREAMS
- How can I get IBM Streams toolkit update?
- how could resolved "CDISP0092E ERROR: Because of previous compilation errors, the compile process cannot continue."?
- Restoring the insternally queued messages in while stopping streams application
- difference between threadedport and parallel annotation in ibm infosphere streams
- How to import an image to IBM Streams?
- How do we process two different input streams on onTuple of Custom() Operator of IBM InfoSphere Streams?
- When are InfoSphere Streams consistent regions merged into one?
- Video files are not opening for sample applications in Info Sphere Streams
- Ibm streams connection with mysql database
- XML Parse operator throws error when working with large XML file in IBM Streams
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Popular Tags
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
I did a little digging and found this post which leads me to believe that xampp does not use one of the tested ODBC drivers for the toolkit: xampp post: How to enable odbc in XAMPP linux Tested ODBC drivers for mysql:
If your mySQL distribution uses the MySQL ODBC Connector then use that or you can download UnixODBC to use with the toolkit.
Otherwise you should use STREAMS_ADAPTERS_ODBC_UNIX_OTHER and setup the other variables to point to the driver that is already installed. You should be sucessful to the extent that the ODBC implementation matches the syntax of the tested drivers. From the docs:
https://www.ibm.com/support/knowledgecenter/SSCRJU_4.2.0/com.ibm.streams.toolkits.doc/spldoc/dita/tk$com.ibm.streams.db/tk$com.ibm.streams.db$1.html