Does anybody really know is it possible? We don't want to create a linked database, but we need to make some steps on the remote database, gather some data and then send this data to our main server via IP connection, setting the connection every time when the remote server wants to transfer the ...more >>

Hi, after I tried it a few times without success, I'm searching for a step by step guide how I can realize a odbc-connection to a sql-server through the internet. In the local Network where the Server is installed the port 1433 is opened, directed to the server and I know the WAN-IP-Adress ...more >>

Two part question: 1) [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets] SQL Server does not exist or access denied. I have SQL & Windows authentication set on the server, I'm running SQL 2000 - 8.00.194 and Standard Edition Win 2k(5.2). Do I need to "Set Impersonate = true"...more >>

I wonder if any of you good people can help? I dont know how to go about this problem that im having. error 7399: OLE DB provider 'msdasql', [3kodbc.dll] connect: connection refused] OLE DB error trace [ole/db Provider 'MSDASQL' IDBInitialize:: Initialize returned 0x80004005 does this mea...more >>

I have just rebuilt the boot drive of a PC used as a server using MSDE 2000. It is running under Windows 2000 SP4. Since the rebuild, anyone with less that administrator priveliges on the local machine have been denied access to the SQL server. In the ODBC server DSN configration setti...more >>

Does MS Access use ODBC or OLE Db to create a database on SQL Server? If OLE DB...is there anything to configure/inspect about OLE DB? Lou Arnold....more >>

I have a VBA button that queries a SQL db and the system DSN is setup identical on 2 PC's. Security rights for the user are the same. I get the following error on one: ODBC Code: S0002 Native Database Error = 208 Origin = [Microsoft][ODBC SQL Server Driver][SQL Server] State:37000 Retur...more >>

I have SQL Server 2000 installed on a server in my office. All users running SQL Query Analyzer in the office work fine, but in my Office out of state the Users get: Unable to connect to server XXXXX: Server: Msg 11, Level 16, State 1 [Microsoft][ODBC Sql Server Driver][DBNETLIB] General ...more >>

I am a programmer but I have many years of experience with Sql Server from 6.5, 7, and 2000 versions. I have a problem I have never seen before, the first I have been unable to resolve myself. After installing the latest Micrsoft Windows XP patches (issued this past month) and rebooting the...more >>

I am getting a Timeout Expired message when executing a query against a linked server. The query is basically "INSERT INTO local_table(...) SELECT ... FROM table". When executed from Query Analyzer the query takes about 34 seconds. When I run the query from my VB6SP5 application, I get th...more >>

Hi, I'm getting the runtime error 2046 (The command or action '|' isn't available now.@* ...) when I try do delete a record from an SQL SERVER 2000 table in an Access 2000 form. The strange is that if I try to delete the record again it works, and this error message just appears sometimes... ...more >>

Hi, Any help with the following query would be much appreciated. We are developing an application in VB6 for SQL Server 2000 (SP3), running on Win2k and have come across the following issue: We have a 30 character attribute/column (varchar) in which we store surnames. We now have some re...more >>

Hi all, I'm writing an app to export my ODBC connection information to XML format. There is already a standard File .DSN format, but was wondering if there's already an XML DTD or XML Schema for DSN's out there. I definitely don't want to reinvent the wheel, and if I'm able to export my info ...more >>

Greetings I have recently migrated several databases from SQL 7 to SQL 2000. When accessing one table in one database with a simple SQL statement (SELECT * FROM tablename) I am receiving error -2147217865-Invalid object name 'tablename'. Is this related to the migration to SQL 2000 from SQL...more >>

For some reason, this week we started to get "SQL Server does not exist or access denied" error messages when attempting to connect to our SQL Server databases. This only affects people who dial into our network. But this seems to be a rather complicated situation, so let me explain. We have a...more >>

What software/application offers the fastest performance when reporting from a SQL Server database. Currently I am using MS-Access with an odbc connection to the database. Although the tables are indexed, they are somewhat large and multiple links are needed in queries. The result is that in som...more >>

I have a VFP8 application that calls a stored procedure in SQL 2K that runs the follwoing TSQL... update dbo.interview_activity set status_filename = @status_filename where interview_id = @interview_id and activitycode_id = 12 and isnull(status_filename, '') = '' when this runs,...more >>

I have set up the ODBC connection and can view the table in EM, but cannot access the information through QA, according to a 'provider' error.? Any ideas? thank you. Kyle ...more >>

Hi, how the subject say. I have problems for register databases server or odbc. When i try to do it, the enterprise manager send the next message: A connection could not be established to "SERVER" Reason: Specified driver could not be loaded due to system error 126 (SQL Server) ...more >>

This should be a no brainer, but I'm stuck. I need to load the sql 2000 driver on a workstation to make odbc calls to the database. I've done it several times before, but I (obviously) can't remember where it's at. I have the CD's for SQL 2000 personal and professional edition. What do...more >>

I'm using Access 2K via ODBC to replicated SQL Server 2K. In some tables (not all) when I try to add a record either with a form or directly in the datasheet I get this error message and all form controls/table cells display '#Name?'. The record is added and displays correctly if I close and reopen ...more >>

I tried to manually start a job from Enterprise Manager and got ' Error 22022: Unable to post notification to SQL ServerAgent (reason: MapViewOfFile() returned error 8, 'Not enough storage is available to process this command') This happens quite often. Every time I have to re-start the ...more >>

The network consists of 3 servers: a BDC, a PDC and a stand-alone server. There are about 30 client workstations (some Win98, some WinXP Pro). SQL Server 7.0 is running on the stand-alone, which is running Win2k. The stand-alone server was brought up and SQL Server 7.0 installed approx. 6...more >>

Hi All, Can someone point me to a site where i can download SQL Profiler for SQL Server 2000 server. Thanks In Advance, Venkat ...more >>

I need to install IIS4 lockdown for FTP services. However, when i installed it, it caused problems with my MS SQL 7.0 installation. I had to re-installed the old odbc from the sql7 cd and rerun sql service pack 4 in order to get the SQL7 to function again. Can you PLEASE help me on how ...more >>

I have a 3 layer system, SQL Server 2000 database, COM+ dll's (VC++ 6) and ASP frontend, this system has been in production for quite some time using english, spanish and portuguese versions. Now I've been asked to test the system to function with Simplified chinese. The development of the system...more >>

hello! I am currently using SQL 2000 and Access 97. My desktop used to be Win NT. Recently i migrate to Win XP and I got this error while SELECTING, UPDATING and INSERTING record. Full error is Runtime '3146'.ODBC call failed. The documentation for this error is quite limited, anyone c...more >>

Hi, I am trying to create a linked server to DB2 using IBM 64 bit OLEDB provider, as Microsoft doesn't have a DB2 OLEDB driver for 64bit. When I test the connection to DB2 using the driver, it works, but when I try to query DB2 using a OPENQUERY it gives me this message. "Error 7399:...more >>

First, if I'm posting this in the wrong newsgroup, please let me know and I'll re-post elsewhere. Trying to get SQL Server 2K data into an Access 2K front-end application (we're upsizing our back-end DB's to SQL Server, want to keep mdb front-ends). To limit the returned recordsets for both f...more >>

I have two fields in different tabels. I have a calcualated field in a view that goes something like this: mato.pmainT.product + mato.woodtype.short It seemed to work OK, but I found if mato.woodtype.short is null, it won't display mato.pmainT.product either! I would like it to display mato.pm...more >>

When trying to update a specific row in a table an error occurs. [Microsoft][ODBC SQL SERVER DRIVER][SQL SERVER] SQLDumExceptionhandler. Process 51 generated fatal exception c0000005 ACCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. What could be the reason for this? The...more >>

Hi ng, is it possible to suppress the ODBC-Dialog, when i test the connection to my linked tables an the connection is not alive? (the dialog, which is asking for username, password, servername, etc....) thanks, Stefan ...more >>

I am running an application that runs fine on MDAC 2.6 but when I run it on MDAC 2.8 have the error: Error on the DLL How can I rollback MDAC 2.8 and what will be the consequences on the Windows XP system? Application uses ADO.Open method and crashed here. Isn't MDAC 2.8 backward compatible...more >>

Hi, I'm getting following error while creating a DSN from remote stations PC. I could create DSN from the PCs available in the LAN. Connection Failed: SQL State: 01000 SQL Serve Error: 011001 [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectioOpen (Connect()). Connection faile...more >>