473,216 Members | 1,257 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,216 software developers and data experts.

SQL Server 2005 ODBC Logging Problems

1
Hi All,
I am working with a software package that logs messages via ODBC to a remote SQL Server 2005 Service Pack 2 database. The server OS is Server 2003 Service Pack 1. The software that we are working with successfully creates the SQL table and SQL user for the logging as the ODBC connection is set up. We have verified that both the user and the table have been set up on the SQL Server machine. By default, full permissions are not granted to the user associated with the table. We went into SQL and granted full table permissions to this user. It seems as though everything should work, but we aren't seeing any data in the table. We ran an ODBC trace and received the following message:

DIAG [S0001] [Microsoft][ODBC SQL Server Driver][SQL Server]There is already an object named 'TableName' in the database. (2714)

The table is already created in SQL 2005. I'm not sure why it would try to create the table again if it already exists??? There is no indication that the software is trying to create the table again. We have used this software with SQL 2000 and have not experienced this issue.

Are there any known issues with ODBC logging to a SQL Server 2005 database? Could this be an authentication or security issue? I haven't worked extensively with SQL Server 2005, but have worked with SQL Server 2000 quite a bit. I just don't know if there is something that we are missing in the configuration within SQL Server 2005. Any assistance is appreciated. Thanks!
Mar 20 '08 #1
1 1506
ck9663
2,878 Expert 2GB
Hi All,
I am working with a software package that logs messages via ODBC to a remote SQL Server 2005 Service Pack 2 database. The server OS is Server 2003 Service Pack 1. The software that we are working with successfully creates the SQL table and SQL user for the logging as the ODBC connection is set up. We have verified that both the user and the table have been set up on the SQL Server machine. By default, full permissions are not granted to the user associated with the table. We went into SQL and granted full table permissions to this user. It seems as though everything should work, but we aren't seeing any data in the table. We ran an ODBC trace and received the following message:

DIAG [S0001] [Microsoft][ODBC SQL Server Driver][SQL Server]There is already an object named 'TableName' in the database. (2714)

The table is already created in SQL 2005. I'm not sure why it would try to create the table again if it already exists??? There is no indication that the software is trying to create the table again. We have used this software with SQL 2000 and have not experienced this issue.

Are there any known issues with ODBC logging to a SQL Server 2005 database? Could this be an authentication or security issue? I haven't worked extensively with SQL Server 2005, but have worked with SQL Server 2000 quite a bit. I just don't know if there is something that we are missing in the configuration within SQL Server 2005. Any assistance is appreciated. Thanks!

"The software that we are working with successfully creates the SQL table and SQL user for the logging as the ODBC connection is set up." This tells me that whenever a connection is successfully done, it will create the table. Hence, the error. If you can modify your apps, try to check for existence of the table first then do the necessary step (to rename or drop) before proceeding with creation.

-- CK
Mar 20 '08 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

6
by: Andreas Lauffer | last post by:
I changed from Access97 to AccessXP and I have immense performance problems. Details: - Access XP MDB with Jet 4.0 ( no ADP-Project ) - Linked Tables to SQL-Server 2000 over ODBC I used...
0
by: AlessanBar | last post by:
Hello Friends !! I have a strange problem, and I need to know what would be the source of this. I have a laptop computer with the following configuration: Pentium III Brand : Toshiba Speed :...
1
by: chloe.crowder | last post by:
Hi We're trying to use call a stored procedure to update information in a remote Ingres database. We've linked the server, and can read information using SELECT * FROM OPENQUERY (..........),...
10
by: MVChauhan | last post by:
Hi We are planning to move over to SQL Server 2005 in near future. At the moment Website is on a seperate server then the Database. OS for both the server is Window 2003 and currently our data...
2
by: Marcus | last post by:
(Appologies if this group isn't the best place for this post) Is it possible to use DAO 3.6 to access binary data (varbinary(max)) in Sql Server 2005? I have images and sound in a Sql 2005 DB...
2
by: Jobs | last post by:
Download the JAVA , .NET and SQL Server interview with answers Download the JAVA , .NET and SQL Server interview sheet and rate yourself. This will help you judge yourself are you really worth of...
5
by: marshmallowww | last post by:
I have an Access 2000 mde application which uses ADO and pass through queries to communicate with SQL Server 7, 2000 or 2005. Some of my customers, especially those with SQL Server 2005, have had...
0
by: veera ravala | last post by:
ServiceNow is a powerful cloud-based platform that offers a wide range of services to help organizations manage their workflows, operations, and IT services more efficiently. At its core, ServiceNow...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
by: jimatqsi | last post by:
The boss wants the word "CONFIDENTIAL" overlaying certain reports. He wants it large, slanted across the page, on every page, very light gray, outlined letters, not block letters. I thought Word Art...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.