RELEVANCY SCORE 3.60. MSG =[DataDirect][ODBC SQL Server Driver][SQL Server]. I download the DataDirect Connect ODBC V4.1(evaluate). Download ODBC connectors. DataDirect Connect and Connect64 for ODBC Progress OpenEdge Wire Protocol Driver. (32- and 64-bit) AIX, version 5.3. We are currently running 9.0B, but will be upgrading to 9.1c in the next couple of weeks. We are using Merant 3.5 drivers and they stink. Progress Sql-92 Client AccessWe have many application and other databases that need data from Progress. Problem is the speed is so slow I end up downloading the data a couple of times a day instead of in real-time. Is there a better driver or better way? Most of the outside applications are written in Visual Basic, SQL server, Access. RE: Need ODBC help New to Progress (Programmer) 13 Mar 02 11:49. We are on 9.1c and are using Merants SLQ92 driver(Supplied to us). I have just started some ASP apps and Visual Basic developement with it. So far I couldn't be happier. The speed is well beyond my expectations and all the errors I use to receive, seem to be fixed. I wrote more error checking than I wrote application. The upgrade to 9.1C was easy. Infact we still have 9.0b running on the same server. Our database schema changes had some problems but that isn't Progress, it's our manufacturing software vendor's problem. I will try to help you with any questions you might have. There are still better and faster ways than ODBC. I have started to rewrite apps in Progress 4GL and I am looking at webspeed. Regards, Franklin RE: Need ODBC help New to Progress (Programmer) 13 Mar 02 12:16. Good to hear it about 9.1C!! Yes, I'm sure native connections (including WebSpeed) are much faster than ODBC even in 9.1C. Just to let you know, I have 14 years of experience developing apps in Progress: GUI and character. I have about.05 years experience with ASP (lol), but I want to learn it. Maybe we could trade expertise via email or this forum. I have a little bit of WebSpeed exposure from a free seminar about 2 years ago (yeah, big help!) but basically, SpeedScript is 99.5% Progress 4GL. BTW, there is some kind of 'hybrid webspeed/ASP' protocol or DLL that you might want to check out. Regards, Paul Fry RE: Need ODBC help New to Progress (IS/IT--Management) 19 Mar 02 11:57. I don't suppose you could offer some advice in regards to setting up the SQL92 driver. Is this the 4.1 driver recently released by Datadirect? I'm stumped when it's asking for a port. Is this the database port? When I connect directly to the database port it says I can not connect because of license issues (although we have enough licenses). When I connect to the broker port used in the 3.6 driver I get an error:) Probably a really stupid thing to ask about, and I'm sure it's not all that hard to resolve, but after talking with Datadirect, I was no more enlightened than before I spoke with them. RE: Need ODBC help New to Progress (Programmer) 9 Apr 02 08:50. Franklin1232: I have just started to dive into this stuff. Merant 3.60 32-bit Progress Sql92 Odbc Driver DownloadI am familiar with VB, but have no experience in database connections. We have a Syteline ERP system running on Progress 9.1C. We have a 3rd party application for extracting data that leaves a lot to be desired. Outside of the fact that I am having trouble creating a new System DSN, I was hoping you would have some pointers to sample code. There are a couple of Merant connections already set up, so I was hoping to use those. Can you recommend any sites that have sample VB or VBA code for reading from a Progress DB? Any help, pointers or suggestions would be greatly appreciated. RE: Need ODBC help New to Progress (IS/IT--Management). Well using VB to access Progress isn't really specific to Progress software as it is to ODBC. What you want to find is sample VB code that uses ODBC and SQL to retrieve records. There are a ton of sites with these type of sample. EX: might just want to start with the MSDN libary if you have it, or stop by your local Barnes and Noble and pick up Programming Visual Basic databases. As far as your system DSN, What is the driver you are trying to use?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
November 2018
Categories |