Thread: Change connection (IP, or Databasename)

Change connection (IP, or Databasename)

From
"E. Zorn (RDG-rational)"
Date:
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 wouldn’t
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



Re: Change connection (IP, or Databasename)

From
Jeff Eckermann
Date:
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 wouldn�t
> 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

cursors in asp

From
Dave Cramer
Date:
Is it possible to access a cursor from ASP, if not does the odbc driver
use cursor backed result sets?

Dave
--
Dave Cramer <dave@fastcrypt.com>
fastcrypt


Re: Change connection (IP, or Databasename)

From
"E. Zorn (RDG-rational) postsql"
Date:
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




Re: Change connection (IP, or Databasename)

From
"Henry Alfke"
Date:
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


Re: Change connection (IP, or Databasename)

From
"E. Zorn (RDG-rational) postsql"
Date:
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




Re: Change connection (IP, or Databasename)

From
"Henry Alfke"
Date:
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




cursors in asp

From
Dave Cramer
Date:
Is it possible to access a cursor from ASP, if not does the odbc driver
use cursor backed result sets?

Dave
--
Dave Cramer <dave@fastcrypt.com>
fastcrypt