AW: ojb with mssqlserver2000
It works Thank you!!! Christian - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[OT] RE: ojb with mssqlserver2000
Christian, By default, MSSQL installs with ONLY Windows Authentication. To enable SQL Server Authentication, you must open the server properties, open the security tab, and enable SQL Server and Windows Authentication. Wally -Original Message- From: Christian Eugster [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 16, 2004 11:32 AM To: OJB Users List; [EMAIL PROTECTED] Subject: AW: ojb with mssqlserver2000 Hi Charles, thank you for answering! a) Is the host SERVER your local machine ?YES b) Can windows resolve "SERVER" to a TCP/IP host address ? (try ping SERVER at the command line) YES c) Is TCP/IP enabled on your MS SQLServer database ? (try Start/Programs/MS Sql Server/Server Network Utility) NO d) Is your SQL Server listening on the standard port of 1433 ? YES e) try replacing SERVER in your URL to 127.0.0.1 e.g. jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=database;SelectMethod =cursor i finally found the place to activate that TCP/IP channel. Now i meet that following problem: [org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl] ERROR: Error getting Connection from DriverManager with url (jdbc:microsoft:sqlserver://SERVER:1433;Database=database;SelectMethod=curso r) and driver (com.microsoft.jdbc.sqlserver.SQLServerDriver) [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Fehler bei der Anmeldung für den Benutzer 'SERVER\username'. Ursache: Keiner vertrauten SQL Server-Verbindung zugeordnet. /* that means: not bound to a trusted sqlserver connection (sorry for my english) How can i establish a trusted connection? Thank you twice! Christian - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
AW: ojb with mssqlserver2000
Hi Charles, thank you for answering! a) Is the host SERVER your local machine ?YES b) Can windows resolve "SERVER" to a TCP/IP host address ? (try ping SERVER at the command line) YES c) Is TCP/IP enabled on your MS SQLServer database ? (try Start/Programs/MS Sql Server/Server Network Utility) NO d) Is your SQL Server listening on the standard port of 1433 ? YES e) try replacing SERVER in your URL to 127.0.0.1 e.g. jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=database;SelectMethod =cursor i finally found the place to activate that TCP/IP channel. Now i meet that following problem: [org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl] ERROR: Error getting Connection from DriverManager with url (jdbc:microsoft:sqlserver://SERVER:1433;Database=database;SelectMethod=curso r) and driver (com.microsoft.jdbc.sqlserver.SQLServerDriver) [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Fehler bei der Anmeldung für den Benutzer 'SERVER\username'. Ursache: Keiner vertrauten SQL Server-Verbindung zugeordnet. /* that means: not bound to a trusted sqlserver connection (sorry for my english) How can i establish a trusted connection? Thank you twice! Christian - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: ojb with mssqlserver2000
Hi, The jdbc driver is having trouble connecting to the SQL Server machine. My German is a little rusty, (and babelfish not overly helpful), but I suspect it's complaining that it can't connect to the socket. a) Is the host SERVER your local machine ? b) Can windows resolve "SERVER" to a TCP/IP host address ? (try ping SERVER at the command line) c) Is TCP/IP enabled on your MS SQLServer database ? (try Start/Programs/MS Sql Server/Server Network Utility) d) Is your SQL Server listening on the standard port of 1433 ? e) try replacing SERVER in your URL to 127.0.0.1 e.g. jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=database;SelectMethod =cursor HTH Charles. > -Original Message- > From: Christian Eugster [mailto:[EMAIL PROTECTED] > Sent: 16 March 2004 15:33 > To: [EMAIL PROTECTED] > Subject: ojb with mssqlserver2000 > > > Hi > > after I have succeeded to connect to and work with mysql, postgresql, > msaccess i try to use a mssqlserver2000 as backend. > > when i try to connect to the mssqlserver, that runs locally, i get the > following exception message: > > [org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractIm > pl] ERROR: > Error getting Connection from DriverManager with url > (jdbc:microsoft:sqlserver://SERVER:1433;DatabaseName=database; > SelectMethod=c > ursor) and driver (com.microsoft.jdbc.sqlserver.SQLServerDriver) > [Microsoft][SQLServer 2000 Driver for JDBC]Fehler beim > einrichten eines > Sockets. > java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for > JDBC]Fehler > beim einrichten eines Sockets. > at > com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source) > at > com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source) > at > com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source) > at > com.microsoft.jdbc.sqlserver.tds.TDSConnection.(Unknown Source) > at > com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown > Source) > at > com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown > Source) > at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source) > at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source) > at java.sql.DriverManager.getConnection(Unknown Source) > at java.sql.DriverManager.getConnection(Unknown Source) > at > org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImp > l.newConnectio > nFromDriverManager(Unknown Source) > at > org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl$ > ConPoolFactory > .makeObject(Unknown Source) > at > org.apache.commons.pool.impl.GenericObjectPool.borrowObject(Ge > nericObjectPoo > l.java:816) > at > org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl. > getConnectionF > romPool(Unknown Source) > at > org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImp > l.lookupConnec > tion(Unknown Source) > at > org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.getCon > nection(Unknow > n Source) > at > org.apache.ojb.broker.accesslayer.StatementManager.getPrepared > Statement(Unkn > own Source) > at > org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(Unknown > Source) > at > org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(Unknown > Source) > at > org.apache.ojb.broker.accesslayer.RsIterator.(Unknown Source) > at > org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsItera > tor(Unknown > Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIterator > FromQuery(Unkn > own Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFr > omQuery(Unknow > n Source) > at > org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionB > yQuery(Unknown > Source) > at > org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionB > yQuery(Unknown > Source) > at > org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionB > yQuery(Unknown > Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollection > ByQuery(Unknow > n Source) > at > org.apache.ojb.broker.core.DelegatingPersistenceBroker.getColl > ectionByQuery( > Unknown Source) > at > org.apache.ojb.broker.core.DelegatingPersistenceBroker.getColl > ectionByQuery( > Unknown Source) > at ch.eugster.pos.db.Version.select(Version.java:85) > at > ch.eugster.pos.db.Connection.openConnection(Connection.java:49) > at ch.eugster.pos.admin.App.connect(App.java:312) > at ch.eugster.pos.ad
ojb with mssqlserver2000
Hi after I have succeeded to connect to and work with mysql, postgresql, msaccess i try to use a mssqlserver2000 as backend. when i try to connect to the mssqlserver, that runs locally, i get the following exception message: [org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl] ERROR: Error getting Connection from DriverManager with url (jdbc:microsoft:sqlserver://SERVER:1433;DatabaseName=database;SelectMethod=c ursor) and driver (com.microsoft.jdbc.sqlserver.SQLServerDriver) [Microsoft][SQLServer 2000 Driver for JDBC]Fehler beim einrichten eines Sockets. java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Fehler beim einrichten eines Sockets. at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source) at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source) at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source) at com.microsoft.jdbc.sqlserver.tds.TDSConnection.(Unknown Source) at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source) at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source) at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source) at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.newConnectio nFromDriverManager(Unknown Source) at org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl$ConPoolFactory .makeObject(Unknown Source) at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPoo l.java:816) at org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl.getConnectionF romPool(Unknown Source) at org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.lookupConnec tion(Unknown Source) at org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.getConnection(Unknow n Source) at org.apache.ojb.broker.accesslayer.StatementManager.getPreparedStatement(Unkn own Source) at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(Unknown Source) at org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(Unknown Source) at org.apache.ojb.broker.accesslayer.RsIterator.(Unknown Source) at org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(Unkn own Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(Unknow n Source) at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Unknown Source) at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Unknown Source) at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknow n Source) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery( Unknown Source) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery( Unknown Source) at ch.eugster.pos.db.Version.select(Version.java:85) at ch.eugster.pos.db.Connection.openConnection(Connection.java:49) at ch.eugster.pos.admin.App.connect(App.java:312) at ch.eugster.pos.admin.App.main(App.java:127) [org.apache.ojb.broker.accesslayer.JdbcAccessImpl] ERROR: PersistenceBrokerException during the execution of the query: Used ConnectionManager instance could not obtain a connection Used ConnectionManager instance could not obtain a connection org.apache.ojb.broker.PersistenceBrokerException: Used ConnectionManager instance could not obtain a connection at org.apache.ojb.broker.accesslayer.StatementManager.getPreparedStatement(Unkn own Source) at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(Unknown Source) at org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(Unknown Source) at org.apache.ojb.broker.accesslayer.RsIterator.(Unknown Source) at org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(Unkn own Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(Unknow n Source) at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Unknown Source) at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Unknown Source) at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknow n Source) at org.apache.ojb.broker.core
