|
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
|
|
|
|
|
Does anyone know any good tutorials/references for packaging a windows form application that requires full permissions so that it may be started from a webpage?
What I am looking for is something that will allow me to do the following:
1) User clicks a link
2) Something pops up saying "do you trust this company" or "can this program have full permissions"
3) If permission granted, then the program is run from the user's hard drive with full permissions.
Any help or direction will be greatly appreciated!
-Dethsta
|
|
|
|
|
dethsta wrote:
2) Something pops up saying "do you trust this company" or "can this program have full permissions"
This is not really what CAS (Code Access Security) is about. The whole idea is that people will run something, even if warned not to. The security model is placed solely in the hands of the admin to allow or disallow what code can run from where. The user is not asked.
Paul Watson wrote:
"At the end of the day it is what you produce that counts, not how many doctorates you have on the wall."
George Carlin wrote:
"Don't sweat the petty things, and don't pet the sweaty things."
|
|
|
|
|
I totally agree with you  . . . CAS is definately the way to go when under the supervision of an admin. However, for a home user with minimal knowledge of .NET security . . . I would prefer that the are just prompted for trust, letting me handle the rest. Much like how the Windows Update site works.
I believe this can be done with a signed CAB file and an embedded object in a web page. Does anybody know the pros/cons of this approach and where to find good .NET tutorials on the subject? I am slowly getting closer to a solution.
-Dethsta
|
|
|
|
|
I remember seeing an article about this at:
http://www.sellsbrothers.com/[^]
Don't remember which one but I am sure you can find it while browsing there. It was a fairly indepth article.
Rocky Moore <><
|
|
|
|
|
Hi,
I'm adding some controls on Panel at runtime. This works fine, but after removing this controls, Application can't be closed (and Closing event isn't called). 
Creating controls:
MyControl ctrl=new MyControl();
ar.Add(ctrl);
panel1.Controls.Add(ctrl);
Removing all controls:
panel1.Controls.Clear();
foreach(MyControl ctrl in ar) ctrl.Dispose();
ar.Clear();
When I'm not removing controls it works 
i'm only pointer to myself
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
