I'm having some trouble being able to connect to my db2 server (it lives on
an os/2 warp 3 connect box) from my Windows2000 workstation using vs.net
2003. Any suggestions?
I have a local user account on the server "readonly", i have created a user
in the database of "readonly" and I can connect through the command line,
but from within visual studio .net 2003 I cannot make a connection. Better
stated: I can make a connection but I cannot create data adapters - I can't
get any data from that connection.
I can see it in my server explorer, I can browse the tables and fields, but
as soon as i try to drag some fields onto my form it asks for my username
and password, which I enter, and then I get the following error:
"ERROR [08004][IBM][CLI Driver]SQL1403N The username and/or password
supplied is incorrect.
SQLSTATE=08004
ERROR [IM006][Microsoft][ODBC Driver Manager]Driver's SQLSetConnectAttr
failed."
I'm going crazy - what am i doing wrong? 4 3903
"Development at American Savings" <de*@americansavingslife.com> wrote in
message news:10************@corp.supernews.com... I'm having some trouble being able to connect to my db2 server (it lives
on an os/2 warp 3 connect box) from my Windows2000 workstation using vs.net 2003. Any suggestions?
AFAIK, this is not a supported combination; in any case, I would not expect
it to work. To start with, DB2 for OS/2 does not support ODBC V3 or later;
DB2's ODBC support is frozen at V2.5,. That at a minumum should be
sufficient to cause your second "error" (server doesn't support ODBC API).
You will need to use an API that is supported by DB2 for OS/2 V7.1, such as
native CLI. That means, ADO.NET is out. Alternatively, since DB2 for OS/2 is
frozen, it may be time to consider transitioning away from OS/2 to a
platform with DB2 V8 support, including support for the client API you wish
to use (see http://www.ibm.com/software/os/warp/strategy/). I have a local user account on the server "readonly", i have created a
user in the database of "readonly" and I can connect through the command line, but from within visual studio .net 2003 I cannot make a connection.
Better stated: I can make a connection but I cannot create data adapters - I
can't get any data from that connection.
I can see it in my server explorer, I can browse the tables and fields,
but as soon as i try to drag some fields onto my form it asks for my username and password, which I enter, and then I get the following error: "ERROR [08004][IBM][CLI Driver]SQL1403N The username and/or password supplied is incorrect. SQLSTATE=08004
ERROR [IM006][Microsoft][ODBC Driver Manager]Driver's SQLSetConnectAttr failed."
I'm going crazy - what am i doing wrong?
Isn't there some second opinion - some way to make it work??? Any types of
workarounds or anything?
"Mark Yudkin" <my***********************@nospam.org> wrote in message
news:c8**********@ngspool-d02.news.aol.com... "Development at American Savings" <de*@americansavingslife.com> wrote in message news:10************@corp.supernews.com... I'm having some trouble being able to connect to my db2 server (it lives on an os/2 warp 3 connect box) from my Windows2000 workstation using vs.net 2003. Any suggestions?
AFAIK, this is not a supported combination; in any case, I would not
expect it to work. To start with, DB2 for OS/2 does not support ODBC V3 or later; DB2's ODBC support is frozen at V2.5,. That at a minumum should be sufficient to cause your second "error" (server doesn't support ODBC API).
You will need to use an API that is supported by DB2 for OS/2 V7.1, such
as native CLI. That means, ADO.NET is out. Alternatively, since DB2 for OS/2
is frozen, it may be time to consider transitioning away from OS/2 to a platform with DB2 V8 support, including support for the client API you
wish to use (see http://www.ibm.com/software/os/warp/strategy/).
I have a local user account on the server "readonly", i have created a
user in the database of "readonly" and I can connect through the command
line, but from within visual studio .net 2003 I cannot make a connection. Better stated: I can make a connection but I cannot create data adapters - I can't get any data from that connection.
I can see it in my server explorer, I can browse the tables and fields, but as soon as i try to drag some fields onto my form it asks for my
username and password, which I enter, and then I get the following error: "ERROR [08004][IBM][CLI Driver]SQL1403N The username and/or password supplied is incorrect. SQLSTATE=08004
ERROR [IM006][Microsoft][ODBC Driver Manager]Driver's SQLSetConnectAttr failed."
I'm going crazy - what am i doing wrong?
Will the the IBM DD2 documentation serve as confirmation?
"The DB2 .NET Data Provider allows your .NET applications to access Version
8 DB2 Universal Database on Windows, UNIX, and Linux-based computers, and
Version 6 and Version 7 of DB2 Universal Database for OS/390 and z/OS via
DB2 Connect. "
You are using none of these servers
Full details are in the Application Development section of Concept, under
APIs - Windows - DB2 .NET.
The only "workaround" is to use a supported API. This means you cannot use
an API not supported by your DB2 for OS/2 V7 server.
"Development at American Savings" <de*@americansavingslife.com> wrote in
message news:10*************@corp.supernews.com... Isn't there some second opinion - some way to make it work??? Any types
of workarounds or anything?
"Mark Yudkin" <my***********************@nospam.org> wrote in message news:c8**********@ngspool-d02.news.aol.com... "Development at American Savings" <de*@americansavingslife.com> wrote in message news:10************@corp.supernews.com... I'm having some trouble being able to connect to my db2 server (it
lives on an os/2 warp 3 connect box) from my Windows2000 workstation using
vs.net 2003. Any suggestions?
AFAIK, this is not a supported combination; in any case, I would not expect it to work. To start with, DB2 for OS/2 does not support ODBC V3 or
later; DB2's ODBC support is frozen at V2.5,. That at a minumum should be sufficient to cause your second "error" (server doesn't support ODBC
API). You will need to use an API that is supported by DB2 for OS/2 V7.1, such as native CLI. That means, ADO.NET is out. Alternatively, since DB2 for
OS/2 is frozen, it may be time to consider transitioning away from OS/2 to a platform with DB2 V8 support, including support for the client API you wish to use (see http://www.ibm.com/software/os/warp/strategy/).
I have a local user account on the server "readonly", i have created a
user in the database of "readonly" and I can connect through the command line, but from within visual studio .net 2003 I cannot make a connection. Better stated: I can make a connection but I cannot create data adapters - I can't get any data from that connection.
I can see it in my server explorer, I can browse the tables and
fields, but as soon as i try to drag some fields onto my form it asks for my username and password, which I enter, and then I get the following error: "ERROR [08004][IBM][CLI Driver]SQL1403N The username and/or password supplied is incorrect. SQLSTATE=08004
ERROR [IM006][Microsoft][ODBC Driver Manager]Driver's
SQLSetConnectAttr failed."
I'm going crazy - what am i doing wrong?
Fair enough. I sure appreciate your help.
"Mark Yudkin" <my***********************@nospam.org> wrote in message
news:c8**********@ngspool-d02.news.aol.com... Will the the IBM DD2 documentation serve as confirmation?
"The DB2 .NET Data Provider allows your .NET applications to access
Version 8 DB2 Universal Database on Windows, UNIX, and Linux-based computers, and Version 6 and Version 7 of DB2 Universal Database for OS/390 and z/OS via DB2 Connect. "
You are using none of these servers
Full details are in the Application Development section of Concept, under APIs - Windows - DB2 .NET.
The only "workaround" is to use a supported API. This means you cannot use an API not supported by your DB2 for OS/2 V7 server.
"Development at American Savings" <de*@americansavingslife.com> wrote in message news:10*************@corp.supernews.com... Isn't there some second opinion - some way to make it work??? Any types of workarounds or anything?
"Mark Yudkin" <my***********************@nospam.org> wrote in message news:c8**********@ngspool-d02.news.aol.com... "Development at American Savings" <de*@americansavingslife.com> wrote
in message news:10************@corp.supernews.com... > I'm having some trouble being able to connect to my db2 server (it lives on > an os/2 warp 3 connect box) from my Windows2000 workstation using vs.net > 2003. Any suggestions?
AFAIK, this is not a supported combination; in any case, I would not expect it to work. To start with, DB2 for OS/2 does not support ODBC V3 or later; DB2's ODBC support is frozen at V2.5,. That at a minumum should be sufficient to cause your second "error" (server doesn't support ODBC API). You will need to use an API that is supported by DB2 for OS/2 V7.1,
such as native CLI. That means, ADO.NET is out. Alternatively, since DB2 for OS/2 is frozen, it may be time to consider transitioning away from OS/2 to a platform with DB2 V8 support, including support for the client API you wish to use (see http://www.ibm.com/software/os/warp/strategy/).
> > I have a local user account on the server "readonly", i have created
a user > in the database of "readonly" and I can connect through the command line, > but from within visual studio .net 2003 I cannot make a connection. Better > stated: I can make a connection but I cannot create data adapters -
I can't > get any data from that connection. > > I can see it in my server explorer, I can browse the tables and
fields, but > as soon as i try to drag some fields onto my form it asks for my username > and password, which I enter, and then I get the following error: > "ERROR [08004][IBM][CLI Driver]SQL1403N The username and/or password > supplied is incorrect. > SQLSTATE=08004 > > ERROR [IM006][Microsoft][ODBC Driver Manager]Driver's SQLSetConnectAttr > failed." > > I'm going crazy - what am i doing wrong? > >
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Mohammed AlQuraishi |
last post by:
Hi all,
I'm trying to connect to an MS Access database using ADO.NET and C#, but I'm
getting the dreaded "Microsoft Jet database engine cannot open the file 'x'.
It is already opened exclusively...
|
by: Chetan |
last post by:
I have setup an ODBC driver for my MySQL database and use a 3rd party
program to connect to it. Everytime the software connects, the ODBC
driver setup screen pops up. I have to click OK on it to...
|
by: ffoiii |
last post by:
I am attempting to connect to a remote default instance of SQL Server
2k on Win2k using Enterprise Manager from my local host but receive a
"SQL Server registration failed, timeout expired" error...
|
by: ohaya |
last post by:
Hi,
I've been researching this, and I'm not sure if what I'm trying to do is
possible, but I thought that I'd ask:
I have two webservers/websites.
The first webserver/website is running...
|
by: Praveen |
last post by:
Hi All,
I have a server DB2 UDB V8 on sun box. and accessing the server using
DB2 UDB client 7 from win2k system. Till now i used to login using
db2inst1 user which a default user created by...
|
by: Jerry Orr |
last post by:
We are trying to determine the easiest (and cheapest) way to get
connections for about 50 Win2K workstations on our LAN to DB2 on a
z/OS server.
We could install DB2 Connect Personal Edition on...
|
by: bbxrider |
last post by:
win2k adv server/ iis5.0/vb6.0/ado and/or odbc connections on client machine
i have an mdb on win2k adv server machine and want internet read/write to it
from both a non-windows, red hat, webserver...
|
by: http://www.visual-basic-data-mining.net/forum |
last post by:
Hi, I am new here. I am facing a problem that I can't connect to MS Access
with my Web application written in VB.Net.
It gives me this kind of error:
The Microsoft Jet database engine cannot...
|
by: Mikael Arhelger |
last post by:
Hello,
This has been posted a few times but still I could not find a way to
connect to our database. We run DB2 Express on WIN2K server with XP
clients. I can ping inside network and to the...
|
by: DolphinDB |
last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation.
Take...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
| |