GoldMine
Anyone out there have any experience using CF to interact with a GoldMine database? I am wondering if it's possible. - Sean ~~ Sean Daniels Director, Engineering Marketplace Technologies, Inc (T): 207.363.7374 (C): 207.332.6340 (F): 240.269.6319 ~~ http://www.dealforce.com http://www.mergernetwork.com __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: GoldMine
yes it's possible. You can use DBase drivers (not good) or you can upgra de goldmine to SQL and do it that way. If you can figure out Goldmines rath er difficult Primary key schema you can make it happen. There are a lot of folks doing it with various 3rd party aps and you can find ideas on how t o proceed on the goldmine forums. Mark -Original Message- From: Sean Daniels [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 29, 2001 10:22 AM To: CF-Talk Subject: GoldMine Anyone out there have any experience using CF to interact with a GoldMine database? I am wondering if it's possible. - Sean ~~ Sean Daniels Director, Engineering Marketplace Technologies, Inc (T): 207.363.7374 (C): 207.332.6340 (F): 240.269.6319 ~~ http://www.dealforce.com http://www.mergernetwork.com __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: GoldMine
I've done a little work with GoldMine. If I recall, I think the original was in dBase, then they released it using MS SQL. If the db is SQL, they've got an API written using MS SQL stored procedures. That seemed to be the surest way of interacting with the db. I'm not a SQL guru... I did some front end work in CF and just called a number of the stored procedures, plus a few custom ones that utilized them. Jim - Original Message - From: "Sean Daniels" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, December 29, 2001 11:22 AM Subject: GoldMine > Anyone out there have any experience using CF to interact with a GoldMine > database? I am wondering if it's possible. > > - Sean > > ~~ > Sean Daniels > Director, Engineering > Marketplace Technologies, Inc > (T): 207.363.7374 > (C): 207.332.6340 > (F): 240.269.6319 > ~~ > http://www.dealforce.com > http://www.mergernetwork.com > > > __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: GoldMine
On 12/29/01 4:30 PM Mark A. Kruger - CFG wrote: > yes it's possible. You can use DBase drivers (not good) or you can upgra > de > goldmine to SQL and do it that way. If you can figure out Goldmines rath > er > difficult Primary key schema you can make it happen. There are a lot of > folks doing it with various 3rd party aps and you can find ideas on how t > o > proceed on the goldmine forums. Beautiful, that's what I wanted to hear. Thanks. - Sean ~~ Sean Daniels Director, Engineering Marketplace Technologies, Inc (T): 207.363.7374 (C): 207.332.6340 (F): 240.269.6319 ~~ http://www.dealforce.com http://www.mergernetwork.com __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: GoldMine
Spend some time in the GoldMine developers newsgroups. They make a few cross platform objects now that help you keep the data in their complicated db schema "synched" if accessing the data thru the "FrontRange/GoldMine" supplied server objects. That way if you munge your or your clients data - they wont be able to point the finger quite so emphatically at you. Steve - Original Message - From: "Sean Daniels" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, December 30, 2001 12:18 PM Subject: Re: GoldMine > On 12/29/01 4:30 PM Mark A. Kruger - CFG wrote: > > > yes it's possible. You can use DBase drivers (not good) or you can upgra > > de > > goldmine to SQL and do it that way. If you can figure out Goldmines rath > > er > > difficult Primary key schema you can make it happen. There are a lot of > > folks doing it with various 3rd party aps and you can find ideas on how t > > o > > proceed on the goldmine forums. > > Beautiful, that's what I wanted to hear. Thanks. > > - Sean > > ~~ > Sean Daniels > Director, Engineering > Marketplace Technologies, Inc > (T): 207.363.7374 > (C): 207.332.6340 > (F): 240.269.6319 > ~~ > http://www.dealforce.com > http://www.mergernetwork.com > > > __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Interacting with GoldMine data with ColdFusion
Anyone have any experience with GoldMine? (http://www.frontrange.com/goldmine/) We're looking at using CF to get at the data (the web site says SQL Server, but it's really more SQL Server reading dBase files), which is supposed to be possible. But, I'm having trouble setting up a DSN (ODBC socket to a system DSN) in the administrator. Scott -- - Scott Brady http://www.scottbrady.net/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Interacting with GoldMine data with ColdFusion
Goldmine can be either SQL server OR dbase... or in the case of a synch server a combination. Can you further describe your setup? -Mark -Original Message- From: Scott Brady [mailto:[EMAIL PROTECTED] Sent: Friday, October 01, 2004 5:02 PM To: CF-Talk Subject: Interacting with GoldMine data with ColdFusion Anyone have any experience with GoldMine? (http://www.frontrange.com/goldmine/) We're looking at using CF to get at the data (the web site says SQL Server, but it's really more SQL Server reading dBase files), which is supposed to be possible. But, I'm having trouble setting up a DSN (ODBC socket to a system DSN) in the administrator. Scott -- - Scott Brady http://www.scottbrady.net/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Interacting with GoldMine data with ColdFusion
I can tell you what I've been told about our setup. The database is "offficially" SQL Server, but if you look at the actual server, they're really just dBase data files that SQL Server is pulling from. (The person in my company who chose GoldMine says the company says "SQL Server" for marketing purposes, because it's still just dBase on the backend). But, in any event. We've got a directory full of dBase files that hold the data. We'd like to be able to set up a DSN in CF in order to access the data (we want to create a more useful report than is available in GoldMine itself). Thanks! Scott -- - Scott Brady http://www.scottbrady.net/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Interacting with GoldMine data with ColdFusion
I can't understand why you would even have SQL Server if all you have is DBase files. Maybe I'm missing something but the Corporate edition requires SQL Server, not the cheaper editions. When we had it here I set up the Goldmine tables just like any other SQL Server tables, with no problems. >I can tell you what I've been told about our setup. > >The database is "offficially" SQL Server, but if you look at the >actual server, they're really just dBase data files that SQL Server is >pulling from. (The person in my company who chose GoldMine says the >company says "SQL Server" for marketing purposes, because it's still >just dBase on the backend). > >But, in any event. We've got a directory full of dBase files that hold >the data. We'd like to be able to set up a DSN in CF in order to >access the data (we want to create a more useful report than is >available in GoldMine itself). > >Thanks! > >Scott >-- >- >Scott Brady >http://www.scottbrady.net/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Interacting with GoldMine data with ColdFusion
On Tue, 05 Oct 2004 17:41:40 -0400, Larry White <[EMAIL PROTECTED]> wrote: > I can't understand why you would even have SQL Server if all you > have is DBase files. Maybe I'm missing something but the Corporate > edition requires SQL Server, not the cheaper editions. When we > had it here I set up the Goldmine tables just like any other > SQL Server tables, with no problems. We found out how to access the tables. The help via the web in how to set up the datasources was . . . not helpful. Thanks anyway. Scott -- - Scott Brady http://www.scottbrady.net/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]