Forum Stats

  • 3,855,199 Users
  • 2,264,473 Discussions
  • 7,905,928 Comments

Discussions

ERROR 0GG-00146 FOR SQLSERVER 2000

827213
827213 Member Posts: 4
edited Jan 5, 2011 9:20PM in GoldenGate
Hi
I used oggs 11g for sqlserver 2000 on WinXp sp3,
when I started the extract named exbs
it can be a running stutas ;
my parameter file setting are :
-----------------------------------------------------------------------------
extract exbs
seTenv (ODBCINI=C:\WINDOWS\ODBC.INI)
SOURCEDB MSTZSW , USERID SA , PASSWORD oracle
RMTHOST 127.0.0.1 , MGRPORT 7810
RMTTRAIL ./DIRDAT/bs
table dbo.* ;
--------------------------------------------------------------------------
after a lot of minute passed , it will be abending ;
the report are the folloowing :

====================================

Database Version :
Microsoft SQL Server
verison 08.00.0194
odbc version 03.52.0000


database language and character set :

Warning : unable to detemine the application and database codepage settings.
Please refer to user manual for more information .

2010-12-29 14:24:23 INFO OGG-01226 Socket buffer size set to 27985 (flush size 27985 ) .
............... OGG-01055 Recovery initilazation completed for target file ./dirdat/bs000003 , at RBA 812.
................................. OGG-01478 Output file ./dirdat/bs is using format RELEASE 10.4/11.1.
................................... OGG-01026 Rolling over remote file ./dirdat/bs000004.
................................... OGG-01053 Recovery i completed for target file ./dirdat/bs000003 , at RBA 812.
................................... OGG-01057 Recovery completed for all targets.
................................... OGG-00182 VAM API running in single-threaded mode.
................................... OGG-01515 Positioning to begin time..........

Source Context :
SourceModule : [ggvam.gen]
SourceID : [../gglib/ggvam/cvamgen.cpp]
SourceFuntion : [com_goldengate_vam: : CVamGen::vamInitialize ]
SourceLine : [418]
time ERROR OGG-00146 VAM funtion VAMInitialize returnde unexpected resutl : error 600 -VAM Client Report <MSSqlVam :<1> [CLogReader ::Open] [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exists or denied . Error (-2147467259) : [DBNETLIB] [ConnectionOpen (Connect()).]SQL Server does not exists or denied . >.
tmie ERROR OGG-01668 PROCESS ABENDING.

--------------------------------------------------------------------------------------------------

Hao can I do to solution this ERROR ,
or What is the reason .


Can some body help me.

I can ensure the odbc can Connectivity by use sourcedb mstzsw , userid sa , password oracle
Tagged:

Answers

This discussion has been closed.