Source language: Translate to:

Initializing sql-database

Questions about our Advanced Database plug-in

Moderator: Neosoft Support

Initializing sql-database

Postby christian » Fri Jul 27, 2007 3:47 am


tested opening a PostgreSQL-database, 2 Strings are working:

dbpOpenDatabase "YourDatabaseName" "Provider=MSDASQL.1;Persist Security Info=False;Data Source=sql-server2"

Grid is working, the correct column-with is automatically done, depending on the field-length; sorting and editing is possible.

Using the postgres-driver, works too

dbpOpenDatabase "YourDatabaseName" "Provider=PostgreSQL.1;Password=******;User ID=postgres2;Data Source=localhost;Location=Name_of_the_Postgres_database;Extended Properties=[#34][#34]"

but sorting columns is not possible, there is always an errormessage:
"Cannot sort a binary or special field"

Editing is not possible too.

Columns have all the same width, but you can change it.

What meens "Extended Properties"?

User avatar
Posts: 39
Joined: Sat Apr 02, 2005 9:25 am
Location: Germany

Postby Neosoft Support » Fri Jul 27, 2007 1:17 pm

It sounds like a configuration problem with the PostgreSQL driver. Unfortunately all drivers have different requirements. You will need to contact Postgres for information on the proper connection string to use.
NeoSoft Support
Neosoft Support
NeoSoft Team
Posts: 5621
Joined: Thu Mar 31, 2005 10:48 pm
Location: Oregon, USA

Return to NeoBookDBPro

Who is online

Users browsing this forum: No registered users and 1 guest