error connecting to sql 2k from an app

Hi,
I rec'd this error.
open dbtables error: General error: Unable to write to file buffer dbtest.
when I connect to a sql 2k db from an test app.
Any ideas?
thanksCan you show the code that is trying to connect? This doesn't look like a
SQL Server error as far as I can tell.
"mecn" <mecn2002@.yahoo.com> wrote in message
news:OMglZPIPGHA.1676@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I rec'd this error.
> open dbtables error: General error: Unable to write to file buffer dbtest.
> when I connect to a sql 2k db from an test app.
> Any ideas?
> thanks
>|||I don't really have the source code.
I think the same as you--windows' problem.
Everytime the app runs it generated a temp file > 2GB.
I have no idea why the temp file gets generated when the app sends a query
statment.
That is the problem
Thanks,
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:uwrjxcIPGHA.344@.TK2MSFTNGP11.phx.gbl...
> Can you show the code that is trying to connect? This doesn't look like a
> SQL Server error as far as I can tell.
>
>
> "mecn" <mecn2002@.yahoo.com> wrote in message
> news:OMglZPIPGHA.1676@.TK2MSFTNGP09.phx.gbl...
>

Error connecting from classic ASP

I'm haveing some problems with using SQL Server in a classic ASP app.

When trying to connect with the db I get the error:

Microsoft SQL Native Client error '80004005'

TCP Provider: No connection could be made because the target machine actively refused it.

The Windows 2003 server runs both the SQL server 2005 express and IIS.

Connectionstring: "Provider=SQLNCLI;Server=KSP;Database=KSB;UID=sa;PWD=;"

I don't have a good answer for this one; it seems a bit like a permissions issue, you might want to check what user context your ASP app is running in and make sure that user has permission to the database file or server.

You should also consider asking this question in the .NET Data Access forum or in the ASP.NET fourms. The folks that hang out there have probably had more experience with ASP than I have.

Regards,

Mike Wachal
SQL Express team

-
Check out my tips for getting your answer faster and how to ask a good question: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=307712&SiteID=1

|||

Sql server express is a named instance, so you need to specify <servername>\sqlexpress in you connection string.

Check this out.

http://blogs.msdn.com/sql_protocols/archive/2006/03/23/558651.aspx

|||

Thank both of you for your advice. It was the <servername>\sqlexpress which was the problem.

Error Code -2147221296 (0x800400D0)

Can anyone point me in the right direction for an explination of this code? I can't find any hits on it.

I have a VB6 sample app that reads a T-SQL script from a file and feeds it to SQLServer.ExecuteImmediate. All very pedestiran. When the script works it works great. When it doesn't, say a bad table name in a select, the function ends with Error Code of -2147221296 (0x800400D0) and a Description that indicates the error in some cases. In another case (a DCOM exe), the description is always "Method '~' of '~' failed". Does the caller being an out-of-processs class matter?

Is this a DMO code, a ODBC or OLE/DB code, a COM or OLE code, or what? I've been looking for this answer for a long time now. Any help would be much appreciated!

Additional info:

If I use Database.ExecuteImmediate instead of SQLServer.ExecuteImmediate then I get a real DMO error code...

Error Adding SQL Server Login Properties

Hello,
I have SQL 200 SP3 box that has a web app with a hard coded user; I
tried to re-add the user after it was deleted.
I now get the following error when trying to add the database access:
"Error 21002 [SQL-DMO] user 'unsername' already exists."
Any help would be greatly appreciated.
I fixed my issue by running the following:
use my_db;
go
sp_change_users_login AUTO_FIX, 'my_user'
go
Hulicat wrote:
> Hello,
> I have SQL 200 SP3 box that has a web app with a hard coded user; I
> tried to re-add the user after it was deleted.
> I now get the following error when trying to add the database access:
> "Error 21002 [SQL-DMO] user 'unsername' already exists."
>
> Any help would be greatly appreciated.

Error Adding SQL Server Login Properties

Hello,
I have SQL 200 SP3 box that has a web app with a hard coded user; I
tried to re-add the user after it was deleted.
I now get the following error when trying to add the database access:
"Error 21002 [SQL-DMO] user 'unsername' already exists."
Any help would be greatly appreciated.I fixed my issue by running the following:
use my_db;
go
sp_change_users_login AUTO_FIX, 'my_user'
go
Hulicat wrote:
> Hello,
> I have SQL 200 SP3 box that has a web app with a hard coded user; I
> tried to re-add the user after it was deleted.
> I now get the following error when trying to add the database access:
> "Error 21002 [SQL-DMO] user 'unsername' already exists."
>
> Any help would be greatly appreciated.