SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Database not available

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
Database not available
Author Message
Jason Volpe



Joined: 04 Dec 2005
Posts: 1

Post Database not available Reply with quote

I just installed DB Audit 2.7, restarted my sql
server, and now when i try to connect it tells
me this error:

"Database not available

DBMS MSS Microsoft SQL Server is not supported in your
current installation."

What am I missing here?

Sun Dec 04, 2005 6:50 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6506

Post Re: Database not available Reply with quote

Looks like your SQL Server client is not in the system search path. Can you connect using ODBC driver?

: I just installed DB Audit 2.7, restarted my sql
: server, and now when i try to connect it tells
: me this error: "Database not available

: DBMS MSS Microsoft SQL Server is not supported in your
: current installation."

: What am I missing here?

Sun Dec 04, 2005 8:04 pm View user's profile Send private message
Joe Oppedisano



Joined: 20 Jan 2006
Posts: 3

Post Re: Database not available Reply with quote

I have the exact same problem. I can connect via normal ODBC under Control Panel,
but I can't connect via MSS. Not sure what you mean by 'SQL Server client is not in the system search path"
Any Any other suggestions ?
thanks

: Looks like your SQL Server client is not in the system search path. Can you
: connect using ODBC driver?

Mon Jan 23, 2006 7:08 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6506

Post Re: Database not available Reply with quote

This is because "C:\Program Files\Microsoft SQL Server\MSSQL\Binn" directory is not listed in the PATH environment variable and so files from this directory cannot be found. If SQL Server is instaled somewhere else you need to use the correct path. In case if SQL Server client (DB-lib) is not installed you need to install it from the CD.

PS. In case if you need help with chnaging the sstem search path... here is how.
1. Right click My Computer icon on the Desktop
2. In the popup menu select Properties item
3. Click Advanced tab page
4. Click Environment Variables button
5. Select PATH syste variable and click the Edit button
6. In the Value field type or paste path to directory where SQL Server client is located (pth to the BinN) directory.
7. Save all changes and restart DB Audit Console

: I have the exact same problem. I can connect via normal ODBC under Control
: Panel,
: but I can't connect via MSS. Not sure what you mean by 'SQL Server client is
: not in the system search path"
: Any Any other suggestions ?
: thanks

Mon Jan 23, 2006 7:49 pm View user's profile Send private message
Joe Oppedisano



Joined: 20 Jan 2006
Posts: 3

Post Re: Database not available Reply with quote

Thanks for your quick response, however ufortunately, it did not solve my problem.
I checked my SQL server PATH environment and it did not have the path as you
suggested, so I added it in. Tested it but same old error.
PS1 I should also mention that I tried the same thing on another XP Client PC using
MSS connectivity (connected to the save SQL server) and it worked fine.
Is there something on the local XP Client that is not right ?

PS2 I tried connecting via the OLE Microsoft SQL Server (ADC) driver
and on the failed PC above it connected fine. Should I just use this
driver and forget about MSS ?
thanks

: This is because "C:\Program Files\Microsoft SQL Server\MSSQL\Binn"
: directory is not listed in the PATH environment variable and so files from
: this directory cannot be found. If SQL Server is instaled somewhere else
: you need to use the correct path. In case if SQL Server client (DB-lib) is
: not installed you need to install it from the CD.

: PS. In case if you need help with chnaging the sstem search path... here is
: how.
: 1. Right click My Computer icon on the Desktop
: 2. In the popup menu select Properties item
: 3. Click Advanced tab page
: 4. Click Environment Variables button
: 5. Select PATH syste variable and click the Edit button
: 6. In the Value field type or paste path to directory where SQL Server client
: is located (pth to the BinN) directory.
: 7. Save all changes and restart DB Audit Console

Mon Jan 23, 2006 8:14 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6506

Post Re: Database not available Reply with quote

Since you can connect using ODBC and OLE I suggest that you use ODBC whenever possible and for reports use OLE. ODBC appears to be more stable but it has a 255-char limit on the size of text values which could be lead to some text cut in a couple of reports in long text columns such as SQL Query Text column.

: Thanks for your quick response, however ufortunately, it did not solve my
: problem.
: I checked my SQL server PATH environment and it did not have the path as you
: suggested, so I added it in. Tested it but same old error.
: PS1 I should also mention that I tried the same thing on another XP Client PC
: using
: MSS connectivity (connected to the save SQL server) and it worked fine.
: Is there something on the local XP Client that is not right ?

: PS2 I tried connecting via the OLE Microsoft SQL Server (ADC) driver
: and on the failed PC above it connected fine. Should I just use this
: driver and forget about MSS ?
: thanks

Mon Jan 23, 2006 9:45 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.