Has anyone successfully installed Compiere ERP on 2003 server? The offical site does not state that... Thanks Jack ...more >>

The ' character sometimes appears in my SQL string which was converted from a C++ Variable (Binary type), how could you avoid crashes of the database if this character appears, which screws the query and returns bad results. For example insert into abc (field1, field2) values ('10', 'alkhak' a...more >>

Hi, The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time. (3197) We are getting this error while inserting/updating SQL Server database using the Jet engine. Jet 3.6, SQL Server 2000. Any ideas? Thanks, ...more >>

I am trying to understand what things affect the throughput of data when queries are executed to SQL Server. I'm trying to determine if there are settings,pramiters or times that can improve the speed of a recordset being returned to the application. What I have noticed in our environmen...more >>

We are thinking about deploying MDAC2.8 to resolve some named instance and DNS alias connection problem. Input on MDAC2.8 dependency and potential impact to expect would be greatly appreciated. Thank You!...more >>

Hi, I'm having some difficulty creating a system DSN on a win2K machine for connecting to a SQL 2000 server. I'm not sure if this may be a better question for the windows group, but... Anyway, when I go through the odbc setup in windows, the DSN does not appear in the list of system ds...more >>

I am having a problem referencing tables via a linked server in SQL queries using the syntax as exampled in the following simple illustration: SELECT * FROM LinkedServerName.Catalog.Schema.TableName The connection string I am using seems to be correct because I can see the table names w...more >>

I am attempting to upsize my systems to SQL Server 2000. I have migrated a few tables over and made sure that they have Primary Keys setup. I have linked them into an Access 2002 mdb file and can open, add, delete, modify while in the datasheet view but when I create a bound form to the data, even...more >>

Hi, I have a question concerning joining three tables together, and getting the information to spit out correctly. Say I have three tables: products ID Code Name 1 9000 Test Product categories ID Name 1 Test Category 2 Another Test 3...more >>

What are the advantages / disadvantages of using odbc to connecting to a (mysql) database??? Stefan ...more >>

I am attempting to write data to a database from a web form. I am using = stored procedures to write the data to different tables in the db and = using the transaction and rollback functionality to ensure that the sp = have executed properly before commiting the data to the db. All of my sp se...more >>

What is the syntax of adding C++ variables into SQL Server/mySQL? Could anyone raise an example? I've tried insert into aTable (field1, field2) values (variable1, variable2) But mySQL throws error messages at me saying varible1 is not in the field list. Haven't tried it yet for SQL Server.. Th...more >>

When you try to set up ODBC link at a workstation under SQL Server, do you set up ODBC Engine Interface or ODBC Client Interface or both? Please advise. Zafi...more >>

Hi I am using MSACCESS 2002 with SQL Server 2000. I have an unbound form when it opens I assign a pass through query to the rowsource of a combo box. The pass through query calls a stored procedure. On my form unload event I set the rowsource to empty. When I load the form I am only assigning...more >>

One Winn 2000 workstatiom has problem with ACCESS 2003 ODBC conection to SQL server on WIN 2003 server. Other clients are all WINXP. This cient is on the different domain too. Some reports works, and some have error, ask for password again but not accept it even if it is supplied again. Applicat...more >>

One Winn 2000 workstatiom has problem with ACCESS 2003 ODBC conection to SQL server on WIN 2003 server. Other clients are all WINXP. This cient is on the different domain too. Some reports works, and some have error, ask for password again but not accept it even if it is supplied again. Applicat...more >>

Environment : vc.net , SQL Server Hi All, I have programmatically created an SQL Server database by executing the script file for it. I have logged in as administrator for creating the above database in my vc.net code using SQL APIs. Now i need to assign a new user and pasword to this data...more >>

Can you store hex no in SQL Server or mySQL? Thanks Jack ...more >>

In SQL Server, Can you set a BLOB field as the primary key? Also in mySQL? Thanks Jack ...more >>

I have installed the the MSSQL Server 2000 along with its service pack 2. However, I am getting an error message (pop window) that says: isqlw.exe - Ordinal Not Found "The ordinal 29 could not be located in the dynamic link library odbcbcp.dll" Please help me resolve this issue. Thank...more >>

Hi all, I have a VB6-application that opens a ADO connection to a sql server database at startup. Everything is ok, as long as there is not much database work to do. As soon as I start a calculation that works a lot in the database (reads and writes in appr. 10 tables), it takes about 1 minut...more >>

I am getting the following error message when trying to connect to a existing database. The LSN (459:410:1) passed to log scan in database 'I2000_52' is invalid. The I2000_52 is the database I am trying to connect to using a ODBC connection. Can you help me please? Thanks ...more >>

Hi all. I need to to a lot of data migration from excel spreadsheets, access databases, and SQL Server databases into a SQL Server database. In the past I would have achieved this using a combination of linked servers and ad hoc connections using opendatasource(). However my new site is hav...more >>

In SQL EM's Current Activitiy window, the Network Address of TCP/IP connections shows the wrong MAC address for client machines. The MAC shown is often one for a different ethernet port than the one that SQL traffic is going over. Any idea on why this is happening? Machines are multi-homed....more >>

Hi, does anyone know if the DataDirect Connect driver for DB2 driver support four-part-names? I'm testing this driver and have been able to set up a linked server and query the database using the openquery syntax, but when I use syntax with four-part-names or try to view the db2 tables in E...more >>

I have found info on this problem at MS, but they say this problem does not occur with SQL 2K and MDAC 2.6 SP2, yet I am still experiencing it: I have a SQL user specifically created to SELECT on 5 tables in one database. I have created an ODBC file DSN using that login/password. I create an ...more >>

hi, some one help me, i am trying to connect DATABASE on local machine from DOS mode ..is it possible..if so how....more >>

> Hello, > I am using trusted windows user connection to SQL server. > I created an ODBC link from Access to SQL server. I am > able to modify data in tables through SQL Enterprise > Manager however I am not able to modify them in Access. > What is missing? ...more >>

Hello, I try to register a remote SQL Server 2000 installed in a W2003, but it doesn't work. Afer about 5 or 6 seconds, it says: Timeout expired. In that network , there is not any firewall and port 1433 is open in the router. What it really surpises me, is that I can connect via ODBC to a...more >>

I am unable to determine what version of Microsoft's SQL Server ODBC driver comes with MDAC 2.8. Currently I'm using driver "SQL SERVER" SQLSRV32.DLL, 10/27/2003, version 2000.81.9042.00 (with Windows 2000, SQL Server 2000, Access XP) and I only want to upgrade to MDAC 2.8 if it updates thi...more >>

We connect to a SQL 6.5 server (IP for example 202.64.213.11) on WIN NT using ODBC DSN and / or SQL Client (DB-LIB). Everthing was working fine then the some XP client machines (192.168.0.1 and 192.168.0.3) started giving problems. All TCP/IP connections go thru the WIN 2000 multihomed machine ...more >>

I am setting up SQL Server ODBC connections on 5 machines and everything has gone fine until I came to the last machine. When I go to choose the server I want to connect to from the server drop down list, it isn't there. There other machines listed, but not the one that I want. The ...more >>

I get the following error (from my front-end Access app AND Query Analyzer) when accessing a particular table. It is a rather large table, ~1,750,000 rows in it. I tried looking through "limitations" in BOL and couldn't find anything. Is this a server setting or ODBC setting or... ? [Microsoft...more >>

I get the following error (from my front-end Access app AND Query Analyzer) when accessing a particular table. It is a rather large table, ~1,750,000 rows in it. I tried looking through "limitations" in BOL and couldn't find anything. Is this a server setting or ODBC setting or... ? [Microsoft...more >>

I create a linked server to an Access database with T-SQL is a stored procedure. Does anyone know how to create a table in the Access database within the stored procedure? ...more >>

hi I have connected my MS SQL SERVER 2000 through ODBC with C programming language what i am trying to do is to retrieve a UTf 8 string stored in the NVARCHAR field in the database the program is working fine with varchar but is unable to retrieve the utf 8 string in NVARCHAR field ca...more >>

Hello all, I'm having difficulties understanding why something is not going the way I want it (sounds familiar?). I'm testing SQL injection on my own PC, based on the article at http://aspalliance.com/articleViewer.aspx?aId=385&pId=-1. when I enter only my credentials in the user field, like ...more >>

I am unable to save modifications to changes in a database. I get the following error - Unable to preserve security settings for user 'RIMSUser'. ODBC error: [Microsoft][ODBC SQL Server Driver]Invalid cursor stat Any suggestions?...more >>

I had in a customer a ODBC connection to the database sql in which I modified the client configurations the connection I took off the option to determine door dynamicly and placed the 1433 but it gave error and after this exactly placing again to determine door dynamicly it gives always e...more >>

It is very embarrassing to pronounce it here. But can somebody give some comparisons of mySQL and SQL Server 2000 in terms of performance, reliability etc can anyone know of a list of comparisons on the net? Thanks Jack ...more >>

Dear all, I had been looking for B+ Trees and bubble sort algorithms since Sunday for C++ .NET; The problem was that I was on the development platform and I wanted to test my application for accessing billions of records from a standlone computer. Now I find that it is really inefficient and cha...more >>

Hi all, I hope this is the correct place for this post. I need to write a service that will bulk insert 3 million+ records from a fixed width formatted text file to an SQL Server table. When I started importing these records I used Access to put the records into a table and DTS to get the t...more >>

Hi there, I've been slogging away at this one for a while and searching on Google Groups so I thought perhaps if I ask someone can help. We have an old Access 97 Db, which we have recently moved to SQL 2000 to make it easier to build a .net web interface. However we still need to use the o...more >>

Hello, I have a SQL Server 2000 database with an Access 97 front end. I want to run stored procedures, (not nessessarily ones which return records either - action type queries for adding new records etc), from access and retreive some result from the procedure which would be used programaticall...more >>

Hello I want the help on the SQL Server HINTS. In Oracel we use the hints in the following manner SELECT /*+ ORDERED use_nl(EMPLOYEE_RECORD_MGR)* Similarly, i found the help on SQL Server HINTS. They are used with the Keyword 'OPTION' at the end of SELECT statement Here i want to know more a...more >>

Is it possible to BCP out from an ODBC data source? ...more >>

sent previous message prematurely. I have installed SQL server 7 (with sp4) on a Windows server 2003 pdc and setup security for Windows and SQL Logins. But I can not connect via odbc from a workstation to the SQL Server. I can connect through odbc from our other server so the login passwo...more >>

I've been converting a large Access 97 app to use SQL 2000 for the BE. I have solved pretty much all of the performance scenarios except this one: updating a server table and joining it to a local table, e.g.: UPDATE server_table INNER JOIN local_table ON server_table.field1 = local_table.fiel...more >>

According to MS, "Heavy use of temporary stored procedures, however, can lead to contention on the system tables in tempdb". It is also advised that "Unexpected behavior can occur with temporary stored procedures and connection pooling" Apparently the ODBC driver automatically converts dynamic SQ...more >>

Hello, I want to copy some records from Access to SQL server. (I DO NOT want to copy the entire table..just few rows) The procedure I tried: 1. From Access, Export the table 'A' to Excel sheet(A.xls). 2. From Excel, did a "save as" to A.txt (Tab delimited) 3. bcp dbname..A in A.txt -T -c ...more >>