Results 1 to 10 of 10
  1. #1
    Join Date
    May 2010
    Posts
    6

    Unanswered: 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?

  2. #2
    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.

  3. #3
    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"/>

  4. #4
    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"/>

  5. #5
    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?

  6. #6
    Join Date
    May 2010
    Posts
    6
    No one can think of some ideas?

  7. #7
    Join Date
    May 2010
    Location
    India
    Posts
    84
    Provided Answers: 2
    Did you create DSN POOL and DSN ANAGEN using ODBC Data Source Administrator in your laptop?

    Satya

  8. #8
    Join Date
    May 2010
    Posts
    6
    Si, l'installazione e l'esecuzione del db2 viene fatta con un utente amministrator

  9. #9
    Join Date
    May 2010
    Posts
    6
    Yes, installing and running the db2 is done by a user amministrator

  10. #10
    Join Date
    May 2010
    Location
    India
    Posts
    84
    Provided Answers: 2
    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...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •