If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > db2 prepare: the property connection is not initialized

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 05-19-10, 11:20
claudiobando claudiobando is offline
Registered User
 
Join Date: May 2010
Posts: 6
db2 prepare: the property connection is not initialized

Hi I installed db2 9.7 server in a Windows 7. As you try to change the settings of connection string always appears the error that the connection has not been initialized there any indication of the installer against a DB2 client machine or need some special settings?
Reply With Quote
  #2 (permalink)  
Old 05-20-10, 02:48
Amarnath Reddy Amarnath Reddy is offline
Registered User
 
Join Date: Apr 2010
Posts: 10
I think you missed something in the connection string, can you copy connection string here, so that easy to understand wt you missed.
Reply With Quote
  #3 (permalink)  
Old 05-20-10, 06:04
claudiobando claudiobando is offline
Registered User
 
Join Date: May 2010
Posts: 6
This is the connection string in the web server where I use Windows Server 2003 and DB2 client that connects to DB2 server.
In a laptop I need to have both the web application and also the database. The same connection string gives me the problem that I reported

<add name="Main" connectionString="DSN=POOL;UID=db2admin;PWD=db2adm in"/>
<add name="Anagrafe" connectionString="DSN=ANAGEN;UID=db2admin;PWD=db2a dmin"/>
Reply With Quote
  #4 (permalink)  
Old 05-20-10, 10:06
Amarnath Reddy Amarnath Reddy is offline
Registered User
 
Join Date: Apr 2010
Posts: 10
Try this:

<add name="Main" connectionString="DSN=POOL;UID=db2admin;PWD=db2adm in;port=port_no;protocol=TCPIP"/>
<add name="Anagrafe" connectionString="DSN=ANAGEN;UID=db2admin;PWD=db2a dmin;port=port_no;protocol=TCPIP"/>
Reply With Quote
  #5 (permalink)  
Old 05-20-10, 12:42
claudiobando claudiobando is offline
Registered User
 
Join Date: May 2010
Posts: 6
I tried to change the connection string but does not solve anything. The error that appears is always the same. It 'must install a special version of DB2 server in a client machine with Windows 7?
Reply With Quote
  #6 (permalink)  
Old 05-26-10, 10:28
claudiobando claudiobando is offline
Registered User
 
Join Date: May 2010
Posts: 6
No one can think of some ideas?
Reply With Quote
  #7 (permalink)  
Old 05-26-10, 11:15
stiruvee stiruvee is offline
Registered User
 
Join Date: May 2010
Location: India
Posts: 34
Did you create DSN POOL and DSN ANAGEN using ODBC Data Source Administrator in your laptop?

Satya
Reply With Quote
  #8 (permalink)  
Old 05-27-10, 07:07
claudiobando claudiobando is offline
Registered User
 
Join Date: May 2010
Posts: 6
Si, l'installazione e l'esecuzione del db2 viene fatta con un utente amministrator
Reply With Quote
  #9 (permalink)  
Old 05-27-10, 07:13
claudiobando claudiobando is offline
Registered User
 
Join Date: May 2010
Posts: 6
Yes, installing and running the db2 is done by a user amministrator
Reply With Quote
  #10 (permalink)  
Old 05-27-10, 09:21
stiruvee stiruvee is offline
Registered User
 
Join Date: May 2010
Location: India
Posts: 34
Hi,

Test connection for both DSNs (POOL and ANAGEN) in Microsoft ODBC Data Source Administrator first. It is possible that the DSN settings were not set properly.


Satya...
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On