|
|
Perfect! thank you very much!
-- LuisR
──────────────
Luis Alonso Ramos
Chihuahua, Mexico
www.luisalonsoramos.com
"Do not worry about your difficulties in mathematics, I assure you that mine are greater." -- Albert Einstein
|
|
|
|
|
Can anyone please recommend a book on Systems Analysis and Design? I have searched Amzon.com but found too many books and all were rated XXXXXX.
Jassim Rahma
|
|
|
|
|
|
I used StringFormat.Alignment and StringFormat.LineAlignment but nothing has changed What is in GDI+ similer with Win32 SDK DT_CENTER or DT_CENTER ?
Thanx
|
|
|
|
|
Hi,
Why I'm getting the following error when trying to connect to AS400 DB2?
RDB name not found or RDB does not match Remote LU name. Driver's SQLSetConnectAttr failed.
Test connection failed because of an error initializing provider. RDB name does not match. Remote LU name. SQLSTATE HY000 - 360
I have also attached the configuration....
Jassim Rahma
|
|
|
|
|
Have you installed DB2 Drivers etc on your machine properly. After that, the following connection strings should work:
For OLEDB:
Provider=IBMDADB2;Database=deepakdb;hostname=deepakdbsrv; port=50000;protocol=TCPIP;uid=dbuser; pwd=dbuser
For ODBC:
Driver=IBM DB2 ODBC Driver;Database=deepakdb;hostname=deepakdbsrv; port=50000;protocol=TCPIP;uid=dbuser; pwd=dbuser
But for ODBC and C#, you need to have Microsoft ODBC.NET Provider to be installed on the machine.
I am connecting to a DB2 on RS/6000 AIX Server with the above connection string and hence the above modus operandi should apply in your environment too.
Deepak Kumar Vasudevan
http://deepak.portland.co.uk/
|
|
|
|
|
I tried the OLE DB parameters you provided here but getting the following error:
The 'IBMDADB2' provider is not registered on the local machine.
I have already installed Microsoft Host Integration Server (HIS) on this machine and I'm able to connect using the 5250 Client.
Let us assume that I have the following information about my AS400 database:
User Id: JASSIM
Password: JSM999
Host IP Address: 152.458.526.458
Database: P325PXT
Library: EMOLIB
How can I connect to it?
Seems that you are an expert and I really need your help on this...
Many Thanks,
Jassim Rahma
|
|
|
|
|
Hi,
Seems that you are not using IBM Driver for DB2 and you are using Microsoft Supplied Driver for DB2. The driver I was mentioning in my reply would be installed when you install IBM DB2 Client and Application Development Tools on the machine.
Since you are using the driver from Microsoft, which comes as part of the Host Integration Server (HIS), you might have a different connection string.
Did u check the connectionstring syntax and other attributes with this URL:
http://www.connectionstrings.com/
Did this solve your query?
Deepak Kumar Vasudevan
http://deepak.portland.co.uk/
|
|
|
|
|
If I didn't install it, where can I get it on the web? can I download it from somewhere?
Jassim Rahma
|
|
|
|
|
|
sorry for asking too many silly questions but because I never used the .NET to access DB2 objects...
I have download the IBM provider and I'm not getting the registration error any more but getting other error (don't have it now) saying database not found.
I'm sure about the database name but I have not entered the library. I will tell you what information I have and can you tell me how to connect to it please.
User Id: JASSIM
Password: JSM999
Host IP Address: 152.458.526.458
Database: P325PXT
Library: EMOLIB
When I login using 5250 I get the system name as LIBRA (this is my system name based in UK) but all connections are based on IP.
Many Thanks,
Jassim Rahma
|
|
|
|
|
Hi!
With IBM DB2 Driver, you have some cool tools with which you can check out and manage your databases. You need to create a database alias and you can use the following tool to use Db2 Tools
Start -> Programs -> IBM Db2 -> Client Configuration Assistant
(You may elect Search the network for the wizard to identify your DB2 Server. But that normally doesn't work over the Internet. Hence you may like to choose 'Manually Configure' option)
Once this is done you can proceed with using DB2 Client Tools. But regarding the connection string. Did u use the pattern like this:
Provider=IBMDADB2;Database=yourdbname;hostname=databaseservername; port=dbinstanceport;protocol=TCPIP;uid=dbloginname; pwd=dbpassword
This should help you get connected to the database.
Deepak Kumar Vasudevan
http://deepak.portland.co.uk/
|
|
|
|
|
Hi,
Thank you very much for your help... I managed to connect to DB2 using your code.
I have question now, how can get more information about the DB2 database file (object), date last modified, file size, user last updated, etc?
Many Thanks,
Jassim Rahma
Jassim Rahma
|
|
|
|
|
Can someone please give me a regular expression that I can use with the split() method to delimit the a string such as the one that follows into 20 separate fields. It is comma-quote delimited, however nulls are not quoted (,,) and it is possible to have commas inside a quoted value ("1,2,7,7,8-PECDD"). Thanks...David
"42679","A106037#2","-9999","BL0414WJ","BL0414WJLB1","Laboratory Blank","DIOXINS/FURANS (GHK)","04/14/2000","04/19/2000","pg/l","1,2,7,7,8-PECDD","40321-76-4","6.016","6.016","U",,,"NO","YES"
David
|
|
|
|
|
,?"(?<value>.*?)"|,?(?<value>.*?)
This will let you extract the values as named groups, but will not work as a split separator.
I see dumb people
|
|
|
|
|
Daniel Turini wrote:
,?"(?<value>.*?)"|,?(?<value>.*?)
I have just added CodeProject support to your regexp :
,?"(?<value>.*?)"|,?(? <value>.*?)
|
|
|
|
|
Oh, I just love regex, it's an art form. Here's a regex which can validate (it's not mine, I found it on the web):
1. All valid dates from 1/1/0001 to 31/12/9999
2. Correctly validates leap years
3. It's valid for the regex classes on .NET framework
^(?: (?: (? ?[13578]|1[02])(\/|-)31)|(?: (? ?[1,3-9]|1[0-2])(\/|-)(?:29|30)))(\/|-)(?:[1-9]\d\d\d|\d[1-9]\d\d|\d\d[1-9]\d|\d\d\d[1-9])$|^(?: (? ?[1-9]|1[0-2])(\/|-)(? ?[1-9]|1\d|2[0-8]))(\/|-)(?:[1-9]\d\d\d|\d[1-9]\d\d|\d\d[1-9]\d|\d\d\d[1-9])$|^(0?2(\/|-)29)(\/|-)(?: (? [48]00|[13579][26]00|[2468][048]00)|(?:\d\d)?(? [48]|[2468][048]|[13579][26]))$
Remove all the spaces from it, I've added some to bypass the emoticons.
I see dumb people
|
|
|
|
|
Who needs MSIL obfuscation when you've got RegExp. Of course, the trouble is you obfuscate your code to yourself
|
|
|
|
|
Was not sure what form this would belong to but since I code exclusively in C# nowadays and they will be written in C#, I thought I would try here.
What is the best way to send/receive binary data (like images or files) with web services? Just simply pass as a parameter or is there a better way?
Rocky Moore <><
|
|
|
|
|
Perhaps have a look at DIME[^].
"Direct Internet Message Encapsulation (DIME) is a lightweight, binary message format that can be used to encapsulate one or more application-defined payloads of arbitrary type and size into a single message construct."
Cheers,
Simon
"The day I swan around in expensive suits is the day I hope someone puts a bullet in my head.", Chris Carter.
my svg article
|
|
|
|
|
sorry about the title...its a little long
i have a quick question reguarding a program im working on. it is a simple text editor...(not much more complicated then notpad) its fine but the question is how do i add support for opening files. I.E when you double click a .TXT file notepad automaticly loads and load the contents of that file too the text field... how can i accomplish this ? if i was unable to explain this clear enough leave a post and ill try my best to clearify... thanks alot for your time
Jesse M
p.s im not talking about using a openFile dialog
file associations with command line args ?
|
|
|
|
|
You can get at your commandline arguments using Environment.GetCommandLineArgs()
To register your program for a shell operation during install you need to add a reference to it in the registry key HKEY_CLASSES_ROOT\txtfile\shell. Have a look at what's already in there for some clues.
Paul
Pleasently caving in, I come undone - Queens of the Stone Age, No One Knows
|
|
|
|
|
i got the command lines too work...but is there a exsample of how i can load the selected files txt/rtf into my textfield.. how can i find the selected files location (atleast then i can tell the program too load it).. ill be looking around =) thanks for awnser my question on command line arguments
|
|
|
|
|
Hello,
I have one tab Control on a form. After adding a tab page to the tab control it is compiling but, I am getting the following error.
Code generation for property 'Controls' failed. Error was object reference not set to an instance of object. when i double click on the error it is showing code section of form.
Please help,
Chito
|
|
|
|