Invalid SQL: INSERT INTO `swsessions` (`sessionid`, `ipaddress`, `lastactivity`, `useragent`, `isloggedin`, `sessiontype`, `typeid`, `dateline`, `status`) VALUES('83baae36af2a5346450ff1a7243c42ac', '54.166.199.43', '1503428405', 'CCBot/2.0 (http://commoncrawl.org/faq/)', '0', '40', '0', '1503428405', '0'); (The table 'swsessions' is full)
Warning: Cannot modify header information - headers already sent by (output started at C:\Inetpub\support.inm.com\includes\functions.php:410) in C:\Inetpub\support.inm.com\includes\functions.php on line 1612
Datagrip FAQ - Support Center
inm logo
Corporate Website | Contact | Store | Support | Login  
     


Knowledgebase
View categorized listing of all common frequently asked questions.
Downloads
View our categorized library of downloads for all necessary manuals, software, etc.
 Article Options
Support Center » Knowledgebase » Datagrip » Datagrip FAQ
Support Page Banner
 Datagrip FAQ

Product:Platform:Area:Version:
Datagrip Windows All All

Datagrip FAQ


  • Question 1: On some machines my application crashes when I try to open a database. What is wrong?
  • Question 2: With which Macromedia products will Datagrip work?
  • Question 3: Why doesn't DGGetRecordCount() return an accurate record count in some cases?
  • Question 4: Does Datagrip work on the Macintosh?
  • Question 5: What versions of Microsoft Access are compatible with Datagrip?
  • Question 6: Do I have to pay runtime fees with Datagrip?
  • Question 7: How do I know if I need Datagrip?
  • Question 8: Can I use Datagrip on many machines that are all pointed at the same database?
  • Question 9: Does Datagrip work on the Macintosh?
  • Question 10: What are the different Datagrip Xtra files?
  • Question 11: Can I use Datagrip to search for a specific entry?
  • Question 12: What does registering a DLL mean?
  • Question 13: How do I read a database off a CDROM?
  • Question14: Will Datagrip work in 2000?
  • Question 15: Is the end user required to have Access installed?
  • Question 16: Is Datagrip prone to errors due to the recent bug found in Microsoft Access?
  • Question 17: I am getting errors when adding more than 255 records. How do I fix this?

Answers


Question 1: On some machines my application crashes when I try to open a database. What is wrong?

The problem is due to the fact that not all of the system files are installed or registered correctly. To see the most up to date list of files that you will need to install on the users system go to the chapter 6 section of the Datagrip User Manual.

Question 2: With which Macromedia products will Datagrip work?

Director 5, 6, 7, 8.5+Authorware 4, 5, 6+

Question 3: Why doesn't DGGetRecordCount() return an accurate record count in some cases?

DGGetRecordCount() returns the number of the last record that has been accessed in the recordset. The database engine does not actually know how many records are in a recordset until they have all been accessed, because for large databases, it could be very time consuming to count the records. If you want to insure that the record count is accurate, call DGMoveLast() before calling DGGetRecordCount. This insures that the last record has been accessed and the record count is accurate.

Question 4: Does Datagrip work on the Macintosh?

No. Unfortunately Microsoft has chosen not to port MS Access over to the Macintosh which also means that Sight & Sound can't port Datagrip to the Macintosh.

Question 5: What versions of Microsoft Access are compatible with Datagrip?

Datagrip is compatible with Access version 1.0 - 2000.

Question 6: Do I have to pay runtime fees with Datagrip?

No. If you purchase Datagrip you can use it in as many products as you wish. We just ask that each engineer programming with Datagrip have his own copy.

Question 7: How do I know if I need Datagrip?

If you have the need for quick and easy connectivity to MS Access databases you definitely need Datagrip. Just about any time you write data out to a file you can do it quicker and easier by using Datagrip to store it in a database.

Question 8: Can I use Datagrip on many machines that are all pointed at the same database?

Yes. Datagrip allows a developer to setup a scenario where many people are all talking to one database.

Question 9: Does Datagrip work on the Macintosh?

No. Unfortunately Microsoft has chosen not to port MS Access over to the Macintosh which also means that Sight & Sound can't port Datagrip to the Macintosh.

Question 10: What are the different Datagrip Xtra files?

DGDes.X32: The design time version used in Director and Authorware. DGRel.X32: The runtime version that you ship with your product. DGDemo.X32: the demo version that anyone can download free of charge. The only difference between this version and the real design time version is that the registration dialog box doesn't appear.

Question 11: Can I use Datagrip to search for a specific entry?

Yes. The easiest way to search for entries is to use the DGRSFindFirst command. For more information refer to the Datagrip documentation.

Question 12: What does registering a DLL mean?

Windows requires that you register some DLL's because it needs to store some internal information about that specific file. Most installer programs will give you an option to register a DLL once it is copied over to the destination system. If you are in a case where you don't have an installer you can call RegSvr32.exe. This file resides in the Windows\System directory. To use it you launch that program and pass it the path to the file you wish to register. For instance to register the file 'C:\Example.DLL' you would make this call: 'RegSvr32 C:\Example.DLL'. The program should tell you if the registration was successful or not.

Question 13: How do I read a database off a CDROM?

First when recording your CDROM be sure that the LDB file is NOT included. Secondly when opening the database you will have to open it exclusively and in a read-only state. To do this you will want to use the 4 parameter version of DGOpendatabase(). The call should look similar to this: DGOpendatabase(dbName, 1, 1, ""). Explain the License Agreement to me. The agreement is really a standard software agreement with one exception. There is a rare instance where you, the developer, will need to extend our licensing agreement to your user. If you develop a product that is essentially a tool and sell it to other developers who in turn make a product you will need to extend it to the developer you sell the tool to.

Question 14: Will Datagrip work in 2000?

Yes, Datagrip is Y2K compliant. How do I open a password protected database? You will need to use the 4 parameter version of DGOpendatabase. The call should look like this: DGOpendatabase(DatabaseName, 0, 0, ";PWD=yourpassword"). Of course you will want to replace the DatabaseName with the real database and yourpassword with the real password.

Question 15: Is the end user required to have Access installed?

No. As long as you distribute the appropriate files the user is not required to have Access. For more info on what you need to distribute refer to the "Distribution" section in the online help or the manual. I am trying to connect to a database over the network but I keep getting an error indicating the file is not found or must be opened read-only.

How do I fix this?

Usually the problem is that the users do not have read and write permissions for that computer. If you turn on the permissions you will most likely solve the problem.

Question 16: Is Datagrip prone to errors due to the recent bug found in Microsoft Access?

No. The bug only occurs when using a Jet method known as Bookmarking. Datagrip does not utilize this function so you do not have to worry about running in to this bug. I can't get Datagrip to run under Authorware 5. I get an error saying VBA Jet is failing to initialize.

How do I fix this?

Microsoft recently changed some of the files that are required to open MS Access databases which means there are additional files to ship with your applications. If you run in to this problem you will need to copy EXPSRV.DLL to the troubled system.

Question 17: I am getting errors when adding more than 255 records. How do I fix this?

In this case you are most likely using DGRSAddNew() to add the records. This option should work but in some configurations there is a limit to what it can add. If your application needs to add many records we suggest using DGExecute() and passing it an INSERT SQL string. This is an extremely fast method and developers have used it in the past to add millions of records in a single app.



Article Details
Article ID: 48
Created On: 22 Aug 2006 10:20 AM

 This answer was helpful  This answer was not helpful

inm general footer
Services Xtras Go Products Support Gallery Store Download About Us Contact Newsroom