Hello folks, I have an issue with ODBCJT32.DLL on a Itenium server that Yukon i64 (April CTP)running on 64 bit Windows 2003 SP1 server. When we try to run a distributed query that needs this driver SQL gives the following error: Msg 7403, Level 16, State 1, Line 1 The OLE DB provider "Micr...more >>

AgileInfoSoftware DataStudio 4.2 is in beta and will soon be released, please download your free evaluation and provide us your feedback. Major Features: 1) Work with multiple databases concurrently (Oracle, SQL Server, DB2, Sybase, MySQL and Access) 2) Monitor database activity, SQL statem...more >>

I have a java developer using a connection setting of Connection.TRANSACTION_SERIALIZABLE to our SQL Server. How does this connection setting interact with the code it touches? If it calls a stored procedure that is using a nolock hint will it ignore it? Thank!...more >>

I am trying to set up MySQL as linked server for SQL Server 2000. These are the steps I already have taken. 1- Installation of MyODBC 3.51 driver 2- Creation of ODBC Data source with name 'MySQLODBC' and connecting to 'mysql' data source Now what I need to have is a SQL commands to add it ...more >>

Hello, I need to be able to determine the method used to close a Context menu. It appears that there are three possibilities: 1) a menu selection was clicked, 2) the User clicked outside the menu or 3) the User hit ESC. I need to determine if the menu closed due to either of the last two pos...more >>

Hello I've read that there is a bug in sql server 2000 when doing a bcp command with dates in dd-mm-yyyy format. and to fix it there is a hotfix contained in sp4 . I ve installed the sp4 but the bug remains anybody has an idea about this hotfix and from where we can get it thx ...more >>

Hello everybody, I would like to create a System DSN on a server (named IO running Windows 2003 SP1 and IIS 6) to connect to an SQL Server (named SATURN running Windows 2003 SP1 and SQL Server 2000 SP4). SATURN is using the Windows authentication and the account creating the DSN has the...more >>

The situation is as follows: We have developed an application which uses SQL. Our installer (InstallShield 10.5) installs MSDE as part of the normal install. The MSDE is a passive install, i.e., no user intervention to alter MSDE settings. We are using SQL Server authentication. After r...more >>

I have two computers, a Windows XP machine with MDAC 2.7 SP1 (sqlsrv32.dll version 2000.81.9042.0) and a Windows Server 2003 machine with MDAC 2.8 SP2 for Server 2003 (sqlsrv32.dll version 2000.86.1830.0) as confirmed by MDAC Component Checker. They are both connecting to the same machine w...more >>

I have a linked server connection from sql server 2000 to access...once someone puts a password on an access database does anyone know what the default username is. I have tried Admin and Administrator with no luck while using the correct password of course thanks Sammy...more >>

Hi, I am trying to import a spreadsheet into MS SQL 2000 via a DTS packaget using Microsoft JET database engine, but it gives me an error saying " Workgroup information file is missing or opened exclusively by another user" This error only exists if i use an MS SQL login with a password...more >>

I keep getting an ODBC error (varies) I have SQL 7 on windows 2000 server with all the updated service packs and patches for the OS and SQL. I also updated MDAC to 2.8 sp2. We use a third party software program that connects to the SQL database to store all our data. Every so often we get ...more >>

The ado connect string for SQL 2K is: strConnect = "driver={SQL Server};server=" & ServerName & ";database= "yada yada yada". What do I need to change to connect to SQL 2005 with the SQL Native Client? Thanks in advance Steve House olorin@tampabay.rr.com ...more >>

I have a table with the fileds empid,empname,designation,branch.. etc I have 5 types of designations CEO,BM,PL,Tester,and PRG and the two branches those are Hyderabad and Visakhapatnam i need the query like first CEO name next Hyderabad BM Name next Hyderabad PL name next Hyderabad Testername ...more >>

I am writing code to interface with a pre-existing and unchangeable dBase database that we access through ODBC. This database has column names of the format "NAME$0101" and "NAME$0102" etc. These column names work fine for retrieving and updating data via SELECT and UPDATE, but when I try to...more >>

hii My win2000 server is configure to run as odbc Server. Database application is running fine on the server but the client pc running windows xp connect able to connect my odbc server...more >>

Hi! I´m wondering if it´s possible to have the ODBC-driver to reconnect after there has been an network failure ( without having to recreate the CDatabase-object and it´s CRecordset´s in VC7++ )?? Anyone has any ideas? ...more >>

I have an interesting problem. I am using the ODBC administrator to connect to a central SQL server over a WAN. On the workstation at the remote site I am able to "see" the server PC in the windows explorer, but on some remote workstations I can not connect, and I get a 18456 error that my ...more >>

Hi All, I am converting an Access app. from .mdb to ODBC link to a SQL Server. The first thing I have run into is Clustered Indexes not sorted. I have a small lookup table with 2 fields. From what I was told here by our DBA, every key has to have a primary key/clustered index. So, the l...more >>

Hello, I am using VB (VS .NET) Also, I am using microsoft application block. After calling and running a database command (select) I get an exception. I want to catch and display this error string. How can I do that ? Thanks :) ...more >>

What is ODBC tracing? ...more >>

We have a DTS package to upload data from SQL to PARADOX. We are using the Microsoft Paradox- treiber driver. Data is uploaded from 2 sql tables to 2 paradox tables. Upload for one table works, but for the other one, we get the following error message. Microsoft [ODBC Paradox Driver] C...more >>

I have an Access front-end connected to a SQL Server database. A report that used to work fine still opens fine in Preview mode, but when you go to print, after a long delay it finally generates the error: Connection failed: SQLState: '01000' SQL Server Error: 10060 [Microsoft][ODBC SQL Se...more >>

Hi I'm trying to set up a DSN and get a 18456 error Here is what I do start->programs->administrative tools->data sources (ODBC). On system DSN sheet I press add A window opens and I choose SQL Server Another window opens (create a new data source to sql server) Field name = XML descriptio...more >>

I am using a DTS package to insert data into a SQL table. This has worked correctly for the last 2 years. However when I run the code now I get a Timeout error. I have rebooted the server with no success. If I try and run the data into a temporary table it works fine. Is the table corrupt ?...more >>

I'm a normal resident of the vbscript/wsh/server scripting forums, as I'm more of a scripter, and don't know word one about SQL...so here I am - :) I'm attempting to query a MS WSUS database stored on our SQL server (SQL 2000) - one of the two fields I am querying is reporting back fine (the...more >>

I am running the code below on two similar tables. They both have an identity insert field and both have a timestamp. The first routine labeled Insert Product Materials runs fine, the second, Insert products mateirals, fails. This is the error: error 3155: ODBC -Insert on linked table 'Cust...more >>

Our app that uses MFC ODBC classes(CDATABASE, CRECORDSET) often hangs after the folllowing sequence: - open connection - connection to DB lost due to network problems - close connection - open connection - open recordset App hangs in CRecordset::PrepareAndExecute() while executing SQLExe...more >>

Hello, I am trying to connect to paradox database for the purpose of updating the record(s) in DTS ActiveX Script Task. I used the following connection string. But I get an error while connection. I have "UMTest.db" and "UMTest.px" files in the "C:\MYDBPath" in my local drive. Set objRs ...more >>

My Access database as link SQL Server tables. I am trying to remove records from a subtable and getting this message: The Microsoft Jet database engine stopped the process becuase you or another user are attempting to change the same data at the same time. This isn't the case, however. No ...more >>

I have a scheduled task that executes a program that, among other stuff, every morning connects to a SQL Server that requires a login by network login id. The problem is that, even if that scheduled task runs as the network user, it doesn't work if that user is not logged on. Is it any way to ...more >>

I am testing an Access Database on network workstations with linked tables to SQL Server. I set up a DSN and have no problem logged in as myself with Admin rights to the server. But when I login as a user with no admin rights I am denied access with this message: Connection failed: SQL Serve...more >>

Anyone run into this. I have a Windows 2003 Server which has a very old sql Server ODBC Driver installed. If I go into Data Sources and view the SQL Server driver it is dated back in 1997. Very old and I suspect that when someone installed 6.5 SQL Server tools, it overwrote the newer driver...more >>

I'm trying to connect to a SQL server in a standalone domain. I'm using Windows Authentication. So when I connect it's throwing the domain for my machine in there. Is there a way to add the other domain to the connection some how? ...more >>

Hello everyone, we see a strange behaviour after installing SP4 (under WIN2000). On preSP4 environment everthing works well and as expected. There is a (very simple) task: Select a single one row, accessed by a defined 2-part-key, * with lock*. A specific situation here is the use of OD...more >>

Hello, We have a client application which runs on about 15 workstations (Windows XP). This application connects to a SQLServer 2000 database held on a Windows 2003 server. The connection is done through ODBC. We have this problem on two client workstations : Whenever the user leaves...more >>

Hello, The application that I am working on uses a database to store application-specific data. The choice of database server is defined by the customer via ODBC settings. The problem that we are running into is that the table name syntax is not the same among database servers. For exampl...more >>

My workstation is XP prof sp2 w/ office XP under a domain policy. i act as "administrator" using Access XP to connect with SQL server. i can view and add records to the SQL server. at the same workstation, i act as "normal user with normal rights" using Access XP to connect with SQL serve...more >>