RE: Newbie

Im used to any sql based database im currently at home so dont have the
code handy but I know one problem i came accross was a strange error
when I put where ref=1234 for example it said it wasnt supported

Regards
Rohan

>>> WaldenL@xxxxxxxxxxxxxxx 12/05/2005 17:03:37 >>>
Rohan,

What are you doing w/the DSN? Can you post some code? You'll need to
execute the appropriate sql select statement to get any data. The 400
should look no different that SQLServer or Oracle from a sql select
point of view, what are you used to?

-Walden


------------
Walden H Leverich III
Tech Software
(516) 627-3800 x11
WaldenL@xxxxxxxxxxxxxxx 
http://www.TechSoftInc.com 

Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)
  


-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]

On Behalf Of Rohan Sootarsing
Sent: Thursday, 12 May, 2005 10:21
To: web400@xxxxxxxxxxxx 
Subject: [WEB400] Newbie

Hi I know nothing about as400 but I do know asp and I want to pull
data
out of an as400 file into asp

Here is what i do know

I have a file called ctx4nthg in a library called qgpl the as400 is
called tdc01 and the username is tdc123 and password is pa55w01 

I Have installed client access tools onto my webserver I tried just
creating a dsn and calling that but it returns no results it doesnt
seem
to find any data at all 
can anyone help me.
I have been searching the web for ideas for weeks now

Regards
Rohan Sootarsing


________________________________________________________________________
______
This message has been checked for viruses by Corpex
using the ArmourPlate Virus Scanning Service. To find out
how to protect your company visit http://www.armourplate.com 
or call Corpex on +44 (0)207 430 8000.
-- 
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list
To post a message email: WEB400@xxxxxxxxxxxx 
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400 
or email: WEB400-request@xxxxxxxxxxxx 
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.


-- 
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list
To post a message email: WEB400@xxxxxxxxxxxx 
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400 
or email: WEB400-request@xxxxxxxxxxxx 
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.

______________________________________________________________________________
This email has been checked for viruses by ArmourPlate,
http://www.armourplate.com, the multi-scanner anti-virus facility from
Corpex. 


______________________________________________________________________________
This message has been checked for viruses by Corpex
using the ArmourPlate Virus Scanning Service. To find out
how to protect your company visit http://www.armourplate.com
or call Corpex on +44 (0)207 430 8000.