I am using SQL Server 2000 and Access 2002 for the interface of my application. Prolem: OK, i have some views that I need people to be able to use in Access 2002 (read/Write). When I try to link them using my ODBC data source I always get a dialogue box which says "select unique record...more >>

Hi, I am calling a stored procedure from my java script app and trying to use the returned value later on in my app. Here is the javascript code. var connObj = Server.CreateObject("ADODB.connection"); connObj.Open("DRIVER={ SQL Server }; SERVER = 9.1.2.1; DATABASE=TEST","sa","xyz"); var...more >>

I am getting the following error ODBC error: [Microsoft][ODBC SQL Server Driver]Communication link failure everytime I try to add a new field to a table in any database on my server. I can do queries, I can add new tables. I just can't edit the structure of an existing one. I am using versio...more >>

I have this Stored proc in SQL server, which works perfectly when being run via Query Analyzer. The Stored proc is simple, just runs on a table and updates some fields in it. When calling the same Stored proc, with the same data, the Stored proc seems to run partly and then stop for no reason. T...more >>

Hello, I am trying to get info from a SQL7 database via ODBC. I can connect and view the vast majority of tables, but one particular table (ceninfo_data) does not appear. In SQL Enterprise manager, I have taken a look at the permissions on the table and public can select from it. What am...more >>

I need to link to tables in an AS400 on a customer site. They use IBM CA and have the latest 5.2 version. (IBM CA includes both ODBC and OLE DB drivers). I tried configuring the IBM OLE DB for AS400 driver using both graphical and sp_addlinkedserver, but with no success. The best I can get is a...more >>

Hello all We're running a web application on a SilverStream application server (3.5.3) which connects to 4 databases on a MS SQL Server 6.5 (SP5a) over ODBC (03.70.06.90). Quite often the application server looses the connection to his DB's. The web application doesn't answer anymore! We get...more >>

Hi Group, I wondered if anyone can assist me with an issue I currently have. I would like to export the contents of one table that to internet explorer, the query would need to repeat once every five minutes. Dependant on the results I would also like to colour format the output (Green for...more >>

Hi, My name is Rafael from Hilroy Technologies email: oz@ozbooks.com; HilroyTechnoologies@yahoo.com We need some help in resolving a problem of Shrinking the Transaction Log in the SQL Transaction Log. Our OS is Microsoft 2000 Advance Server The setup was configured to grow 20% without l...more >>

I would like to update a SQL table with information entered in a spreadsheet .. Can anyone tell me where to start. Frank ...more >>

We are currently logging IIS data to an SQL server. The amount of data has reached 14 GB. When we were logging to the IIS server as regular log files for the same period of time (roughly one month the log files were not more than 2 gb. There has been no real increase in traffic to our serv...more >>

can I import a datetime field from SQL to a tm structure without going to a string first? ODBC mentions timestamps and SQL uses datetime. I'm having difficulty understanding what I should do to import/export from a C tm structure to an SQL datetime field and visa versa. right now I have to con...more >>

Ok, here's the scenario. On a Windows 2003 Server I have MSSQL 2000 installed. On another test server I have Windows 2003 server, IIS 6 and Coldfusion installed. There has been an account created in SQL and assigned permissions. My coldfusion web site makes multiple calls to the database ser...more >>

Hi All, Does anybody know a way to get an ODBC connection (or SQL Server User) to do all it's reads uncommitted short of rewriting all the Select Statements (This is what I'm trying to avoid) Any help greatly appreciated. Regards Mark...more >>

Is it possible to receive empty dates instead of 01-01-1900 for NULL date fields (since SQL server does not accept empty date fields)? I'm receiving 01-01-1900 instead of empty date, otherwise I can receive NULL values but I can not use them due to my environment. I tried with the ISNULL SQL s...more >>

Hi I'm using a VFP8 cursoradapter to connect to a remote SQL server database via ODBC. I have a cursor which comes from a single table in the SQL server DB, and this table contains an identity (autoincrement) field. This table has not a unique index, apart from the identity field. When I add a...more >>

I want to make a backup of an sql server using sql dmo. When I execute this line I obtain the 80040c81 error . hr = m_pBackup->SQLBackup(server.m_pSrv); I search all over the internet byt this error code is not documented ..Anybody have any ideea? P.S On other machine work fine.... ...more >>

I have SQL tables linked in Access and they work fine. However, if I run the linked table manager on the SQL tables, I am informed that the links refreshed. When I open the tables, they are read-only. If I delete the tables and re-link them, they work fine again. Any ideas why this occur...more >>

I'm having a problem understanding why my left outer join in a crystal reports isn't returning expected results. According to documentation in crystal and sql a left outer join will return all the records in the left table regardless if there is or isn't a match in the right table. Below...more >>

Hello all, I am struggling to reconnect an Access97 mde file from our EDI application to a new sql database I have created a system DSN and manually linked the tables removing the "dbo_" Of the 12 linked tables 10 open fine (querys/forms realted to them are operating without error) The other...more >>

Further to my post on a problem on connectiong to SQL 2000 database's using Access 2000 as a front-end (see below), as the Access 2003 version is working correctly, should the Access 2003 Runtime version with the developer extensions work in just the same way ? Anyone using Access 2003 Runtime...more >>

#1. We have the ASP here on Houston server and it takes about 15 seconds to retrive 50 row table from Oklahoma via MS ODBC driver for Oracle 2.5. #2. But, we have the ASP here on Oklahoma server and it only takes about 3 seconds to retrive same 50 row table from Oklahoma via MS ODBC d...more >>

Hi, How can I determine the number of rows returned by a select statement in SQL server 2000? I do not want to use ' select count(*)...' the code would be - retcode = SQLExecDirect(hstmt, (SQLCHAR *)sql_stmt, SQL_NTS); /* get row count*/ // code to get the number of rows selected. w...more >>

Hi, Is there any way I can determine the number of rows returned by a select statement without using ' select count(*)...' the code would be - /* sql_stmt - a select statement.*/ retcode = SQLExecDirect(hstmt, (SQLCHAR *)sql_stmt, SQL_NTS); /* get the number of rows retrieved.*/ // co...more >>

I run some report in access 2000 that are based on ODBC connexion to SQLserver7. I want to know How can I stop a report(process) while it seem not responding for more than 30 minutes. It seems that if I do a dirty shut it slow all other user until we stop/start sqlserver. What I would like...more >>

I need to get MDAC 2.7 on a client machine. I have MDAC 2.7 Service Pack 1 Refresh on my computer. Can I just install MDAC 2.7 Service Pack 1 Refresh (http://www.microsoft.com/downloads/details.aspx?FamilyID=9ad000f2-cae7-493d-b0f3-ae36c570ade8&displaylang=en)? Or is MDAC 2.7 Service Pack 1 Refre...more >>

Hello, We have an application in Delphi which we connected with ADO ACCESS to DB1 (DATABASE ACCESS), where some of the DB1 tables are tie to DB2. We want to import to SQLSERVER DB1 and DB2, and to continue conserving in SQLSERVER, DB1 tie tables to DB2 IS POSSIBLE? if we have two databas...more >>

am trying to connect from one server to the SQL Server residing on a different server, but within the LAN, and the same domain. Previously I was able to connect. Recently the IP addresses of both these servers were changed. Once that was done, I was unable to connect from one particular ...more >>

Hello I have reported this bug previosly, but Microsoft has so far not responded yet, so I am reporting it again. Basicly, SET FMTONLY is NOT working correctly with SQL Server 2000. Because of this bug I still have to use SQL Server 7.0 for my campuswide student information system application, alt...more >>

Hello. I am an ODBC newbie using SQL server 2000. I am attempting to call SQLBindParameter on a column of type DATETIME. The C type is SQL_C_DATE and the SQL type is SQL_DATE. I am receiving the error named in the Subject of this message. Any ideas why? It seems odd to me that the ODBC ...more >>

Hi, Is it possible that an MSSQL ODBC connection is limited to one statement at a time? I'm looping on a result set generated by a call to SQLColumns() on some hstmt, In each iteration, I'm calling SQLGetTypeInfo() on a second statement hstmt2 to get more details about the type of the column,...more >>

This happens on all the web sites that have SQL Server databases (SQL version 7). The username is sa, password is xxxxxx. This only started happening at the weekend. We'd seen this error before recently, but restarting SQL Server service fixed it. Now that doesn't work. Restarting the server...more >>

I'm trying to create a System DSN, following all steps, but when I finish the wizard, the System DSN is not listed in the list box. Any idea ? Thank you ...more >>

Hi All I found an error ( run time error 3669. Execution cancelled) when ran the following query via VB6 SP5. select crc,month,sum(v) as v from ( select crc,v, case when fadate between '1/1/2003' and '1/31/2003' then 1 else 2 end as month from...more >>

Hi there, I'm trying to connect to Ingress 2.0 from ASP page but not sure of how to! Iwas wondering if it is possible for such a connection. Can anyone help me in telling me how to create an odbc connection from ASP page?? or is it easy to connect to ingress via sql stored procedure? I no...more >>

I have a problem with bcp and format files. We changed our databases from varchar to nvarchar to support unicode. No problems so fare with that. It is working fine. But now I need a format file for the customer table and and it is not working. It is working fine with the old DB with varcha...more >>

I recently set up a Linked Server to an Oracle Db for my SQL Server. I ran an Openquery to be able to see a table on the Oracle Db. I can see the results from the query, but really want to be able to say the query/view so that I can select it in the future for other queries. When I go to save...more >>

Hi Is it possible to stare dates before year 1753 in SQL server? Looks like it doesn't accept them. Also, is it possible to receive empty dates instead of 01-01-1900 for empty date fields? I'm receiving 01-01-1900 instead of empty date. I'm using Visual FoxPro 8 SP1 against a SQLserver 2000 se...more >>

SQLSTATE: 07002 Native error: 0 Message: [Microsoft][ODBC SQL Server Driver]COUNT field incorrect or syntax error I get the above error when i try to submit the line below to SQL. Stop.connect_time is a SQL_timestamp_structure. what could be wrong? SQLBindParameter(hstmt, 3, SQL_PARAM...more >>

Hi, i' ve a problem: when i attemp the connection from the Control Panel -> Administrative tools -> ODBC, i get the message "TEST FAILED!" My PC is configurated with MDAC 2.7 and SQL Server 2000 SP2. Is a good idea to install SP3a (that contain also MDAC 2.71)? Any ideas?! Thank' s. ...more >>

Hi, On one side, I have a Sybase 12.5 32 bits Server running on AIX 5.1 (maintenance level 3). On the other, I've got W2000 5.00.2195 (SP2) with SQL Server Standard Edition, Product Version 8.00.534 (SP2), having installed MDAC 2.6. I connect to the Sybase 12.5 database using Merant ASE OD...more >>

Hello, I am upgrading a database from SQL Server 6.5 to 7.0 and am now having problems with blocking. An application written in MS Access using DAO is causing the probem when trying to open a querydef recordset. The application just freezes until it times out and then comes back with an ODBC erro...more >>

i'm getting an error, Unable to connect to server Server :Msg17,Level6,State1 [microsoft][ODBC SQL Server driver][TCP/IP Sockets] SQL server does not exist or access denied Can someone help me...more >>

Hi! I'm totally new to SQL, so please bear with me. Going to backup a database in SQL 7.0. I'm comfortable with the backup procedures. However, I get the following message: (header) MSFT SQL-DM0 (ODBC SQL State: 42000) Teh volume on device "C:\mssql7\backup\*filename*.bak is not part...more >>

On one of our domains we have win2003 enterprise and SQL 2000 enterprise installed. The clients that access this server are windows 2ooo prof or XP prof. When trying to connect to the sql2000 server through ODBC. I get the error [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets] SQL Server ...more >>

Hi all, I'm using the MS Access Link Tables function to link to a SQL Server 2000 DB and the list only shows 1 table (actually, it's alphabetically the first view in the DB. The server is new and we recently moved the DB to it, but nothing in the DB itself looks different or suspicious. Perm...more >>

AFter upgrading a SQL 7.0 server to SP3, our previously working odbc connections to a database are failing, saying - SQL Server Error 18452. Login failed for user sa - not associated with a trusted SQL server connection. Any ideas?...more >>

Hi, We have a requirement to display records from MS SQL database in pages of predefined rows. In Oracle, we can incorporate this paging logic using "rownum" pseudocolumn. I am new to SQL. Is there any equivalent of rownum funda in SQL ? Thanks & Regards, Aparna S....more >>

Hi, to load an Access 97 *.db-file in my SQL-Server I need an appropiate ODBC-driver. Where do I get one? Thanks in advance Jochen ...more >>

I am working with a form on an ASP page and getting the following error when attempting to insert data into my MSSQL7 table which had been working fine. Microsoft OLE DB Provider for ODBC Drivers error '80040e57' [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would...more >>