Odbc Dbase Drivers For Mac
Hello, first of all I have to apologize for the crosspost, but I am kind of desperate. I need to know if there exists an ODBC driver (commercial too) for the IBM AS400 system (maybe DB2 is equivalent) that can be easily installed on a.Mac Os X. I cannot usa jdbc because the program that needs to access this AS400 is FileMaker Pro 8, and it handles only odbc connections. Thank you for your help and patience, - Guido Experience is a strange teacherit gives you the problem before the lesson. Hello, I need to know if there exists an ODBC driver (commercial too) for the IBM AS400 system (maybe DB2 is equivalent) that can be easily installed on a.Mac Os X. I cannot usa jdbc because the program that needs to access this AS400 is FileMaker Pro 8, and it handles only odbc connections. Thank you for your help and patience, - Guido Experience is a strange teacherit gives you the problem before the lesson.
Hello, I need to know if there exists an ODBC driver (commercial too) for the IBM AS400 system (maybe DB2 is equivalent) that can be easily installed on a.Mac Os X. I cannot usa jdbc because the program that needs to access this AS400 is FileMaker Pro 8, and it handles only odbc connections. Thank you for your help and patience, - Guido Experience is a strange teacherit gives you the problem before the lesson Sorry for the multiple posts, Guido I need to know if there exists an ODBC driver (commercial too) for the IBM AS400 system (maybe DB2 is equivalent) that can be easily installed on a.Mac Os X.
A quick google search didn't show much in the way of DB2 ODBC drivers for Mac, but there's an odbc-to-jdbc bridge product that may be helpful: (click the Mac symbol at the bottom of the page) Kaj Julius wrote: (click the Mac symbol at the bottom of the page) Thank you Kaj, I will take a look. Guido Experience is a strange teacherit gives you the problem before the lesson. Hello all, I'm working on a program that needs to send a print job to a printer connected to an AS/400. I've tried using the SpooledFileOutputStream and I've also tried using one of the SCS Writer classes.
Neither solution is working. With the SpooledFileOutputStream I am at least able to create my print file, but when my program ends, the file is still not being printed.
This program does not run on the AS400, it runs on a PC and connects to the AS400 via the toolkit classes. I know this part works as I am able to use the toolkit to access Data Queues, Files and Data Areas without a problem. Is there anyplace anyone can point me to see some examples of how to print a file using the AS400 Java Toolkit? Thanks in advance, Chuck Chuck, What printer data stream is used? Or how was the printer data generated? I am wondering if the data stream being generated matches the data stream of the printer connected to the iSeries?
What printer is attached to the iSeries and how is it configured? The iSeries info center has some Toolbox examples: ProgrammingJavaIBM Toolbox for JavaIBM Toolbox for Java Classes Access ClassesPrintCreating. Dave Chuck wrote: Hello allI'm working on a program that needs to send a print job to a printer connected to an AS/400. I've tried using the SpooledFileOutputStream and I've also tried using one of the SCS Writer classes. Neither solution is working.
Does anyone have some notes, documentation or helful pointers about navigating, command language and DB2 on an AS400 for a guy who has done HP3000, Windows 2k/2k3, MS SQL, HP9000, IBM ES9000/UNIX, SCO UNIX? Ideally a commands cross reference qaulivalent would be terrific - I.E. HP3000 to AS400. I'm taking a role in a shop that runs its ERP system on this platform.
Get easy, one-click access to your favorites. Your homepage. Ciao a chiunque legga!!! Allora io ho un cliente con un sistema AS400 e una stampante IBM infoprint 1130 munita di cassetto aggiuntivo. Ora come devo configurare le 2 sessioni client access in modo da avere: PRTA=stampa su cassetto normale PRTB=stampa su cassetto aggiuntivo utilizzando cmq la stessa stampante?
Grazie per l'interessamento!!!! 'davidino' wrote in message news:48e87dd8.770f2afa@posting.google.com. Ciao a chiunque legga!!! Allora io ho un cliente con un sistema AS400 e una stampante IBM infoprint 1130 munita di cassetto aggiuntivo. Ora come devo configurare le 2 sessioni client access in modo da avere: PRTA=stampa su cassetto normale PRTB=stampa su cassetto aggiuntivo utilizzando cmq la stessa stampante?
Grazie per l'interessamento!!!! Try something we can read. What`s the rocommended method of copyting data beetween two AS400 (both on V5R1)? Regards, Tom tom wrote: Hi. What`s the rocommended method of copyting data beetween two AS400 (both on V5R1)?
Probably FTP. 'tom' wrote in message news:c8c9u5$fb4$1@nemesis.news.tpi.pl. What`s the rocommended method of copyting data beetween two AS400 (both on V5R1)? RegardsTom It depends how often you are doing the copying & how much there is. If you want say one record but every 3 seconds then you can either store them up for a few hours days or weeks & use FTP, snads or a tape.
Or you can do it realtime & use DDMF to zap each record to the other machine as its written. I actually save the data I want sending this way into a file which is read & deleted by a daemon style of job so that if comms or the other machine fails only the daemon is affected. FTP has its upside in that the target is easily resettable for say a unix machine but SNADS has an easy to use & understand message sent to the sender & recipient to verify arrival of the data. Jonathan Bailey. You could install the No Charge SW 'Object Connect' from the OS CDs. Once setup you can issue cmds line SAVRSTLIB and SAVRSTOBJ. Give these cmds the LIB or OBJ list and the target system.
It then saves/transfers/restores to the target system all with just the 1 SAVRSTxxx cmd. Hi everyone, apparently, IBM removed their unix odbc drivers from their webpage, so I was wondering if any of you guys have it lying arround?, it would be a lot of help! Thanks in advance.
Fel wrote in news:7f114a0b-3b02-4a43-afaa- 8dd368d29024@z34g2000vbl.googlegroups.com: hi everyone, apparently, IBM removed their unix odbc drivers from their webpage, so I was wondering if any of you guys have it lying arround?it would be a lot of help! thanks in advance. as far as i know IBM never made an ODBC driver for UNIX there is an ODBC driver for LINUX: - Ad, pas de problme, que des solutions On Sep 21, 1:29=A0pm, Ad wrote: fel wrote in news:7f114a0b-3b02-4a43-afaa- 8dd368d29.@z34g2000vbl.googlegroups.com: hi everyone, apparently, IBM removed their unix odbc drivers from their webpage, so I was wondering if any of you guys have it lying arround?it would be a lot of help! thanks in advance. as far as i know IBM never made an ODBC driver for UNIX there is an ODBC driver for LINUX: - Adpas de probl=E8me, que des solutions thanks fel wrote: On Sep 21, 1:29 pm.
Looking for an explanation or documentation on the as400 specific extensions to the PowerPC instruction set. Pointers on the as400 are stored as 16 byte values. The LQ ( load quad word ) and STQ ( store quad word ) instructions are used to load and store those pointers. Here is PPC assembler code that loads a pointer from an EA into a register: LQ 24, 0x1e50(30), 6 SELRI 26, 25, 0, 41 LQ loads the 16 bytes stored at EA reg30 + 0x1e50 into reg24 and reg25. The next SELRI stmt does something to reg25 and places the result in reg26. Does anyone know what the 3rd opera.
Sorry for my english but I have MS Access in italian. My problem is by link a table from IBM As400 (with 100.000 rows). The output of the table is many #ELIMINATO (in english 'delete' / 'erase'. I dont't know the exact message). I have tried with 'requery' or recreating the link without results. If I.import. the table from AS400 it works perfectly without problems.
Here an abstract txt BOLAZI;BOLCLI;BOLDBO;BOLNBO;BOLCAU;BOLNPR;BOLTRE;BOLMAT;BOLDES.;;;;;;;#Eliminato;#Eliminato;;;;;;;#Eliminato;#Eliminato;;;;;;;#Eliminato;#Eliminato 0;474;990204;354;10;1;1; 936;PC Intel Pentium II 400 Miditower 0;474;990204;354;10;4;1; 1890;CD-ROM drive 36X 0;474;990204;354;10;5;1; 1692;HD-SCSI 4.5 Gb IBM Ultrastar WIDE 7200 0;474;990204;354;10;6;1; 1497;HD-SCSI 9.1 Gb IBM DDRS-39130 UWIDE. Thanks in advance M.
'Mire' wrote in message news:buo9eo$k39dq$1@ID-57790.news.uni-berlin.de. Sorry for my english but I have MS Access in italian. My problem is by link a table from IBM As400 (with 100.000 rows). The output of the table is many #ELIMINATO (in english 'delete' / 'erase'. I dont't know the exact message). I have tried with 'requery' or recreating the link without results. If I.import.
the table from AS400 it works perfectly without problems. Hello, In ODBC Administrator I find a bunch of drivers (DBase, Foxpro, Nintendo, dontknowwhat), plus the iSeries Access ODBC driver. Are there other than IBM iSeries drivers available which I can use on PCs which have no iSeries Access installed? Walter HiT odbc for AS/400 It is much friendlier to M$ applications than IBM's driver 'Walter' wrote in message news.60@o13g2000cwo.googlegroups.com. HelloIn ODBC Administrator I find a bunch of drivers (DBase, FoxproNintendo, dontknowwhat), plus the iSeries Access ODBC driver. Are there other than IBM iSeries drivers available which I can use on PCs which have no iSeries Access installed? Walter Just curious - why don't you want to use the iSeries Access driver?
StarSQL: Very fast and easy to use. Bob 'Walter' wrote in message news. HelloIn ODBC Administrator I find a bunch of drivers (DBase, FoxproNintendo, dontknowwhat), plus the iSeries Access ODBC driver. Are there other than IBM iSeries drivers available which I can use on PCs which have no iSeries Access installed?
Walter. I am working with VB.NET version 8 and AS400 (V5R3). I used the ODBC client 'iSeries Access ODBC Driver', version 10.00.03.00, file CWBODBC.DLL to establish a connection to the AS400. Then with the Data Source Configuration Wizard, I got the error 'ERROR HY000 IBMiSeries Access ODBC DriverDB2 UDBSQL0901 - SQL system error'. Can someone help me on this issue? Jean wrote: I am working with VB.NET version 8 and AS400 (V5R3). I used the ODBC client 'iSeries Access ODBC Driver', version 10.00.03.00, file CWBODBC.DLL to establish a connection to the AS400.
Then with the Data Source Configuration Wizard, I got the error 'ERROR HY000 IBMiSeries Access ODBC DriverDB2 UDBSQL0901 - SQL system error'. Can someone help me on this issue? If the connection is successful, you may want to look at the job log on the server (iSeries), which often will contain more detailed information in the form of messages, if the failure is on the server. The server job will have a name of the form nnnnnn/QUSER/QZDASOINIT. On a 5250 ('green screen') command line after connecting from the client, try this to find the job: wrkactjob job(qzda.) Use option 5 (Work with), then option 10 (Display job log), then F10 (Display detailed messages). Karl Hanson Jean wrote: I am working with VB.NET version 8 and AS400 (V5R3). I used the ODBC client 'iSeries Access ODBC Driver&.
Aprax Consulting believes in developing professionals who believe in themselves and are equipped with the latest state of the art in their respective fields, professionals who are confident and can compete in the challenging world. The endeavor is to inculcate a desire for continuous improvement, a sense of healthy competition, and sensitivity towards ethical and moral values. Aprax consulting offers all types of certification test papers, dumps with 100% assurance of passing. 100% Money refunded if failed (except courier charges). All IBM certification including Mainframe certification, AS400 certification test papers available. IBM MAINFRAME DB2 certification IBM AS/400 RPGILE certification Contact: Aprax Consulting Ph(M): +678 URL: www.apraxindia.com Email: hr@apraxindia.com Your 1st sentence is grammatically incorrect and doesn't make any sense.
One question: Isn't your moral values endeavor compromised by selling dumps? Hi, Frontend: MS Access XP on Win XP Backend AIX: DB2. (7.1) Hi, to be honest, concerning the db2 im a rather newbie, so sorry for unexact question. I tried in beforehand to find some for me relevant information on the IBM or MS side and on Google-groups, but i failed (maybe im just to silly).
In the office there is Office XP and Win XP installed together with an (older) ODBC-driver for IBM DB2 7.1 which i use to just link the tables into Access. On my Toshiba-laptop i installed for testing purposes the Personal Edition of IBM DB2, a CD which i got from IBM on a fair (Version 8.2 beta). This one obviously automatically installs a newer odbc-driver. This driver behaves differently on dates as said in an article about Access and dates and ODBC So my question: Where to load the new ODBC-driver seperate from the PE? I dont want to install the whole system for just getting a new driver.
Any special things ive to look for? Mfg Klaus Oberdalhoff Klaus Oberdalhoff MVP wrote: HiFrontend: MS Access XP on Win XP Backend AIX: DB2.
(7.1) This driver behaves differently on dates as said in an article about Access and dates and ODBC So my question: Where to load the new ODBC-driver seperate from the PE? I dont want to install the whole system for just getting a new driver.
Any special things ive to look for? There's much differ. Hello All, I've been struggling on and off for 3 months trying to connect to an DB2 database running on an IBM iSeries machine. I FINALLY figured out how to connect with Coldfusion (see instructions below). So, now I am trying to connect to the same database with MS Access. I want to link the tables within Access so I can quickly query and answer questions. The problem is that I HAVE NO IDEA how to do this.
I'm familiar with linking tables to other databases (MySQL, MS SQL Server, Oracle), but I've never done it for IBM DB2 (I'm not even familiar with the IB. Does an IBM AS400e Type 9406 work with Linux? If so, which distribution is available? Al Al Bogner wrote: Does an IBM AS400e Type 9406 work with Linux? If so, which distribution is available?
The following shows the which models support Linux. Not well known but Microsoft uses IBM AS400 machines with the Windows server card option to develop programs. This option is really a PC on a card but offers significant advantages over a stand alone pc in that it can support virtual sessions of Windows each of which can be rebooted as required without bringing down the other seesions or worse the rest of the machine. Microsoft is a huge IBM AS400 customer. Most people assume developers are using PC's sitting next to their work space. Fadl Ullah Jonnalagadda wrote: Not well known but Microsoft uses IBM AS400 machines with the Windows server card option to develop programs. This option is really a PC on a card but offers significant advantages over a stand alone pc in that it can support virtual sessions of Windows each of which can be rebooted as required without bringing down the other seesions or worse the rest of the machine.
Microsoft is a huge IBM AS400 customer. Most people assume developers are using PC's sitting next to their work space.
MS developers are using Win 2k3 and Win 2k8 servers as development machines too and not PC(s), with VMware. Fadl Ullah Jonnalagadda wrote: Plonk 'Fadl Ullah Jonnalagadda' wrote in message news:60deb8d3-5599-48d8-8667-6734e37a756b@31g2000vbf.googlegroups.com. Not well known but Microsoft uses IBM AS400 machines with the Windows server card option to develop programs. Hi Scott, I had a similar problem. The instructions for driver installation mad no sense with respect to the contents of the package. I downloaded som packages from urlan installed the drivers from there. That web page also has a link (a the bottom) to 'Thomas Berger's OS X Tips' that contains some usefu information, though not everything works as described.
I've got th ODBC driver installed, but not fully working yet. I know that I' communicating with the server (looking at the traffic log on th server), but. I have aquired 5 ibm scsi drives and cages pulled from a retired AS400 server. I was hoping i could use them in a raid configuration connected to a generic PC with an adaptec 2940u2w. They are all recognized but throw up errors when writing to drive ( ie.
Formatting) are these compatable with regular PC scsi? Is it the drive microcode? Am i out of luck on these drives?
Drive cage = type 6713 ibm FRU = 59H6611 drive model number = DGHS-09U date code 01APR99 (all 5 same date) The low leve format of the drives is different (520 vs. 512 for PCs as I recall) You should be able to find a utility to reformat them.
HTH, Charles In article, reply@here.org says. i have aquired 5 ibm scsi drives and cages pulled from a retired AS400 server. i was hoping i could use them in a raid configuration connected to a generic PC with an adaptec 2940u2w. they are all recognized but throw up errors when writing to drive ( ie. Formatting) are these compatable with regular PC scsi? is it the drive microcode? am i out of luck on these drives?
drive cage = type 6713 ibm FRU = 59H6611 drive model number = DGHS-09U date code 01APR99 (all 5 same date) thank you, i`ll look into that - drives seem to stop responding after adaptec bios format utility is attempted - led activity indicator goes off - no writing noise ibm/hitachi. When I connect to our companies AS400 (iseries) the file names appear in korean. When I first purchased my G4 (4 or 5 years ago) I was able to see my AS400 file shares with no problems.
At some point I upgrade to a more recent version of Mac OS X and I lost the ability to see my AS400 (at least in english). I can see other PC's on the network, and they can see the as400.
It seems like some kind of character set issue. Any help in this matter would be greatly appreciated. Is there anyone elso who is connecting to their companies AS400 IFS using Mas OS X?
Thanks, Martin Machine specs: OS X 10.3.8 G4 To those of you that find this message. I solved the problem with a product called DAVE (thursby.com). Please note they don't officially support the connection.
Martin Martin, the problem you noted is fixed on the iSeries in V5R2 via PTF MF34715. Said fix is in the base on V5R3 and is not available for V5R1. Jon Martin wrote: When I connect to our companies AS400 (iseries) the file names appear in korean. When I first purchased my G4 (4 or 5 years ago) I was able to see my AS400 file shares with no problems. At some point I upgrade to a more recent version of Mac OS X and I lost the ability to see my AS400 (at least in english). I have (6) sticks of SiliconMountain Memory (Parity, Gold leads, 70ns), product # SMM4342-9661. These SIMMs are supposed to be equivalent to IBM 92G7205.
This memory works fine in my PC 750 MCA/PCI (6886) under Win98. But it does NOT work reliability under Windows NT 3.51 (My current OS). I would like to trade 192MB of SiliconMountain Memory for (2) sticks of IBM 92G7205 SIMMs. Please contact me via email at gorenbergh @ mags. Thanks, Steve (eTh1nk). Does the com.ibm.as400.access.AS400JDBCDriver driver that is part of JTOpen (works with db2 udb version 7 that is installed on windows 2000?
I' m trying to access db2 from java aplication like this: Class.forName('com.ibm.as400.access.AS400JDBCDriver'); Connection connection = DriverManager.getConnection('jdbc:as400://hostname','user','password'); Statement statement = connection.createStatement; ResultSet resultSet = statement.executeQuery('select. from tablename');, and I get this ja. Just read on the Connextic newsgroup that you need to hook up VPC/2 guest OSes via the Loopback Interface to make them see each other and the Host PC WITHOUT that host pc being connected to any network (everybody always only considers Guest PC to outside network connection - why is a mystery to me). Now the instructions for that procedure where for Windoze. So I wonder how one would install a loopback adapter in OS/2?
Maybe that IBM NULL MAC driver is it? Also, what do the two parameters you can specify for the Virtual PC MAC driver mean? And while we're at it, what does the term MAC mean anyway? Greetings Morenga On Sat, 12 Jul 2003 02:05:25 -0600 (MDT), Morenga wrote: Just read on the Connextic newsgroup that you need to hook up VPC/2 guest OSes via the Loopback Interface to make them see each other and the Host PC WITHOUT that host pc being connected to any network (everybody always only considers Guest PC to outside network connection - why is a mystery to me). Open up the TCPIP Configuration notebook and check the loopback interface is enabled. Cheers Wayne - Posted with PMINews 2 for OS/2 Running on eComStation 1.1 On Sat, 12 Jul 2003 15:12:15 +0900 (JST), Wayne wrote: On Sat, 12 Jul 2003 02:05:25 -0600 (MDT), Morenga wrote: Just read on the Connextic newsgroup that you need to hook up VPC/2 guest OSes via the Loopback Interface to make them see each other and the Host PC. Hello, We have a IBM that don't POST with no beep codes or nothing.
Dbase Files Drivers
The monitor is black too. I pull all cards out and there are still no beeps or POST. I finally pull-out the memory stick and bingo! Now I get beep codes like crazy. Is this a indication that I need new ram? Thanks, Al On Wed, 30 Mar 2005 04:17:46 GMT, 'Al Davis' wrote: Hello, We have a IBM that don't POST with no beep codes or nothing. The monitor is black too.
I pull all cards out and there are still no beeps or POST. I finally pull-out the memory stick and bingo! Now I get beep codes like crazy. Is this a indication that I need new ram? Was it working? It may just be the wrong type of stick if this is a build.
It was working and this IBM pc came from the IBM store.AL wrote in message news:t7hk41pqjlkda6k3491c9a0bcnrl0fatjc@4ax.com. On Wed, 30 Mar 2005 04:17:46 GMT, 'Al Davis' wrote: HelloWe have a IBM that don't POST with no beep codes or nothing. The monitor is black too. I pull all cards out and there are still no beeps or POST.
Odbc Drivers For Excel
I finally pull-out the memory stick and bingo! Now I get beep codes like crazy.
Is this a indication that I need new ram?.
Hi All, This should be an easy one, but I’m running out of time and need this asap. I need to download the Microsoft Access ODBC Driver so that I can set up a User DSN that my Java programs can connect too. I was shocked when I went into Control Panel Administrative Tools Data Sources (ODBC), and when I went to add a new DSN there were no drivers! I have Access 2003 installed and working properly, and even on the list of already set up DSN’s it shows: dBASE Files.Microsoft Access dBASE Driver (.dbf,.ndx,.mdx) Excel Files.Microsoft Excel Driver (.xls,.xlsx,.xlsm,.xlsb) MS Access Database.Microsoft Access Driver (.mdb,.accdb).