I have a linked server pointing to a folder where foxpro tables exist. The tables are listed when I click on the linked server/tables. However I get this error when in query analyer I say: select * from vfplinked...clients Server: Msg 7313, Level 16, State 1, Line 1 Invalid schema or cata...more >>

Hi Guys, I'm busy trawling through documentation trying to puzzle out an issue I'm having. Am about to tackle the SDK. OK, I'm using MDAC 2.8. Visual Basic 6 and SQL2000 SP3a. If I execute the following code through a normal ODBC connection (In Admin tools), I get a result. Works fine. ...more >>

Hello there, I am experiencing performance problems with an aplication running over a SQL Server 2000 Database. The server that holds SQL Server has 2.8 GB of RAM memory. When there are just on or two users working, the aplication performance is suportable, but when more users are using the...more >>

I've heard that using DAO (without JET) with an ODBC workspace using SQL Server is just as fast as using ADO that ADO is really an abstraction of DAO - that the only advantage of using ADO is managing session data. Can anyone verify this? Thanks. Matthew Wells MWells@FirstByet.net ...more >>

Hi, How to convert and transfer ANSI string data from FoxPro table to MS SQL Unicode table. Data in FoxPro are in 1251 codepage (Russian Windows). Now result is like "ÊÎËÜÖÀ ÊÎÌÏÐÅÑÑÎÐÀ 100ìì ".The ODBC driver does not performs the conversion from ANSI to Unicode. Help. ...more >>

Hello, I'm using a Access 97 Front-end and a SQL Server 2000 back-end. When entering a subform on a form, information has to be saved to the database. But when entering the subform I get a "Write conflict" error in Access. In SQL I'm using 3 tables with 1 view defined on those 3 tables. I u...more >>

Greetings, In our company we have different kinds of SQL databases and SQL servers. We are trying to consolidate those servers under a couple of powerful servers. But when we began to tell this project to software houses and ask their idea; we met a big problem . Some of those companies ...more >>

Hello I am trying to import tables with data from Access to SQL. The problem occures when the Primary keys and identity are not being saved and i need to do it manually. There is a way to import this tables with all the connection regulations like Primary key will be saved ? thanks G...more >>

Hi I'm new to this whole SQL thing(electrical technician, heavy current). I use TOAD to write queries on our db. Question is : How do I subtract 2 dates from each other & format the result to HH:mm:ss in new collumn. I usually do this in MsExcell after extracting the data. Thanks in advance....more >>

I have a third party Client (Rational Clearquest) connecting to a SQL server with an ODBC connection. Recently a few of the developers (not all) have started getting "[ODBC SQL Server Driver]Communication Link Failure" after 5 minutes of inactivity. I had the a network sniff done on the ...more >>

Hi, I'm trying to create a ODBC connection to SQL server 2000 using SQL server authentication. I have login id "lucky9797" and password "tool" but I'm keep getting the following error message: Connection Failed: SQLState:'28000' SQL Server Error: 18456 [Microsoft][OD...more >>

A remote office developed a PC-based app that writes its data to a text file. We want to maintain this data at the main office, and in SQL Server, due to the significance of the data. A typical day's file may have a couple hundred records, written over an eight hour shift. Rather than changing...more >>

how to unistall MDAC 2.8? ...more >>

Hello, i habe some trouble with a sql 2000 appclication The envisonment: SQL-2000 - Server MS Access2000 - Client that uses SQL server tables via ODBC. After inserting a row to a table table_1 an insert trigger is running that inserts some fields of this row to a second table tabel_2. T...more >>

I want to be able to call a SQL Server User Defined Function that is a table valued UDF. I have existing code that uses ODBC and calling UDFs is going to be a lot easier than calling stored procedures, as the syntax is close to using a table itself (at least in T-SQL it is). But, I suspect th...more >>

I need to engage an odbc consultant for a few hours to quickly go over some code of mine. You must be experienced in coding ODBC in C. The program uses straight C (not C++ and not MFC). I need this help immediately. Please email right away if you can do it. Please include your rates. Thank...more >>

Hi! I have two MS SQL servers: Server1 & Server2. Both are Win2003 Server + MS SQL 2000, but the first is 64bit version, while second is a 32bit version. When I try to do this: insert into Server2.mydb.dbo.table1 select * from Server1.mydb.dbo.table1 order by add_item I get an error: S...more >>

i want to create some queerys in MS-SQL 1) this queery in ORACLE-SQL works fine , in MS-SQL? SELECT code_card, card_date + 31 FROM card i searce and find out that i must use "DATEADD ( datepart , number, date )" but how? 2) this queery in ORACLE-SQL works fine , in MS-SQL? ...more >>

Does anyone know if this article is valid for connection between servers. I'm getting an intermittent |308|80004005|[Microsoft][ODBC_SQL_Server_Driver]Timeout_expired when a website running on a windows 2000sp3 tries to write data to sql 2000 server running on windows 2003 server. Could th...more >>

I am new to odbc - can anyone point me to a simple odbc example written in C (not using MFC) that does a simple select and a simple insert? Thanks. ...more >>

Hello, I do not have much of a programming background at all, so I am not sure how to ask this, so I will try to keep it brief: I am trying to teach myself SQL programming on my home PC using Windows XP (using the book "Teach yourself SQL in 10 min."). I searched my PC and do not have M...more >>

I have an Access 97 database (using Jet 4.0) connecting to a SQL 2000 via ODBC - the OS is Win XP Pro SP2. When i open a form to display the records in the linked table they come up fine, but after about 30 seconds it dings and i get the pop up ODBC--call failed. If i close the form and re...more >>

BlankSometimes, when large tables are being queried via the MMC in = Enterprise Manager, an error is returned because of an SQL ODBC driver = time-out.=20 The same query when run from the Query Analyzer is completing = successfully. Is there a parameter that can be modified to increase the = t...more >>

We're using SQL Server 7 with an Access 2000 MDB as a front end with ODBC linked tables. I recently created a new set of tables for the app, and users are complaining that unsaved data is being lost when they move to a new record. This seems to be the case when there are multiple users. When t...more >>

I need to setup identical System DSN ODBC connections on multiple servers... is there a way to easily migrate the System DSNs from one server to another?...more >>

Just recently our company upgraded to Windows XP Pro SP2, running Mdac 2.8. We have Access 2000 database, using sql 7 back ends. The applications run fine until when we try to relink them, after making changes. They relink fine to a DSN and then when I close the Access application, then reo...more >>

Does SQL server support external link database like DB2 or Oracle through ODBC? Any information is appreciated. ...more >>

I have an issue with SQL 2000 Standard Edn (8.00.760 SP3) that I believe to be "Bug #: 471578". It manifested after my SP3 install. Manifest: I use a simple 3 table select "View" as a form recordsource in read-only, no locks mode. SQL, however, places locks on all the records. Then other for...more >>

I was using SQL server service manager with no problem. I've installed "Business Contact Manager" and now service manager cannot connect to the server. Thanks for any advise....more >>

Hi I am trying to instal MSDE 2000 on a Windows XP Pro SP2 machine. I type in ..... "Setup.exe /qb+ INSTANCENAME=NetSDK DISABLENETWORKPROTOCOLS=1 SAPWD=<YOUR SA PASSWORD>" at the command prompt and the MSDE setup begins to take place. At the nearly the end of the install, I get a pop-up dial...more >>

Hello, I have an internet site, that supports ms-sql server 2000. The hosting company for some reason have problems on there wizard of creating columns on db, and doesn't support the auto-increment. How can I do alter to a column, with an sql command, to an auto-increment one ? Need sampl...more >>

Pal, Anyone can give me clue how is to do MSDE connection via ODBC. My application is coded by VC++ .NET 2003 Thank you. Rajo M ...more >>

Hello, I am developing for internet. I need a good example for ASP page, that use sql-server with some update commands + transactions (use insert/update command + beginTrans/EndTrans, please. Thanks :) ...more >>