I very clear that i configured SQL database with no problem but while i going to setup DSN in ODBC and this error occured, I do not understand what is the problem that keep this error exist. ' Connection failed: SQLState: '01000' SQL Server Error: 2 [Microsft][ODBC SQL Server Driver][Shared...more >>

i want to filter a table by a view using a defind function for example: select * from person where dbo.person.company like case CmpName() when 'all' then '%' else CmpName() end prblem is that '%' doesn't show the records with NULL value how can i thanks sam ...more >>

I'm getting an error message I've never seen before when I installed my application on a client's machine. I've got seven machines at this location that all work fine, when I install on a new machine, I can connect through ODBC Administrator; but, when I try to connect through the program I g...more >>

I am repeating this question here from the MSDE topic I have found a problem when linking a SQL Server 2000 table that contains an auto incrementing integer into Access 2002 via ODBC. Access identifies this field correctly as an "autonumber" field. However, when I add a record to the table,...more >>

hai all, This is manju, I am not able to execute views and stored procedures but able to excute tables. Back end is SQL SERVER. I am accesing database tables , views and stored procedures from ASP. Error while executing views and stored procedures Error: Object not found. All t...more >>

Hello, I linked an SQL Database table from a remote server over the internet, via ODBC. I can't make changes from Access. I get a write conflict message with the only options being to Copy to Clipboard or Drop Changes. The save option is disabled. I am able to create a new record from ...more >>

Hi, I need to compare 2 DB (Tables, Colums etc) in order two calculate/determine the difference between both, does somebody knows an aplication which is able to do this? It would be great if this aplication would also be able to create a script, after comparison, which aplies to one of the ...more >>

I have an Access 97 program that for many years linked to tables in another database through drive letter access. Recently, because of speed, we converted the Access tables to a SQL Server 2000 database and linked the tables via an ODBC connection. The program can read the tables but there...more >>

Hi, I'm running a SQL server 2000 (recently upgraded to SP4, MDAC 2.81) on Win2k box with 1GB memory. I've two huge denormalized tables: one Master table with 70 columns and 5million rows and another Summary table with fewer columns and 2 million rows. Problem: When I try to run a simp...more >>

Hi, I'm having problems with VC++ 6.0 reading an Access 2000 database. CRecordset::Close() throws an exception. I've created a simple test dialog which does an open and close of a CRecordset. The database has one table called 'Addresses' in it. The CAddressSet was created by the Class Wizard....more >>

I have an app which using Access front end and SQL server backend and ODBC connection. My app may access the SQL server backend database without ODBC configuration. Is it possible? If yes, where I can investigate the issue. Any information is great appreciated, Souris, ...more >>

Hi, I am trying to upload some data from Foxpro2.6 for Windows into Oracle. I don't have Foxpro Connectivity instruction book, so I was searching the web and trying to figure it out. When I run foxpro command handle = DBConnect(HOracle,"username","password","") to connect through ODBC It cam...more >>

1. Using the ODBC tool I created System DSN (SysbaseDSN) and the “Test Connect” established a connection … after prompting for the UserName and PW. 2. Ran the following from Query Analyzer USE MASTER EXEC sp_linkedservers USE MASTER EXEC sp_addlinkedserver 'SyBaseServer', ' ', '...more >>

ODBC application cannot connect to the SQL Server database. Error received: [Microsoft][ODBC SQL Server Driver]Timeout expired. Error # is 20085 (which from articles on MSDN is a Remote Access Server error). This problem occurs only for Remote Users connecting through our Cisco VPN on a ...more >>

I have been using the NotesSQL driver to connect to a Domino server to pull data, with a Notes ID that didn not require a password. I was using a UDL connection to set up the ODBC connection details. However, a Domino server change now requires password authentication, having put the password ...more >>

I previously posted re. this, but thought I'd try again with a summary of facts. I have an Access 2000 MDB with a SQL Server 7 back end. There is a view that is linked to the database via ODBC and has been in place for several years without any performance problems. Recently I added a co...more >>

i am trying to connect to sql server in a remote database by using windows > authentication. I tried to connect using php and cgi. The apache service > under which i am running my cgi or php is under localsystem account. If i > change it to administrator account, i am able to connect to remot...more >>

I'm an old C/C++ programmer, but new to SQL and MS SQL Server. I'm writing an application in C++/MFC (6.0) that happens to need some access to data from an SQL Server. When installing Visual C++, it has option for installing database components and ODBC Drivers, which I did a while ago when I...more >>

Is there an easy way to read a database table from a SqlServer database and save it to an Access database? I have tried reading the data into a dataset (using .NET with C#). This part works fine, but then I can't seem to get the dataset to update or create a file in the Access database. ...more >>

I also have started showing strange ODBC link failures on May 4th of 2005. I'm running asp pages on w2k3 standard server. No known changes have been made to the system prior to this error. The initial connection to any of these web pages works great, but if the refresh or f5 key is pres...more >>

I've recently moved a database from mssql2000 on an NT Server machine to mssql2000 running on a Win 2003 Server machine. Now, when I try to use Access 2002 to Link an sql table, the Access wizard isn't showing any of the sql tables. In fact, it only shows a couple of the system tables: dbo.sys...more >>

I am wrting a vb application that connects to an MSDE database. I am using ADO for the data objects and an OBDC DSN entry for connecting to the database. Is there a way to store the username and password in the DSN entry so that I do not need to supply this in code? Alternatively, is there ...more >>

Hi, I have set up system dsn's with an sql server driver on windows 2000 to use SQL Server Authentication (NOT Windows Authentication) on a number of client PC's. When I use these to connect to an sql server database (which allows mixed mode authentication) via excel, I get the following m...more >>

Hi, My MS Access application needs to connect to a SQL server via a system dsn. However, I keep getting the error 18456 - Login failed for user 'xxxx'. The surprising bit is I am able to use the same password and user id and connect to the server using Enterprise Manager. Any ideas on why ...more >>

Am I missing somthing obvious here. I create an ODBC System dataSource programatically and I can see it in the registry. However Crystal Reports or ODBC Admin fail to list it. Is there some other area this info is held? Chris ...more >>

Hello, we are having serious problems with an application that uses an ODBC connection (System DSN) to a SQL Server in another subnet. The network is fine, all network tests reveal nothing of consequence. However, the problem does not appear when SQL server and client are in the same subnet...more >>

Hi first excuse my bad english, I am french. I think with older access version we can access to btrieve files via ODBC but now I have not found a such driver for actuate version and I have no more first access version ; I want only to read once time old btrieve files for make new files with th...more >>

I've created a "Text" Linked Server via Jet OLEDB. Everything works great when testing from the server itself, but when trying to query the linked-server from any workstation fails with this message: Error 7399: OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. [OLE/DB provider re...more >>

Hello, I'm not sure if it is right group for this question, but I hope that I'll get help here... I'm using MSDE to store data for my application. And I'm having such problem. I'm creating a table in DB for string connection information: CREATE TABLE sql ( action_id int NOT NULL def...more >>