Re: [pgadmin-support] Error Number :-21747217887
Title: Message Hi Natalie, Can you set logging to Full Debug (under Tools -> Options), restart pgAdmin & recreate the error, and then send the resulting log files please. Thanks, Dave. -Original Message-From: Natalie [mailto:[EMAIL PROTECTED]] Sent: 16 September 2002 21:35To: [EMAIL PROTECTED]Subject: [pgadmin-support] Error Number :-21747217887 Hello I am coming up with a problem on a page which say : Cannot save Value ""to database Field "description" Number -2147217887Description: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. Error soruce :Microsoft OLE DB Provider for ODBC Drivers I need to know if I am missing some information in my data base of my form Natalie Do you Yahoo!?Yahoo! News - Today's headlines
[pgadmin-support] transport Procedural and Function from MS SQL Enterprise Manage to PostgreSQL
hallo, I have PostgreSQL in Linux. I use it with pgAdminII in Wondows2000.how can I transport Procedural and Function from MS SQL Enterprise Manage toPostgreSQL.Thanks!!!rongCREATE FUNCTION dbo.getICNroh (@Bogen_Nr smallint)RETURNS smallint ASBEGIN DECLARE @myRet int--Rohwert der Skala 1 (ICN) ermitteln DECLARE @step01a smallint DECLARE @step02a smallint DECLARE @step01b smallint DECLARE @step02b smallint SELECT @step01a = Antwort FROM PAI_ANTWORTEN WHERE ITEM_NR = 75 ANDBogen_Nr = @Bogen_Nr SELECT @step01b = Antwort FROM PAI_ANTWORTEN WHERE ITEM_NR = 115 ANDBogen_Nr = @Bogen_Nr SELECT @step02a = Antwort FROM PAI_ANTWORTEN WHERE ITEM_NR = 4 ANDBogen_Nr = @Bogen_Nr SELECT @step02b = Antwort FROM PAI_ANTWORTEN WHERE ITEM_NR = 44 ANDBogen_Nr = @Bogen_Nr SELECT @myRet = ABS(@Step01a - @step01b) + ABS(@Step02a - @step02b)--Wert zurückgeben RETURN @myRetENDCREATE PROCEDURE sp_PAI_Werte @Bogen_Nr int AScreate table #tmpPAI_Rohwerte (Skala_Nr smallint primary key, Rohwertsmallint)--Rohwerte ermitteln (außer Skala 1 ICN)INSERT into #tmpPAI_RohwerteSELECT dbo.PAI_SKALEN.Skala_Nr, sum((CONVERT(tinyint, dbo.PAI_ANTWORTEN.Antwort) + dbo.PAI_KEYcalc.toAdd) *dbo.PAI_KEYcalc.Faktor) AS RohwertFROM dbo.PAI_SKALEN INNER JOIN dbo.PAI_ITEMinSKALA ON dbo.PAI_SKALEN.Skala_Nr =dbo.PAI_ITEMinSKALA.Skala_Nr INNER JOIN dbo.PAI_ITEMS ON dbo.PAI_ITEMinSKALA.Item_Nr =dbo.PAI_ITEMS.Item_Nr INNER JOIN dbo.PAI_ANTWORTEN ON dbo.PAI_ITEMS.Item_Nr =dbo.PAI_ANTWORTEN.Item_Nr INNER JOIN dbo.PAI_KEYcalc ON dbo.PAI_ITEMinSKALA.keyDir =dbo.PAI_KEYcalc.keyDirWHERE (dbo.PAI_ANTWORTEN.Antwort <> ' ') and PAI_Antworten.Bogen_Nr =@Bogen_NrGROUP BY dbo.PAI_SKALEN.Skala_Nr--ICN Rohwert einfügenIF EXISTS(SELECT * from #tmpPAI_Rohwerte WHERE Skala_Nr = 1) UPDATE #tmpPAI_Rohwerte SET Rohwert = dbo.getICNroh(@Bogen_Nr) WHERESkala_Nr = 1ELSE INSERT INTO #tmpPAI_Rohwerte (Skala_Nr, Rohwert)VALUES(1,dbo.getICNroh(@Bogen_Nr))--T-Werte bereitstellenSELECT dbo.PAI_SKALEN.Skala_Nr, dbo.PAI_SKALEN.Kuerzel_D AS Kuerzel,dbo.PAI_SKALEN.Label_D AS Label, #tmpPAI_Rohwerte.rohwert as rohwert, ROUND(50 + (#tmpPAI_Rohwerte.rohwert -dbo.PAI_SKALEN.M) *10 / dbo.PAI_SKALEN.SD, 0) AS TWertFROM dbo.PAI_SKALEN LEFT OUTER JOIN #tmpPAI_Rohwerte ON dbo.PAI_SKALEN.Skala_Nr =#tmpPAI_Rohwerte.skala_nrGO
Re: [pgadmin-support] Bug of feature?
> -Original Message- > From: Armbrust, Daniel C. [mailto:[EMAIL PROTECTED]] > Sent: 16 September 2002 18:08 > To: [EMAIL PROTECTED] > Subject: [pgadmin-support] Bug of feature? > > > Is it a bug or a feature, that when you import an access > database, the list of existing tables you are given to choose > from in the database migration wizard includes the create > table queries that are listed in the access database? > > I haven't tried to import one... don't know what results to > expect. Just curious, > > Dan Hi Dan, Do you mean 'Queries' or whatever Access calls them? If so, if I remember correctly, that was done on purpose to make it possible to migrate data from views - just for added flexibility. Regards, Dave. ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [pgadmin-support] pgadtransport Procedural and Function from MS SQL Enterprise Manage to PostgreSQL
Title: Message You will have to port your functions and procedures manually I'm afraid. Regards, Dave. -Original Message-From: XIE, Rong [mailto:[EMAIL PROTECTED]] Sent: 17 September 2002 09:59To: [EMAIL PROTECTED]Subject: [pgadmin-support] transport Procedural and Function from MS SQL Enterprise Manage to PostgreSQL hallo, I have PostgreSQL in Linux. I use it with pgAdminII in Wondows2000.how can I transport Procedural and Function from MS SQL Enterprise Manage toPostgreSQL.Thanks!!!rongCREATE FUNCTION dbo.getICNroh (@Bogen_Nr smallint)RETURNS smallint ASBEGIN DECLARE @myRet int--Rohwert der Skala 1 (ICN) ermitteln DECLARE @step01a smallint DECLARE @step02a smallint DECLARE @step01b smallint DECLARE @step02b smallint SELECT @step01a = Antwort FROM PAI_ANTWORTEN WHERE ITEM_NR = 75 ANDBogen_Nr = @Bogen_Nr SELECT @step01b = Antwort FROM PAI_ANTWORTEN WHERE ITEM_NR = 115 ANDBogen_Nr = @Bogen_Nr SELECT @step02a = Antwort FROM PAI_ANTWORTEN WHERE ITEM_NR = 4 ANDBogen_Nr = @Bogen_Nr SELECT @step02b = Antwort FROM PAI_ANTWORTEN WHERE ITEM_NR = 44 ANDBogen_Nr = @Bogen_Nr SELECT @myRet = ABS(@Step01a - @step01b) + ABS(@Step02a - @step02b)--Wert zurückgeben RETURN @myRetENDCREATE PROCEDURE sp_PAI_Werte @Bogen_Nr int AScreate table #tmpPAI_Rohwerte (Skala_Nr smallint primary key, Rohwertsmallint)--Rohwerte ermitteln (außer Skala 1 ICN)INSERT into #tmpPAI_RohwerteSELECT dbo.PAI_SKALEN.Skala_Nr, sum((CONVERT(tinyint, dbo.PAI_ANTWORTEN.Antwort) + dbo.PAI_KEYcalc.toAdd) *dbo.PAI_KEYcalc.Faktor) AS RohwertFROM dbo.PAI_SKALEN INNER JOIN dbo.PAI_ITEMinSKALA ON dbo.PAI_SKALEN.Skala_Nr =dbo.PAI_ITEMinSKALA.Skala_Nr INNER JOIN dbo.PAI_ITEMS ON dbo.PAI_ITEMinSKALA.Item_Nr =dbo.PAI_ITEMS.Item_Nr INNER JOIN dbo.PAI_ANTWORTEN ON dbo.PAI_ITEMS.Item_Nr =dbo.PAI_ANTWORTEN.Item_Nr INNER JOIN dbo.PAI_KEYcalc ON dbo.PAI_ITEMinSKALA.keyDir =dbo.PAI_KEYcalc.keyDirWHERE (dbo.PAI_ANTWORTEN.Antwort <> ' ') and PAI_Antworten.Bogen_Nr =@Bogen_NrGROUP BY dbo.PAI_SKALEN.Skala_Nr--ICN Rohwert einfügenIF EXISTS(SELECT * from #tmpPAI_Rohwerte WHERE Skala_Nr = 1) UPDATE #tmpPAI_Rohwerte SET Rohwert = dbo.getICNroh(@Bogen_Nr) WHERESkala_Nr = 1ELSE INSERT INTO #tmpPAI_Rohwerte (Skala_Nr, Rohwert)VALUES(1,dbo.getICNroh(@Bogen_Nr))--T-Werte bereitstellenSELECT dbo.PAI_SKALEN.Skala_Nr, dbo.PAI_SKALEN.Kuerzel_D AS Kuerzel,dbo.PAI_SKALEN.Label_D AS Label, #tmpPAI_Rohwerte.rohwert as rohwert, ROUND(50 + (#tmpPAI_Rohwerte.rohwert -dbo.PAI_SKALEN.M) *10 / dbo.PAI_SKALEN.SD, 0) AS TWertFROM dbo.PAI_SKALEN LEFT OUTER JOIN #tmpPAI_Rohwerte ON dbo.PAI_SKALEN.Skala_Nr =#tmpPAI_Rohwerte.skala_nrGO
[pgadmin-support] pgAdmin II Migration Wizard
Hi,
I'm trying to use
the Migration wizard, but I'm having the following error:
2002-09-17 14:17:52 -
***2002-09-17
14:17:52 - Error2002-09-17 14:17:52 -
***2002-09-17
14:17:52 - Error in pgAdmin II:frmMain.mnuPluginsPlg_Click: 13 - Type
mismatch2002-09-17 14:17:52 - Windows Version: Windows 2000 v5.0 build 2195
Service Pack 32002-09-17 14:17:52 - pgSchema Version: 1.0.2492002-09-17
14:17:52 - MDAC Version: 2.72002-09-17 14:17:52 - DBMS Version: 07.02.0001
PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC 2.962002-09-17
14:17:52 - Connection String (Master Connection): Provider=MSDASQL.1;Extended
Properties="DRIVER={PostgreSQL};DATABASE=template1;SERVER=agua;PORT=5432;UID=ccamacho;PWD=;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=4096;UnknownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize=65536;Debug=0;CommLog=0;Optimizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=0;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;LFConversion=1;UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0"
The language of
win2k is spanish.
Do you have any idea
??
Regards,
Christian
DISCLAIMER: This message may contain confidential information. If you are not the intended recipient please advise the sender and erase the message. Thank you.
Re: [pgadmin-support] pgAdmin II Migration Wizard
Title: Message
Hi,
It
looks like you have the wrong version of the plugin for your version of pgAdmin.
Check for the correct version at http://www.pgadmin.org/downloads. The
version numbers need to match.
Regards, Dave.
-Original Message-From: Camacho,
Christian [mailto:[EMAIL PROTECTED]] Sent: 17 September 2002
19:25To: [EMAIL PROTECTED]Subject:
[pgadmin-support] pgAdmin II Migration Wizard
Hi,
I'm trying to use
the Migration wizard, but I'm having the following error:
2002-09-17 14:17:52 -
***2002-09-17
14:17:52 - Error2002-09-17 14:17:52 -
***2002-09-17
14:17:52 - Error in pgAdmin II:frmMain.mnuPluginsPlg_Click: 13 - Type
mismatch2002-09-17 14:17:52 - Windows Version: Windows 2000 v5.0 build
2195 Service Pack 32002-09-17 14:17:52 - pgSchema Version:
1.0.2492002-09-17 14:17:52 - MDAC Version: 2.72002-09-17 14:17:52 -
DBMS Version: 07.02.0001 PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by
GCC 2.962002-09-17 14:17:52 - Connection String (Master Connection):
Provider=MSDASQL.1;Extended
Properties="DRIVER={PostgreSQL};DATABASE=template1;SERVER=agua;PORT=5432;UID=ccamacho;PWD=;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=4096;UnknownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize=65536;Debug=0;CommLog=0;Optimizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=0;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;LFConversion=1;UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0"
The language of
win2k is spanish.
Do you have any
idea ??
Regards,
Christian
DISCLAIMER: This message may contain
confidential information. If you are not the intended recipient please advise
the sender and erase the message. Thank
you.
