Hi ... I am having to switch from Access queries to Access pass- through queries because the SQL Server 2000 tables are getting too large (I connect to SQL Server with Access - ODBC connection). I can do most of the translation between Access SQL and Transact SQL, except for condition...more >>

Although it worked great for years when built with VS 6.0 class CMyRecordset : public CRecordset // derive a class from CRecordset. (actually the IDE does this for you) { ... } CDatabase Database; CMyRecordset *pMyRec = NULL; try { Database.OpenEx(DSN, CDatabase::noOdbcDialo...more >>

In the Office we have a Win2000 Server running MS SQL Server 2000. I know the servers external IP address (xxx.xxx.xxx.xxx) and we have a sub-domain set up (subname.mycompserver.com). I have a login and password into the server as well as the SQL login and password. The firewall is open on por...more >>

Hello, We are setting up a backup server for one of our Web sites, and the current machine is running Win 2K Server, the new one Win 2003 Server. Otherwise everything else is the same. Most everthing works fine, except for one ASP template, which is opening a recordset with this line: s...more >>

Hello all, I have a stored procedure I wrote: CREATE PROCEDURE spCreditCheck @MatchID integer, @Price numeric, @RepSC numeric, @Rep2SC numeric, @DeskSC numeric, @CheckResult numeric OUTPUT AS Declare @CheckPrice numeric, @CheckRepSC numeric, @CheckRep2SC numeric, @CheckDeskSC numeric, @Ch...more >>

Friends, I am new to SQL Server, and I access it mainly through Access (ODBC DSN). I need my queries to run faster, so I want to switch from regular Access queries against linked SQL tables to faster pass-through queries written in Transact SQL. QUESTION: Does anyone know of an easy ...more >>

I'm looking to build an application that will get data from an HR system (built in Visual FoxPro 7.0), import it into SQL Server, and process it there. I'm trying to figure out what the best approach to doing this would be. I would like to avoid any development in the FoxPro db - no views...more >>

I have version 2000.81.9042.00 of SQLSRV32.DLL installed. Does anyone know where this particular version came from? Hotfix? The MDAC component checker tool gives no useful information. I know that MDAC 2.8 will install version 2000.85.1022.00, but I'd first like to determine where versio...more >>

I have just read about the Call-level interface, a library of DBMS functions that can be called by an application program. Where can I read more about the CLI function, Google & MSDN searches didn't yield much and no examples etc. Does any one actually program to this to facilitate data transf...more >>

Hi! Could you give me a list of advantages using OLEDB in stead of ODBC? Is there an idea of getting good informations how to handle OLEDB? My problem is by using ODBC for a WebApplication the system often is blocked. I hope the system gets faster by using OLEDB. Is it like this? Thanks, ...more >>

I have a SQL 2000 database and I'm using Access 2003 to gain access to the tables. All cells contain #Deleted. What am I doing wrong? TIA Jon ...more >>

I have SQL Server 2000 with Pervasive SQL 2000i attached as a linked server. When I run the following... UPDATE OPENQUERY(LINKEDSERVER, 'SELECT "START_ORDER_NO" FROM "OECTLFIL" WHERE "FILE_KEY" = 1') SET START_ORDER_NO = 0 ----The START_ORDER_NO field contains a 48 Changing the SET cla...more >>

Hi, I have a need, unfortunately, to use a subselect as part of an IN clause in a WHERE statement. The subselect contains a parameter that must be bound with SQLBindParameter. However, when I run the code that binds the parameter I get an ODBC error: "Synatx error or access violation."...more >>

I was using the following command to update the data source (a tab-delimited text file): INSERT INTO table (COL1,COL2) VALUES ('AA','BB') I found the updated text file looked like this: "AA" "BB" Could anyone tell me how to remove those double quotation marks in the SQL command or conf...more >>

Hi, and Thanks for your thoughts! I am evaluating a product, and the sales team presents an option I am not familiar with. Can a SQL/OBDC connection accross the internet be encrypted (via or utilizing) OBDC? Any heads-up or caveats will be appreciated. Brent...more >>

Hi all If I prepare the following statement: SELECT zA."ID" AS fA_A , zA."IDFirma" AS fA_B , zA."Name" AS fA_C , zA."Vorname" AS fA_D , zA."IDMandant" AS fA_E , zB."ID" AS fB_A FROM AtlasTest.Adresse AS zA INNER JOIN AtlasTest.Mandant AS zB ON zB."ID" = zA."IDMandant" AND (zB."ID" ...more >>

Hi, I'm getting this message while performing a BCP command... can anyone tell me what this means? Do any of you know where to find a list of explanations of NativeErrors and SQLstate errors as well? ************************************* SQLState = 37000, NativeError = 4060 Error = [M...more >>

Hi, I would like to give some remote users (not part of our company) access to our SQL server so that they can link to tables via Microsoft Access. I have added the users to our domain with the intent of having them use Windows Authentication to connect to our server (Best practice?). I...more >>

Hi everyone, I need your expert advice. I have a w2k AD service with mssql on it. and I setup another w2k server with IIS on it as webserver. my website works on NT servers, but when I moved the website to the w2k server, it doesn't work. It saids: Error Type: Microsoft OLE DB Provider for...more >>

Hi all - I need a way to detect a dead connection. I realize there has been a problem with SQL_ATTR_CONNECTION_DEAD , so I use SQLGetConnectAttr with SQL_COPT_SS_CONNECTION_DEAD instead. I still dont get the expected result. (btw, SQL_COPT_SS_CONNECTION_DEAD is defined as SQL_ATTR_CONNECTION...more >>

I am trying to understand this. When i choose either windows NT authentication, or SQL authentication and specify an SQL login and a password, the user credential is only being used ONCE? That means, let's say i used the SQL Login "sa" and its password to point to a SQL Server 2000 db, after...more >>

I tried to access Microsoft SQl database to get table list but i got the followig error. bf4.a30): Data misaligned - code 80000002 (first chance) First chance exceptions are reported before any exception handling. This exception may be expected and handled. *** ERROR: Symbol file could not be...more >>

Is there a method to enable an ODBC client to encrypt all communications between the client and the server? I have a client that is having a cow about data moving over the network via an ODBC driver to DBMS server unencrypted. I haven't seen or heard of an option like this before but thought...more >>

Hi all I keep getting and error message that says that I am a Deadlock Victim. Is there anything that I can do about this. What is causing this. I have a VB6 application using ADO to connect to a MS SQL Server 2000 Database This always happens when accessing the same table. I am not s...more >>

Hi all, We recently upgraded our SQL 2000 server from Windows 2000 server to windows Server 2003 Small Business Edition. After the upgrade, the existing server connections still work (we're using it for Great Plains), but there's a boatload of problems. In short: 1) No clients can connec...more >>

Dear Colleagues: This is such an SQL newbie question its not even funny. To begin with, please forgive my informality as well as my lack of any specific error messages, etc.. . I think the questions are academic (the specific error messages and notes are strewn about my desk at work). Ok...more >>

Hello, I'm calling SQLBindParameter on a prepared statement with the following arguments for a Varchar column in a SQL Server 2000 database: // code ... char val_ptr[] = "whereValue"; SQLBindParameter(handle, SQL_PARAM_INPUT, SQL_C_CHAR, SQL_CHAR, 0, 0, val_ptr, 0, &nullInd); // ......more >>

Hi all, I am having a major problem with a simple application that queries a database. Firstly we have SQL2000 SP3a running on a Windows 2003 Server with all the latest patches and updates. Windows 2003 is running the shipped MDAC 2.8 and I've run the component checker to make sure there is...more >>

In my SQLserver DATA datatype appear to me with hour separator "." (12.00.00) I want that they appear with separator ":" (12:00:00) (for to prevent ODBC problems) (I have changed the international setting of the server... the OS time is changed, but in the DB I always have the ".") Any sugge...more >>

Hi. I just installed Sql server (in fact MSDE) and exported my Access 2002 projet to this database instance. I then linked my Sql server tables within my access project. I get a strange behaviour for some queries. I receive the message 'ODBC - Call fail'. It seems to be a timeout pb. The q...more >>

There are 2 SQL databases involved and an MS Access program.... also using windows authentication... The Ms Access program executes a stored procedure that resides in SQL database#1, the stored procedure updates data in SQL dataabase#2.. Assume the user has rights to execute the stored proce...more >>

I have the situation where I need to attach and detach from an installed MSDE database and I was hoping I'd be able to do it using the SQLConnect and SQLDisconnect functions from the ODBC API. However, if I run a test case where I connect to the datasource and then execute a query and detac...more >>

I have 2 load balanced servers. One went down and I am rebuilding it, I would like to somehow import all of my DSN's from box #2 so I don't have to recreate it all. I would also if possible like to set up appcenter to replicate the DSN's over so that I only have to create them on one box...more >>

Hi all, I am using Visual Foxpro as front end and SQL Server at backend. This is a Client/Server Database App. I am facing deadlock problems in this environment. Please provice me any help in this regard. Thgank in advance....more >>

Hi I am using ADO, VB6 and MS SQL Server 2000 Why is it that when I run this statement I get the wrong date format and date sSQL = "UPDATE tbl_MyTable SET tbl_BTP_Scenario.UpdateDate = " & Date() sSQL = sSQL & " WHERE tbl_BTP_Scenario.ScenarioID=" & glScenarioID adoCON.Execute sSQL ...more >>

Friends, I am trying to run the following CREATE TRIGGER SQL statement. I keep getting a Syntax Error from SQL Server (near key word 'select' (line 11) and near '=' (line 13). I cannot see the mistake. Does anyone see anything that stands out? tblCustomer comprises two fields: [ID]...more >>

The same problem existed with WMP:9 and TabletPC-SP1 I updated to SP2-Tablet PC2005 on TC1000 and Installed WMP:10 When I try to search media files it just sits there, Ive tested local/my music folder etc and network locations to no avail. I do not get an err code. I can navigate/open ...more >>

Hi, I we are using VFP & SQL2000 together. At one clients office we are getting problems with data storing "Null" values in about a dozen different columns in 4 different tables. I did some research and realized that when we reinstalled the server we skipped putting SP3 in place. So, I d...more >>