Posts

How to add an IBM DB2 server to SQL Server's Linked Server -

-
from .net, i'm able connect db2 database: first include reference "ibm.data.db2.iseries" then create new ibm.data.db2.iseries.idb2connection. connection string is datasource=chadb2server;userid=myusername;password=mypassword; then create ibm.data.db2.iseries.idb2command, , on. now i'm trying sql server 2005 access same data directly. in sql server management studio, right-click on linked servers, , select "new linked server..." linked server: chadb2server provider: ibm ole db provider db2 product name: ??? data source: chadb2server provider string: datasource=chadb2server;userid=myusername;password=mypassword; location: ??? i can leave location blank, product name can't empty , don't know fill in here. on security tab, select "be made using security context" , repeat userid , password. the linked server gets created, when try expand catalogs / default / tables, error message: ole db provider ...
Post a Comment
Read more

perl - Downloading or requesting a page using a proxy list? -

-
i wondering if possible request internet page server via proxy taken proxy list. i don't know exact terms, i'll explain want: there feature in website counts ips or alike (perhaps cookies), such visitors counter. i'd "fool" "entering" page using many proxies. use tor, that's work - want visit page, let counter or whatever in page know visited, , that's all. i don't know tags add, had little experiments perl think direction, although couldn't find solution problem. thank in advance. you want this: #/usr/bin/perl use strict; use warnings; use lwp::useragent; $url = shift || 'http://www.google.com'; $a = lwp::useragent->new; $a->agent('mozilla/5.0'); $a->timeout(20); while (<data>) { $a->proxy( ['http'], $_ ); warn "failed page proxy $_\n" unless $a->get( $url )->is_success; } __data__ http://85.214.142.3:8080 http://109.230.245.167:80 http://211.222.20...
Post a Comment
Read more

Bizarre HTML problem. Inspector view different from source -

-
Image
i'm having strange problem inspector showing head content in body while source normal. causing this? this looks you've missed closing <head> -tag. maybe it's <head>…<head> in html.
Post a Comment
Read more

c# - Problem with ADO.NET UPDATE code -

-
could take quick peek @ ado.net code? trying update row dataset, isn't working. missing elemental piece of code, , eluding me. have verified datarow has correct data in it, row accurate. many in advance. try { //basic ado.net objects sqldataadapter dbadapter = null; dataset returnds2 = new dataset(); //a new sql connection sqlconnection myconn = new sqlconnection(); myconn.connectionstring = "server=myserver.mydomain.com;" + "database=mydatabase;" + "user id=myuserid;" + "password=mypassword;" + "trusted_connection=true;"; //the sqlquery string sqlquery = "select * avlupdatemessages id = 21"; //another ado.net object command sqlcommand cmd = new sqlcommand(...
Post a Comment
Read more

passing string in a query to MySQL database in MATLAB -

-
i using mysql matlab, , want name user, , pass table in mysql, rejecting variable name in place of string var_name=input('enter name:'); mysql('insert table (name) values (var_name)'); any suggestions? i believe problem having same 1 in this other question . sounds want create command string contains ' delimited string, require escape each ' ' when create command string (note first example in this string handling documentation ). note may want use 's' option input function: var_name = input('enter name: ','s'); %# treats input string commandstring = sprintf('insert table (name) values (''%s'')', var_name); %# note 2 apostrophes --^ mysql(commandstring); if enter ken input, string commandstring contain following: insert table (name) values ('ken') and of course, others have mentioned, beware injection vulnerabilities .
Post a Comment
Read more

wix - How do you add data containing a tab in a custom table -

-
when there tabs in custom table data compilation error occurs, if compiler thinks tab attempting create column. i have tried actual tab, xml escaped tab (&#x9;), , msi escaping tab ([{tab}], {tab} actual tab) example: <data column="">testing 1,2,3</data> in between 'testing' , '1,2,3' tab. the error is: custom table column '1,2,3' unknown. you can't -- data imported .msi package via tab-delimited file. see "archive file format" in msi sdk. if field can binary, can import file's content, can anything.
Post a Comment
Read more

android - Text does not ellipsize -

-
i have textview set ellipsize when put text in doesn't so. ideas? <textview android:id="@+id/legalsview" android:ellipsize="end" android:layout_width="wrap_content" android:layout_height="wrap_content" android:textappearance="?android:attr/textappearancemedium" /> try: android:singleline="true"
Post a Comment
Read more