Kodyaz Development Resources

SqlConnection trouble

Sat, 22 Nov 2008 22:27:44 GMT

Hello I am trying to open an SqlConnection and recieveing this error and don't know how to relove it. I closed theconnection in the Server Explorer in MSVS.

"An attempt to attach an auto-named database for file FBasic8.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share."

Here is the code I am trying to use.

string destConnectionString = "Data Source=.\\SQLEXPRESS;AttachDbFilename=FBasic8.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";

using (SqlConnection destinationConnection =

new SqlConnection(destConnectionString))

{

destinationConnection.Open(); Error here

// Set up the bulk copy object.

using (SqlBulkCopy bulkCopy =

new SqlBulkCopy(destinationConnection))

{

bulkCopy.DestinationTableName =

"Client";

// Set up the column mappings by name.

SqlBulkCopyColumnMapping mapID =

new SqlBulkCopyColumnMapping("Code", "Code");

bulkCopy.ColumnMappings.Add(mapID);

SqlBulkCopyColumnMapping mapName =

new SqlBulkCopyColumnMapping("FirstName", "FirstName");

bulkCopy.ColumnMappings.Add(mapName);

SqlBulkCopyColumnMapping mapMumber =

new SqlBulkCopyColumnMapping("LastName", "LastName");

bulkCopy.ColumnMappings.Add(mapMumber);

// Write from the source to the destination.

try

{

bulkCopy.WriteToServer(reader);

}

catch (Exception ex)

{

Console.WriteLine(ex.Message);

}

finally

{

// Close the SqlDataReader. The SqlBulkCopy

// object is automatically closed at the end

// of the using block.

reader.Close();

}

Thanks Jon

Error: 17058, Severity: 16, State: 1.

Sat, 22 Nov 2008 22:03:47 GMT

Hi Fellows,

I get this error message when trying to start the sql server. Error log doesnot mention of any error. There is only one user account of the system.

It shows that all the services are running and properties of the services is set to Local system.

C:\>cd \Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn>sqlservr.exe
2008-11-23 21:26:29.45 Server Authentication mode is WINDOWS-ONLY.
2008-11-23 21:26:32.59 Server Error: 17058, Severity: 16, State: 1.
2008-11-23 21:26:32.59 Server initerrlog: Could not open error log file 'C:
\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'. Operating syste
m error = 32(The process cannot access the file because it is being used by anot
her process.).
2008-11-23 21:26:32.64 Server Error: 17054, Severity: 16, State: 1.
2008-11-23 21:26:32.64 Server The current event was not reported to the Win
dows Events log. Operating system error = 1502(The event log file is full.). You
may need to clear the Windows Events log if it is full.
2008-11-23 21:26:32.95 Server Error: 17058, Severity: 16, State: 1.
2008-11-23 21:26:32.95 Server initerrlog: Could not open error log file 'C:
\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'. Operating syste
m error = 32(The process cannot access the file because it is being used by anot
her process.).
2008-11-23 21:26:33.26 Server Error: 17058, Severity: 16, State: 1.
2008-11-23 21:26:33.26 Server initerrlog: Could not open error log file 'C:
\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'. Operating syste
m error = 32(The process cannot access the file because it is being used by anot
her process.).
2008-11-23 21:26:33.57 Server Error: 17058, Severity: 16, State: 1.
2008-11-23 21:26:33.57 Server initerrlog: Could not open error log file 'C:
\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'. Operating syste
m error = 32(The process cannot access the file because it is being used by anot
her process.).
2008-11-23 21:26:33.89 Server Error: 17058, Severity: 16, State: 1.
2008-11-23 21:26:33.89 Server initerrlog: Could not open error log file 'C:
\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'. Operating syste
m error = 32(The process cannot access the file because it is being used by anot
her process.).
2008-11-23 21:26:34.20 Server Error: 17058, Severity: 16, State: 1.
2008-11-23 21:26:34.20 Server initerrlog: Could not open error log file 'C:
\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'. Operating syste
m error = 32(The process cannot access the file because it is being used by anot
her process.).
2008-11-23 21:26:34.51 Server Error: 17058, Severity: 16, State: 1.
2008-11-23 21:26:34.51 Server initerrlog: Could not open error log file 'C:
\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'. Operating syste
m error = 32(The process cannot access the file because it is being used by anot
her process.).
2008-11-23 21:26:34.82 Server Error: 17058, Severity: 16, State: 1.
2008-11-23 21:26:34.82 Server initerrlog: Could not open error log file 'C:
\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'. Operating syste
m error = 32(The process cannot access the file because it is being used by anot
her process.).
2008-11-23 21:26:35.14 Server Error: 17058, Severity: 16, State: 1.
2008-11-23 21:26:35.14 Server initerrlog: Could not open error log file 'C:
\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'. Operating syste
m error = 32(The process cannot access the file because it is being used by anot
her process.).
2008-11-23 21:26:35.45 Server Error: 17058, Severity: 16, State: 1.
2008-11-23 21:26:35.45 Server initerrlog: Could not open error log file 'C:
\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'. Operating syste
m error = 32(The process cannot access the file because it is being used by anot
her process.).

Time out on reading data from table.

Sat, 22 Nov 2008 20:29:46 GMT

Hi
Im new in this area so what i need is general direction to solve some problem i have.
I have table that created like this

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[DataTable](
[frame] [varbinary](max) NULL,
[timestamp] [bigint] NOT NULL,
[flags] [tinyint] NULL,
CONSTRAINT [DataTable] PRIMARY KEY CLUSTERED
(
[timestamp] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

One process (.NET application) continuously insert data into table using SqlBulkCopy. ~ every 15 minutes or so SqlBulCopy inserts ~9000 records (about 15 MB in total) into this table.
Other process (ODBC client)tries to access this table and search for some record using this query

select top 1 timestamp from DataTable where timestamp
Sometimes query runs in second, but sometimes its rises "Timeout expired" exception .
Can anybody advise me in which way i should look to find solution to this problem?
Thanks

How to access Mirror Database with out main database failover?

Fri, 21 Nov 2008 22:29:10 GMT

Hi Experts,

I have a Database with lorge amount of Data. I don't want to distrube this database instaed of this, I plan to access through Mirror Database. But the Mirror Database we can't access directly. If the main database server has failover, then only we can access data from Mirror Database.

How can we access data from mirror database with out main database failover?

Please help me to solve this problem.

Thanks in advance,

Manian.R

SQl Server 2005 JDBC Driver 1.2 error

Fri, 21 Nov 2008 01:19:43 GMT

We are running Jboss on Windows 2003 Enterprise edition which is connecting to 64 bit SQL Server 2005 Enterprise edition running on a cluster. This is the error that we are getting.

Failed to create the XA control connection. Error: Could not load the DLL SQLJDBC_XA.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.)

We did follow the documentation to take the dll file and put it in the mentioned folder.

Thanks.

Best Way to Store Documents In SQL Server

Fri, 21 Nov 2008 01:46:19 GMT

Hi,
I am wrighting abusiness application for a professional placement firm and they would like to be able to add a resume to the data for a person and be able to search that resume. I am currently designing the databasein SQL Server 2008 and was wondering the best way to store the resume. Should Ijust put it into a VarChar(Max) column orcould Istore a MS Word or XPS document in SQL Server?What are the best practrices for this and can you point me todocumentation that would help with designing and implementingsuch a task?

As you can imagine, they get resumes in many differnt formats and it would be nice to be able to just cut and paste them into a Rich Text Block. I would like to databind that to business object that gets persited to SQL Server. I would also like to be able to search the text so that when a certain skill is needed and it is not found in the normal data, the Resume data could be search to see if it exists. Any suggestions?

Can you create a SQL table by linking it to a VFP table?

Thu, 20 Nov 2008 19:05:18 GMT

I'm trying to figure out how to create a SQL table by linking it to a VFP table. Some suggested this as a solution to a problem we're having trying to get the application KnowledgeSync (KS) to connect to our accounting application. KS uses ODBC and the most recent VFP ODBC dive is for version 6 and our tables are version 9. They're using some data types that the ver 6 driver doesn't support. So, the suggestion was to create some kind of "linked" table in SQL Server, excluding the field which contians the unsupport date type - an auto increment field, and then connect KS to the SQL server table.

Does anyone have any suggestions?

Thanks,
Mike

Strange opccurence of "String or binary data would be truncated" error

Thu, 20 Nov 2008 22:46:28 GMT

Hi,

I have an web application running on Windows Server 2008, IIS 7, Sql Server 2005; developed using Visual Studio 2008 and .Net Framework 3.5.

Problem: In my login screen where I accept a username and password for my application, this error stating "String or binary data would be truncated. Statement would be terminated" occurs.

This occurs in the following condition - when there are about 4-5 instances of the application running on other machines, I get the error on my system running Windows Vista. When I close down all other instances, login to the application on my machine running Vista, I succeed (without any change being done to application / server settings). Later when the other systems log in to the application, they are also able to successfully.

Same bhaviour with another system too running Vista.

Does this have to do with the multiple instances running or with Windows Vista? How do I solve this?

Thanks for any help.

DA.

New login - form computer object type

Tue, 18 Nov 2008 02:49:42 GMT

Hi all,

I'm transfering some Crystal Report web applications (ASP.NET 2.0) to a new server and pointing them to SQL Server 2005 (was pointing to SQL Server 2000) and I have hit a snag related to the SQL Server login.

When developing the app (in VS 2005) I successfully use a windowsdomain user group login to access the data. However, when deployed to the web server (IIS on Windows Server 2003 R2), the user accessing the database is recorded as the web server itself (domain\servername$) and logon fails.

I hit this problem with SQL Server 2000 as well, but I found I could solve this by creating a new login based on the computer object type with the appropriate permissions. This option doesn't seem to be available in SQL Server 2005 - only 'built-in security principals', 'users', and 'groups' options are available. Is there a way to allow the computer option to be turned on?

I've also tried using

Code Snippet

CREATE LOGIN [domain\servername$] FROM WINDOWS

to create a login, but the ASP.NET app still doesn't work.

(I realise that a solution may also lie in the configuration of IIS and forcing the user credentials in the .NET application, so all suggestions are welcome!)

Thanks in advance.

how to SELECT into output file (scheduled task) ?

Thu, 20 Nov 2008 02:35:37 GMT

With utilitycan be executed from scheduled task,
and can run SELECT operator
and save result into output file?

I can ran script and save result into output file using SQL Server Management

Studio,
but I dont know how to execute this from scheduled task.

I mast not use ISQL(because of DB Library) and OSQL(ODBC).

ODBC SQLGetTypeInfo returns no row for SQL_SS_UDT

Wed, 19 Nov 2008 23:19:17 GMT

SQL Server Native Client 10.0 2007.100.1600.22
ODBC driver returns no row for data type SQL_SS_UDT. However, this data type is returned as the data type for the new geometry and geography data types. Example,

CREATE TABLE [test_geometry](
[col1] [int] NOT NULL,
[col_geometry] [geometry] NULL,
[col_geography] [geography] NULL,
[col_hierarchyid] [hierarchyid] NULL,
CONSTRAINT [PK_test_geometry] PRIMARY KEY );

Select
"col1", "col_geometry", "col_geography", "col_hierarchyid"
from
"test_geometry"

My application gets the following resultset description for the select statement above ( col, typename, datatype ):
col1 int SQL_INTEGER
col_geometry udt SQL_SS_UDT
col_geography udt SQL_SS_UDT
col_hierarchyid udt SQL_SS_UDT

Querying SQLGetTypeInfo about SQL_SS_UDT (-151) returns no row, so a cross-DBMS ODBC application would would not know for example that SQL Server 2008 supports datatype SQL_SS_UDT (-151) and can not find out the literal prefix/suffix since no row is returned by SQLGetTypeInfo.

SQLGetTypeInfo I believe should return a row similar to row returned for SQL_LONGVARBINARY datatype.

Searching in 2 different tables

Wed, 19 Nov 2008 23:43:21 GMT

Hi All,

I don't use SQL that much, so maybe this is a bit of a stupid question. But I hope to get an answer here.

I have three tables:
Table 1 contains the columns: GroupID, GroupDesc.
Table 2 contains the columns: GroupID, PartNr, PartDescr
Table 3 contains the columns: GroupID, DetailNr, DetailDescr

As you can imagine 1 table contains group names and the other two tables contain elements that belong to one of the groups in table 1.

What I want is to read all values from table 2 and from table 3 that have GroupID=1.

I tried:
Select Table2.PartNr, Table3.DetailNr FROM (Table2 LEFT JOIN Table1 ON Table2.GroupID=Table1.GroupID) LEFT JOIN Table3 ON Table3.GroupID=Table1.GroupID WHERE Table1.GroupID=1;

This doesn't work, cause it lists 2 columns and duplicates entries. Like Table2 has 3 items with GroupID=1 and Table3 has 5 items with GroupID=1, I get a total of 3*5 = 15 results. One column with 5x all three Table2 results and a second column with 3x all five Table3 results.

Can anybody help me on how I solve this?
Thanks in advance for your answer.

SqlParameter with spaces characters in its ParameterName

Thu, 20 Nov 2008 05:47:09 GMT

Hi to everybody, I have a little problem.

I need that the name of a sqlparameter has a space charater.

SqlParameter paremeterEdadReal = new SqlParameter();

paremeterEdadReal.ParameterName = "Edad real";

paremeterEdadReal.Value = 666;

I tryed this queries:

@"INSERT INTO Tabla ([Nombre], [Edad], [Edad real]) VALUES (@Nombre, @Edad, @Edad real)"

@"INSERT INTO Tabla ([Nombre], [Edad], [Edad real]) VALUES (@Nombre, @Edad, @[Edad real])"

@"INSERT INTO Tabla ([Nombre], [Edad], [Edad real]) VALUES (@Nombre, @Edad, [@Edad real])"

But I have an exception when I execute this query.

Somebody could help me please?

Thanks in advance :)

How to create two instance at same machine?

Thu, 20 Nov 2008 06:03:57 GMT

Hi,

Could you please guide me, how to create more than one instance at same machine? I want to assign this instances for Primary Database server, Mirror Database server and Witness Server also.

Thanks in advance.

Manian.R

Performance Impact of enabling MARS in Connection Strings

Wed, 19 Nov 2008 23:56:28 GMT

I am making custom modules for DotNetNuke. As many of you might be knowing, DNN is a .NET based CMS, with great extensibility & flexibility.

The connection string is stored centrally in web.config. I am creating a new Module which requires MARS capability. However, I am confused to simply modify the web.config connection string for enabling MARS, or should I do it in code for that single module only??

The reason being that no other module or the core needs MARS. Enabling it in web.config would make all connections MARS cpabale, & if that causes a performance penalty, that would slow down the entire portal. So, in that case, I would like to do it in code for the single module only, that needs MARS capability.

SYSTEM ERROR 5! Help me please...

Wed, 19 Nov 2008 02:41:40 GMT

I was having trouble with Windows updater (error code 80240016) and then found the solution was to open service command and follow the instructions given on this microsoft site. BUT it didn't work because for some reason access was denied and it kept saying 'System Error 5".

Please help, I can't update windows until this issue is resolved!

Connecting SQL Server between VSTS on two different Windows versions?

Wed, 19 Nov 2008 02:21:28 GMT

I have SQL Server 2005 set up on a Windows XP machine, which I'm using as an app server (home network) and my development machine is a Windows Vista (Home Premium edition...). I have Visual Studio Team Developer 2008 installed. Both machines are set up on a home network with a Linksys 4-port/wireless hub router connecting them to the internet. The XP machine is set up wirelessly; the Vista machine is wired.

In SQL Server Configuration Manager, I have enabled Named Pipes under the Protocols. I created an NT AUTHORITY/Network Service account under the Logins. I also installed the Applications Services database (it's called the default of aspnetdb) using the commandline prompt (aspnet_regsql -E-S myxpmachine -A r),and given the Network Service account the Role of aspnet_Roles_FullAccess.

In VSTS, with a project open, I right-click on Data Connections, click Add Connection, select Sql Server connection type, type myxpmachine in the server name, and aspnetdb in the Database Name box, and click Test Connection.

I get this message:

If I try to use Sql Server Express Management Studio from Vista to XP, I get a very long message about permissions (I'll copy that in here later if someone doesn't know what I'm talking about already) and no connection.

My colleague at work says I need to open up a port on my Linksys router to permit the connection, but I'm wondering if there is something germane about a Vista machine trying to connect to an XP server that is causing the issue. Or, is there some sort of permission I need to set in Sql Server? Or, do I need to change a setting in VSTS?

Help!!!

MSIDXS: Row handle is invalid

Wed, 19 Nov 2008 00:21:58 GMT

I've migrated a legacy application from SQL 2000 to SQL 2008 and Im getting the following error when running an OPENQUERY against the MS indexing Service.

select *
FROM OPENQUERY(fullOsfi,'select Directory,Rank
FROM web1.catOSFI82_e..SCOPE('' "E:\IIS\Sites\Evolutra8\HTML\" '')
WHERE CONTAINS('' "repository" '') > 0 ')

OLE DB provider "MSIDXS" for linked server "fullOsfi" returned message "Row handle is invalid.".
Msg 7330, Level 16, State 2, Line 1
Cannot fetch a row from OLE DB provider "MSIDXS" for linked server "fullOsfi".

The issue seems to be data related. Interestingly enough if I I limit the number of rows returned with the TOP command it works up until 42 records. As soon as I hit TOP 43 it fails. If I reduce the columns I can return more data until a limit.

Something also interesting is the results seem to briefly appear after running the query but then disappear with the error.

Im running SQL 2008 64bit on Window 2008 and the web1 server running MS indexing service is Window 2000

Paul

JDBC driver 2.1 connecting to SQL Server 2005

Wed, 19 Nov 2008 01:12:26 GMT

We are implementing a oracle solution which uses JDBC 1.2 to connect to a SQL Server 2005 database server. The SQL Server is a named instance and we are getting a connection error when we try to connect to that server. I want to know if JDBC 1.2 supports named instances. Thanks for any help in this regard.

How do you determine if a SQLException is due to a connection or query problem?

Tue, 18 Nov 2008 23:09:54 GMT

Is there a foolproof method for determining if a SQLException was caused by a query versus some connection-related problem? My application should handle the two cases in very different ways, so it's important to cover every case.

Any help would be appreciated.

Connecting with Windows Authentication using different Domain

Tue, 18 Nov 2008 22:58:16 GMT

Hi,

I have Vista Home Edition and has no posibility to add my computer to a domain but i have Windows authentication on a sql server 2005 server. I need help in connecting to sql server using Windows authentication for a given domain.

Thanks,

sanp

server is not configured for data access error

Tue, 18 Nov 2008 22:36:28 GMT

Hi all, Im relativly new to SQL Server so this may be a bit of a dumb question.

I have a user who originally was getting the error "could not find server in sys.servers...." when they were trying to delete a record.

So I ran select * from sys.servers and sure enough it was not listed

then

sp_addserver 'SERVER'

they are no longer receiving the could not find server error however they are receiving the server is not configured for data access error.

What is confusing to me is that this user can log into the database and query for data, just not delete any data.

I am completely stumped as to what is causing this. Not to mention The servers name isn't even 'server' its 'iO' and the ODBC connection is configured properly.

any help would be greatly appreciated

Thanks!

EDIT: the client is running SQL Server 2005

SQL Server 2008 connecting to DB2 Server for VSE 7.1

Tue, 18 Nov 2008 21:55:38 GMT

Has anyone connected SQL Server to DB2 Server for VSE? Does the DB2 Server include an ODBC connection or do we need another product (i.e DB2 connect and/or Host Integration Server) to connect?

Thanks

Lorie

Classic ASP On Server 2008 & SQL 2008

Tue, 18 Nov 2008 21:21:04 GMT

I am currently migrating one of my clients sites to a windows server 2008 and SQL 2008 setup, but I am having massive problems with connecting to the database from the site.

I have restored the database from a SQL 2k backup into the SQL 2008 server, I have setup the user correctly and can login as that user in management studio fine. I have copied over the site .asp files which load fine when there is no database access. But when i try to access the database it fails with "Login Failed for user......".

I have reset the passwords, created new users, changed the connectionstring from OLEDB to SQL Native Client and back again but keep getting errors. I have even setup a dummy database and user and still have the same problem.

Does anyone know of a reason why this could be happening? Is there a setting in SQL or windows that I am missing?

I have been at this for hours and would really appreciate any ideas.

UPDATE 1: If I put the wrong login details in the connection string I get the error on "conn.open" but if I put in the correct login details I get the error on "cmd.activeconnection = conn". Not sure if that helps.

UPDATE 2 : I did try setting up a UDL on the server whichconnected so I copied the connection string and now it returns an error "Object required: 'Provider=SQLOLEDB.1;' " on line "cmd.activeconnection = conn"

The connection string is

"Provider=SQLOLEDB.1;Password=test;Persist Security Info=True;User ID=TestLogin;Initial Catalog=TestDB;Data Source=ServerName"

Thanks

SQL express 2005!

Wed, 19 Nov 2008 03:59:07 GMT

I have SQL express edition 2005 to setup a server, buth a vew years ago i screwd it up and cant install or use it now anymore. I want to know how to completly remmove it from my pc withouth needing to reinstal my Windows.

Iff i try to install it at this moment then i get a red cross at the Native client. Somehow it wont instal.
And bequze of that it makes some errors and reject me when i want to open SQL.