Re: [GENERAL] psqlodbc MSAccess and Postgresql
Hello, I am currently migrating my MSDE/Access (Access Project) aplication to PostgreSQL. I have experienced a lot of obstacles till now, but anyway it seems quite posible to make a good aplication by this combination of Access front-end and PostgreSQL base. I use the following ODBC settings for linked tables successfully: [ODBC]DRIVER=PostgreSQLUID=zmaticUseServerSidePrepare=0ByteaAsLongVarBinary=0BI=0TrueIsMinus1=1DisallowPremature=0UpdatableCursors=1LFConversion=1ExtraSysTablePrefixes=dd_CancelAsFreeStmt=0Parse=1BoolsAsChar=1UnknownsAsLongVarchar=0TextAsLongVarchar=1UseDeclareFetch=1Ksqo=1Optimizer=1CommLog=0Debug=0MaxLongVarcharSize=8190MaxVarcharSize=254UnknownSizes=0Socket=4096Fetch=100ConnSettings=CLIENT%5fENCODING%3dWIN1250ShowSystemTables=0RowVersioning=1ShowOidColumn=0FakeOidIndex=0Protocol=6.4ReadOnly=0PORT=5432SERVER=localhostDATABASE=MyDatabase Tips and tricks: 1. Disable "Recognize Unique Indexes" every time you link tables. That will allow you to give proper primary keys to Access (you will be prompted). Otherwise, Access do it quite bad. 2- Use Row Versioning 3. Every table must have numeric primary key. Don't use text field as primary key. Access will be confused and you will have "#DELETED#" in your tables. 4. Instead of having JET queries on linked tables, it is better to have good pass-through query. But it doesn't accept parameters, so you will have to combine regular JEt queries with pass-through queries. I use pass-through queries and server-side functions (for calculated columns) that prepare recordset and then filtrate it by regular JET query additionaly (for example: start and end date)... Other possibility is to use server views linked as tables in Access... Greetings Zlatko - Original Message - From: [EMAIL PROTECTED] To: pgsql-general@postgresql.org Sent: Friday, April 22, 2005 6:28 AM Subject: [GENERAL] psqlodbc MSAccess and Postgresql Thanks for the help with /dt... Mike, your post helped me to discover psql command window, I had been trying out the pgAdmin ... I found an interesting article regarding MSAccess as a front end to Postgresql, so I downloaded the psqlodbc installer. I will be getting up the nerve to run the install and go into windows odbc and install that driver so I can use MSAccess with Postgresql ... any tips or caveats appreciated This is the link which is guiding me http://database.sarang.net/database/postgres/postodbc/faq.html
Re: [GENERAL] psqlodbc MSAccess and Postgresql
I'm currently building an Access FE to my PostgreSQL BE. So far it works great. If you're going to be deploying this to multiple users, I'd suggest using a DSN-less connection. That way you don't have to set up a DSN on each user's PC. Mike From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]Sent: Friday, April 22, 2005 12:28 AMTo: pgsql-general@postgresql.orgSubject: [GENERAL] psqlodbc MSAccess and Postgresql Thanks for the help with /dt... Mike, your post helped me to discover psql command window, I had been trying out the pgAdmin ... I found an interesting article regarding MSAccess as a front end to Postgresql, so I downloaded the psqlodbc installer. I will be getting up the nerve to run the install and go into windows odbc and install that driver so I can use MSAccess with Postgresql ... any tips or caveats appreciated This is the link which is guiding me http://database.sarang.net/database/postgres/postodbc/faq.html
Re: [GENERAL] psqlodbc MSAccess and Postgresql
[EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Thanks for the help with /dt... Mike, your post helped me to discover psql command window, I had been trying out the pgAdmin ... I found an interesting article regarding MSAccess as a front end to Postgresql, so I downloaded the psqlodbc installer. I will be getting up the nerve to run the install and go into windows odbc and install that driver so I can use MSAccess with Postgresql ... any tips or caveats appreciated Be sure to check out the FAQs and How-tos at the psqlodbc project site: http://gborg.postgresql.org/project/psqlodbc/projdisplay.php You will find that that Access and PostgreSQL get on well together. You can get by with the default driver settings for the most part; I suggest that you make sure that the row versioning and true = -1 options are set to true. If you want to use the memo datatype in Access, then you will need to check text = longvarchar option. If you have further questions, try posting to the pgsql-odbc list. This is the link which is guiding me _http://database.sarang.net/database/postgres/postodbc/faq.html_ (http://database.sarang.net/database/postgres/postodbc/faq.html) ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[GENERAL] psqlodbc MSAccess and Postgresql
Thanks for the help with /dt... Mike, your post helped me to discover psql command window, I had been trying out the pgAdmin ... I found an interesting article regarding MSAccess as a front end to Postgresql, so I downloaded the psqlodbc installer. I will be getting up the nerve to run the install and go into windows odbc and install that driver so I can use MSAccess with Postgresql ... any tips or caveats appreciated This is the link which is guiding me http://database.sarang.net/database/postgres/postodbc/faq.html