BorlandTalk.com Borland discussion newsgroups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  Delphi 2006 W32 problem with ftLargeInt on W2K          BorlandTalk.com Forum Index -> Delphi Installation View previous topic :: View next topic   Author Message Jim Kern Guest Posted: Wed Feb 01, 2006 2:32 pm    Post subject: Delphi 2006 W32 problem with ftLargeInt on W2K I have an application, originally built in Delphi 6, which works fine on my Windows XP Pro development box, but when I move it to the Windows 2000 platform we have in our production environment, it fails. The failure occurs when attempting to use an ADO Stored Procedure with a parameter of the type "numeric." In Delphi, I specify the parameter type "ftLargeInt." This stored procedure works fine on my Windows XP Pro machine, but on the W2K box, I get an error that states, "Bad variable type." I upgraded to Delphi 2006 to see if the problem would resolve, but it does not...I get the SAME EXACT error message from the app after building in 2006, and again, only on W2K. Anyone else experience any of this and/or have any suggestions for me? So far, Delphi support has been very slow to get back to me on the issue, so I'm hoping for some faster response here. Thanks, Jim Back to top Brion L. Webster Guest Posted: Wed Feb 01, 2006 11:27 pm    Post subject: Re: Delphi 2006 W32 problem with ftLargeInt on W2K Jim Kern wrote: Quote: I have an application, originally built in Delphi 6, which works fine on my Windows XP Pro development box, but when I move it to the Windows 2000 platform we have in our production environment, it fails. The failure occurs when attempting to use an ADO Stored Procedure with a parameter of the type "numeric." In Delphi, I specify the parameter type "ftLargeInt." This stored procedure works fine on my Windows XP Pro machine, but on the W2K box, I get an error that states, "Bad variable type." That sounds much more like a mismatch in the MDAC version installed on the boxes than a Delphi problem, IMO. Try installing MDAC 2.7 or 2.8 on both systems. http://msdn.microsoft.com/data/mdac/downloads/default.aspx -- -Brion There's no such thing as 'one, true way;' - Mercedes Lackey Back to top Jim Kern Guest Posted: Thu Feb 02, 2006 7:01 pm    Post subject: Re: Delphi 2006 W32 problem with ftLargeInt on W2K The MDAC was a REALLY good thought, and I thought perhaps you had something there, since I've had problems with the MDAC before... ...but alas, both my development machine and the target server are running MDAC 2.8. Shouldn't be the problem. Thanks, though...it was something I hadn't considered or checked yet. Any other thoughts? Jim Message was edited by: jkern Back to top Brion L. Webster Guest Posted: Fri Feb 03, 2006 3:22 am    Post subject: Re: Delphi 2006 W32 problem with ftLargeInt on W2K Jim Kern wrote: Quote: The MDAC was a REALLY good thought, and I thought perhaps you had something there, since I've had problems with the MDAC before... ..but alas, both my development machine and the target server are running MDAC 2.8. Shouldn't be the problem. Thanks, though...it was something I hadn't considered or checked yet. Any other thoughts? I just noticed your reply address - I'm guessing support.borland.com has a good incentive to help you out... ;-) You don't mention what back end database you're hitting. Assuming it's anything other than MS SQL Server, you may want to verify the database client is also the same version. I'm really thinking it's something other than Windows 2000 -> Windows XP, but still related to the difference in platforms. Probably something like Windows 2000 clients will need SP6a, IE 6 SP 1, etc. Failing anything obvious, I'd also try asking in borland.public.delphi.database.ado <or> borland.public.delphi.database.sqlservers -- -Brion There's no such thing as 'one, true way;' - Mercedes Lackey Back to top Guillem Guest Posted: Fri Feb 03, 2006 2:24 pm    Post subject: Re: Delphi 2006 W32 problem with ftLargeInt on W2K Jim Kern wrote: Quote: The MDAC was a REALLY good thought, and I thought perhaps you had something there, since I've had problems with the MDAC before... ..but alas, both my development machine and the target server are running MDAC 2.8. Shouldn't be the problem. Thanks, though...it was something I hadn't considered or checked yet. Any other thoughts? just to be sure... in the MDAC case it is not ony that for example MDAC 2.7 has "incompatibilities" (strong word but couldn't think of another right now) with MDAC 2.8, but AFAIK it also happens between MDAC 2.8 and MDAC 2.8 SP1 Just my 0.02 -- Best regards :) Guillem Vicens Meier Dep. Informática Green Service S.A. www.clubgreenoasis.com -- Contribute to the Indy Docs project: http://docs.indyproject.org -- In order to contact me remove the -nospam Back to top Jim Kern Guest Posted: Fri Feb 03, 2006 3:28 pm    Post subject: Re: Delphi 2006 W32 problem with ftLargeInt on W2K Support still hasn't called back, but I think I've found the problem with some more "creating keyword" searching. BTW...I'm using SQL Server 2000 as my database. I located the following borland report: http://qc.borland.com/wc/qcmain.aspx?d=8858 Apparently, it is a Win2K problem in that Win2K doesn't support that VarInt64 datatype, which is what the ftLargeInt corresponds to. I changed my stored procedure(s) to take the number in as a varchar and do the conversion to the numeric datatype internally. Not optimum, unfortunately, but we're not quite ready to upgrade to Windows2003 Server yet, so I have no choice. Thanks for all the suggestions. Jim Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         BorlandTalk.com Forum Index -> Delphi Installation All times are GMT Page 1 of 1   Jump to: Select a forum C++ Builder Newsgroups----------------C++ BuilderC++ Builder (ActiveX)C++ Builder (Announcements)C++ Builder (Command Line Tools)C++ Builder DatabasesC++ Builder Databases (ADO)C++ Builder Databases (Desktop)C++ Builder Databases (InterBase Express)C++ Builder Databases (Multi-Tier)C++ Builder Databases (SQL Servers)C++ Builder (Graphics)C++ Builder (IDE)C++ Builder (Internet)C++ Builder (Internet Socket)C++ Builder (Internet Web)C++ Builder (Jobs)C++ Builder (Language)C++ Builder (Language C++)C++ Builder (Compatibility with MFC)C++ Builder (Native API)C++ Builder (Non-Technical)C++ Builder (Students)C++ Builder (Third Party Tools)C++ Builder (Upgrade)C++ Builder (VCL)C++ Builder (VCL Components Usage)C++ Builder (VCL Components Development)C++ Builder (VCL Usage)C++ Builder (WinAPI)C++ Builder Installation Delphi Newsgroups----------------Delphi (General)Delphi ActiveX Controls UsageDelphi ActiveX Controls DevelopmentDelphi As400Delphi DatabasesDelphi Databases (ADO)Delphi Databases (dbExpress)Delphi Databases (Desktop)Delphi Databases (InterBase Express)Delphi Databases (Multi-Tier)Delphi Databases (SQL Servers)Delphi DeploymentDelphi GraphicsDelphi IDEDelphi InternationalizationDelphi InternetDelphi Internet Isapi-WebBrokerDelphi Internet WebSnapDelphi Internet WinsockDelphi JobsDelphi Language BASMDelphi Language ObjectPascalDelphi Model Driven Architecture (General)Delphi Model Driven Architecture (Third Party)Delphi MultimediaDelphi Native APIDelphi Non-TechnicalDelphi ObjectPascalDelphi OLE AutomationDelphi OO designDelphi OpenToolsAPIDelphi Reporting-ChartingDelphi RTLDelphi StudentsDelphi TeamSourceDelphi Thirdparty ToolsDelphi Thirdparty Tools (General)Delphi Thirdparty Tools (IntraWeb)Delphi Thirdparty Tools (RaveReports)Delphi UpgradeDelphi VCLDelphi VCL ComponentsDelphi VCL Components UsingDelphi VCL Components WritingDelphi WebServices SOAPDelphi WinAPIDelphi XMLDelphi Installationcomp.lang.pascal.delphi.components.misccomp.lang.pascal.delphi.components.usagecomp.lang.pascal.delphi.components.writingcomp.lang.pascal.delphi.databasescomp.lang.pascal.delphi.misccomp.sources.delphi JBuilder Newsgroups----------------JBuilderJBuilder AnnouncementsJBuilder Applet IssuesJBuilder As400JBuilder CompilerJBuilder CORBA/RMIJBuilder DatabasesJBuilder DB SwingJBuilder DebuggerJBuilder DeploymentJBuilder DocumentationJBuilder EnterpriseJBuilder HandheldJBuilder IDEJBuilder JavaJBuilder JavaAPIJBuilder Java LanguageJBuilder Java SwingJBuilder Java BeansJBuilder Java Beans UsageJBuilder Java Beans DevelopmentJBuilder JBCLJBuilder JDataStoreJBuilder JobsJBuilder LinuxJBuilder MacintoshJBuilder & MobileSetJBuilder MultiLingual AppsJBuilder Non-TechnicalJBuilder OpenToolsJBuilder Servlets (JSP)JBuilder StudentsJBuilder Team DevelopmentJBuilder Thirdparty ToolsJBuilder UpgradeJBuilder Installation InterBase Newsgroups----------------InterBaseInterBase Bug DiscussionInterBase GeneralInterBase IBConsoleInterBase OpenSourceInterBase ReplicationInterBase SQLInterBase ThirdpartyInterBase Installation Miscellaneous Borland Newsgroups----------------AppCenterAppServerEnteraVisiBroker  You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum Powered by phpBB © 2001, 2006 phpBB Group SEO toolkit © 2004-2006 webmedic.