BorlandTalk.com Borland discussion newsgroups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  Re: IB - .gdb & SQL META          BorlandTalk.com Forum Index -> Delphi Databases (Desktop) View previous topic :: View next topic   Author Message Bill Todd Guest Posted: Mon Nov 29, 2004 11:03 pm    Post subject: Re: IB - .gdb & SQL META What do you mean by "sql script - meta"? If you have the metadata extracted from an InterBase database all you have to do is add the CREATE DATABASE command and run it through isql. The alternative is to create the database in IBConsole then run the script in the IBConsole SQL editor. -- Bill (TeamB) TeamB cannot answer questions received via email Kiran wrote: Back to top Bill Todd Guest Posted: Fri Dec 03, 2004 6:10 pm    Post subject: Re: IB - .gdb & SQL META First, how, exactly, did you create the metadata file that you are trying to run? Did you use IBConsole or isql? What version of IB was the database you are extracting from created with? What version of IB are you using to create the new database? Have you modified the extracted metadata in any way? If all you want to do is create an identical empty database why not do a metadata only backup and restore? How many lines long is the extracted metadata? -- Bill (TeamB) TeamB cannot answer questions received via email Back to top Bill Todd Guest Posted: Mon Dec 20, 2004 9:58 pm    Post subject: Re: IB - .gdb & SQL META Yes, the metadata is there. What is not there is the answers to any of my questions. -- Bill Todd (TeamB) TeamB cannot answer questions received via email Back to top Bill Todd Guest Posted: Tue Dec 21, 2004 5:46 pm    Post subject: Re: IB - .gdb & SQL META Using IB 7.5 I opened IBConsole, created a database using the Database Quote: Create Database menu, opened the SQL editor, loaded your script using the Query | Load SQL Script menu choice and ran the script. I did not receive any errors. I assume you are using the current version of InterBase, which is 7.5. What errors do you get when you follow the steps I used. -- Bill Todd (TeamB) TeamB cannot answer questions received via email Back to top Bill Todd Guest Posted: Tue Dec 21, 2004 8:56 pm    Post subject: Re: IB - .gdb & SQL META If you are not using the current version of a product be sure to say so when you ask your question otherwise everyone will assume you are using the current version and you may get an incorrect answer. There is no reason to send the file since you will not be able to open it without IB 7.5. -- Bill Todd (TeamB) TeamB cannot answer questions received via email Kiran wrote: Quote: I not using that version!!! Thats why! Back to top Bill Todd Guest Posted: Tue Dec 21, 2004 11:19 pm    Post subject: Re: IB - .gdb & SQL META Kiran wrote: Quote: I don't want to open the database... just want to use it through an application which has been sold. I deleted the file as soon as I created it. There was no reason to save it once I saw that the script worked. You cannot access an InterBase database created with InterBase 7.5 in any way with any piece of software not matter what it is unless you have the InterBase 7.5 server installed. Quote: Any way.. downloaded v7.5 but no luck in how to work the version... What did you download? Did you download the trial version? Quote: How do i start the server what information do i need to put in where it says register and connect or do i not need to do that? The server installs as a Windows service on Windows NT/2000/XP/2003 and should start automatically. Use the Services applet in Control Panel to see if the server is running. Quote: Then how do i create the database through Isql Do you have the manuals for any version of InterBase? -- Bill Todd (TeamB) TeamB cannot answer questions received via email Back to top Bill Todd Guest Posted: Wed Dec 22, 2004 12:42 pm    Post subject: Re: IB - .gdb & SQL META Did you register the trial version? Is the InterBase server service running? -- Bill Todd (TeamB) TeamB cannot answer questions received via email Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         BorlandTalk.com Forum Index -> Delphi Databases (Desktop) 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.