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

Hello,

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

(1)
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.

(2)
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"?

Christian
User avatar
christian
 
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: 5603
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 2 guests