Thread: Change connection (IP, or Databasename)
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
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
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
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
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
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
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
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