Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 I cant to connect with mssql

Author  Topic 

politony
Starting Member

1 Post

Posted - 2008-09-04 : 19:35:46
Hi,

I sent you the log, where see the error. Please i will be waiting for your response. Thanks

Tony
------------------------------------------------------------
Time Origin Message
------------ -------------------------- ----------------------------------------
15:39:50.953 Main ETL Runtime, Version: 7.2.002.02, Build: 2006/10/23 12:34 (C) Copyright 1994-2005 Genesys Telecommunications Laboratories, Inc.
15:39:50.953 Main.Env Runtime info: {java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition, sun.boot.library.path=C:\GCTI\MCR\jre\bin, java.vm.version=1.4.2_14-b05, java.vm.vendor=Sun Microsystems Inc., java.vendor.url=http://java.sun.com/, path.separator=;, java.vm.name=Java HotSpot(TM) Client VM, file.encoding.pkg=sun.io, user.country=US, sun.os.patch.level=Service Pack 2, java.vm.specification.name=Java Virtual Machine Specification, user.dir=C:\Program Files\GCTI\Data Mart\ETL_Service\etl_runtime, java.runtime.version=1.4.2_14-b05, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.endorsed.dirs=C:\GCTI\MCR\jre\lib\endorsed, os.arch=x86, java.io.tmpdir=D:\temp\CTIVEN~1\temp\, line.separator=<CR><LF>, java.vm.specification.vendor=Sun Microsystems Inc., user.variant=, os.name=Windows 2003, sun.java2d.fontpath=, java.library.path=C:\WINNT\system32;.;C:\WINNT\system32;C:\Documents and Settings\CTIVenezuela\WINDOWS;C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\Wbem;C:\apps_srv\IBM\Director\bin;C:\Program Files\Common Files\IBM\ICC\cimom\bin;C:\apps_srv\perform\common\globalc\bin\Windows-x86;C:\apps_srv\perform\Patrol3\BEST1\7.3.00\bgs\bin;C:\Program Files\Microsoft SQL Server\80\Tools\BINN;%HYPERION_HOME%\common\ODBC\Merant\5.1\Drivers;D:\apps_pub\BSYS2025;D:\temp\CTIVenezuela\commands, java.specification.name=Java Platform API Specification, java.class.version=48.0, java.util.prefs.PreferencesFactory=java.util.prefs.WindowsPreferencesFactory, os.version=5.2, user.home=C:\Documents and Settings\CTIVenezuela, user.timezone=America/Rio_Branco, java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=Cp1252, java.specification.version=1.4, java.class.path=transform.jar, user.name=CTIVenezuela, java.vm.specification.version=1.0, java.home=C:\GCTI\MCR\jre, sun.arch.data.model=32, user.language=en, java.specification.vendor=Sun Microsystems Inc., awt.toolkit=sun.awt.windows.WToolkit, java.vm.info=mixed mode, java.version=1.4.2_14, java.ext.dirs=C:\GCTI\MCR\jre\lib\ext, sun.boot.class.path=C:\GCTI\MCR\jre\lib\rt.jar;C:\GCTI\MCR\jre\lib\i18n.jar;C:\GCTI\MCR\jre\lib\sunrsasign.jar;C:\GCTI\MCR\jre\lib\jsse.jar;C:\GCTI\MCR\jre\lib\jce.jar;C:\GCTI\MCR\jre\lib\charsets.jar;C:\GCTI\MCR\jre\classes, java.vendor=Sun Microsystems Inc., file.separator=\, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, sun.io.unicode.encoding=UnicodeLittle, sun.cpu.endian=little, sun.cpu.isalist=pentium i486 i386}
15:39:50.953 Main.Options Options: {jdbcurl=jdbc:jtds:sqlserver://lacvenrecas056:1433;DatabaseName=ETL, user=genesys , log=createdb.log, pass=*****, createdb=}
15:39:50.953 Main TRANSFORM started
15:39:51.921 Main SQLException! Exiting ...
SQLState: 08S01
Vendor: 0
Stack Trace:
java.sql.SQLException: Network error IOException: Connection refused: connect
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:372)
at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:178)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at DataMart.ConnectObject.createConnection(Unknown Source)
at DataMart.ConnectObject.createConnection(Unknown Source)
at ETL.Transformer.start(Unknown Source)
at ETL.Transformer.main(Unknown Source)
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(Unknown Source)
at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at net.sourceforge.jtds.jdbc.SharedSocket.createSocketForJDBC3(SharedSocket.java:289)
at net.sourceforge.jtds.jdbc.SharedSocket.<init>(SharedSocket.java:250)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:297)
... 8 more

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-09-04 : 19:41:54
http://weblogs.sqlteam.com/tarad/archive/2008/05/23/60609.aspx

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -