Wednesday, 7 July 2010

Create Databases and Datasource Names (DSNs) in Pervasive.SQL

To create company and system databases in Pervasive.SQL:

  1. Click Start > All Programs > Pervasive > Pervasive.SQL Control Center.
  2. In the Common Tasks section in the right panel, click New Database. The New Database window opens.
  3. In the Server field, click the down arrow, select a server from the list, and then click Next.
  4. In the Database Name field, type the name of the folder you created for the database. Note: The folder name and the database name must be identical.
  5. In the Location field, type the path to the folder you created for the database.
  6. In the DBName Options section, select Bound and Create Dictionary Files. Do not select the option, Relational Integrity Enforced, as Sage Accpac checks integrity.
  7. Select the Create DSN option, and leave Normal as the Open Mode. Note: The DSNs are used in Database Setup when you set up your system and company databases.
  8. Click Finish.
  9. Create other databases (for example, if you created a system database, now create a company database).
  10. Close the Pervasive.SQL Control Center.

10 comments:

Anonymous said...

人有兩眼一舌,是為了觀察倍於說話的緣故。............................................................

Anonymous said...

當一個人內心能容納兩樣相互衝突的東西,這個人便開始變得有價值了。............................................................

Anonymous said...

Subtlety is better than force. ............................................................

Anonymous said...

[做人難,人難做,難做人] 人.事的艱困與磨難,是一種考驗!要以樂觀歡喜之心,很珍惜地過每一天!^^............................................................

Anonymous said...

這個部落格好好好~棒棒棒~~~..................................................................

Anonymous said...

這不過是滑一跤,並不是死掉而爬不起來了。..................................................

Anonymous said...

Always read stuff that will make you look good if you die in the middle of it...................................................

Anonymous said...

人生中最好的禮物就是屬於自己的一部份..................................................

Anonymous said...

當我微笑時,世界和我一起微笑;當我快樂時,世界和我一起活躍。..................................................

Anonymous said...

要在憂患恥辱的環境裡,創造我們自力更生的新生活。..................................................