Re: Change connection (IP, or Databasename) - Mailing list pgsql-odbc

please take a look at

http://gborg.postgresql.org/project/psqlodbc/genpage.php?howto-accessvba


with the Sub Link_ODBCTbl() you can link
your tables automatically with vba


an example:


Public Function pgtest()
Dim DB As Database
Dim t As TableDef

Set DB = CurrentDb
Set t = New TableDef


t.Name = "mytable"
t.Connect =
"ODBC;database=mydatabase;uid=myusername;pwd=mypassword;dsn=mypostgresqlodbc
dsn;"
t.SourceTableName = "public.mytable"

DB.TableDefs.Append t
End Function


regards
henry




-----Ursprungliche Nachricht-----
Von: pgsql-odbc-owner@postgresql.org
[mailto:pgsql-odbc-owner@postgresql.org]Im Auftrag von E. Zorn
(RDG-rational) postsql
Gesendet: Freitag, 5. September 2003 09:18
An: Jeff Eckermann; pgsql-odbc@postgresql.org
Betreff: Re: [ODBC] Change connection (IP, or Databasename)


hi again,
I do so, but exact the relinking of the database is the problem.

I the new result of the frontend is ready for using in production
environment, I always have to relink / reconnect the frontend to the
"on air" database.
In my frontend I use the tables without the header "public_" witch
is provided from the server. I now have to relink all the tables and
after that I have to rename the tables (erase the "public_"). This takes a
long time (lot's of tables :-) ), isn't there a shorter method ?

thanks

-----Ursprungliche Nachricht-----
Von: Jeff Eckermann [mailto:jeff_eckermann@yahoo.com]
Gesendet: Donnerstag, 4. September 2003 22:41
An: edv@rdg-rational.de; pgsql-odbc@postgresql.org
Betreff: Re: [ODBC] Change connection (IP, or Databasename)


Not sure what you are asking...  If you want to create
a copy of your production database for
development/testing purposes, the easiest way is:

CREATE DATABASE myseconddatabase WITH TEMPLATE
myfirstdatabase;

Then just create a new DSN pointing to the new
database (or change your code, if you are not using a
DSN).  You would need to relink your tables also.

--- "E. Zorn (RDG-rational)" <edv@rdg-rational.de>
wrote:
> hi,
> I am using Access as a front-end for postgresql via
> ODBC.
>
> The postgresql-server is hosted on a separate
> linux-computer.
>
> I like to change the database on the SQL-server for
> developing or
> change the IP of the connected SQL-server so that
> the original data wouldnt
> be changed.
>
> Does anybody know a quick and comfortable way to do
> this. I know the
> possibility of importing the whole tables once again
> but they all have a
> header like "public_" which I have than manually to
> change.
>
> Elmar Zorn
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster


__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com




---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings