Hi We recently upgraded an Access XP database to SQL Server, but continue to use an Access MDB as the front end (more mods need to be done to migrate the front end to an Access Project). In the original Access database, several tables use an Access AutoNumber data type as a primary key. At one p...more >>

I'm currently having to create a raft of DB2 connections in a reasonable hurry. In addition, this list has to be propogated to three other workstations (ultimate goal is to have DBArtisan access the servers, instances and databases in an identical manner without having to spend days doing this m...more >>

Hi!!!! I need to remove the MDAC in order to remove ODBC drivers. How can I do this??? I have Windows XP SP1 which comes with MDAC 2.7 but the third party application installs an older version of MDAC (it seems to be MDAC 2.1) and now another third party applicattion claims to install a M...more >>

i have installed command prompt based sql server, i am not able to connect to different sql server using odbc or using sql server, could u please help me resolving this issue...more >>

I installed MSDE 200 on my machine running XP home edition. I cant connect to the db using the SQL mode, but i can connect using the in windows modes. It returns and odbc error stae 28000 , i dont know how to correct this. If set up and odbc connection and try to test this, it returns...more >>

I have SQL Server loaded on my standalone laptop. I tried to attach a database( xxx.MDF) and got an error as above. How do I resolve this ?...more >>

How to create dbase file based on SQL-92 which have a FLOAT column like float(14,2): => xxxxxxxxxxxxxx,xx <= Thanks in advance, Patrice ...more >>

I have a client in a Windows 2000 SP4 network environment that is using Backup Exec 9.0 with a remote agent for Exchange and a remote server. They ran the Windows Updates last Friday and now they are receiving errors on their backup job when it tries to back up the server that they update...more >>

It is possible to create odbc through files? what is the code? Thanks Francesco ...more >>

I have a ATL DLL running in COM+ Applications that communicates with SQL Server via ADO Command Object. We occasionally get Timeout Expired errors with one method that is used to call stored procedures that return output parameters. The error can come back quickly or take a while. I have ...more >>

Hi All, How can I execute stored procedure with parameters in Visual basic Thanks...more >>

Sorry for the cross-posting, but I'm not really sure in which newsgroup this should be posted. Anyway... I have SQL Server 2000 with SP3 installed on my computer. I'm able to use Query Analyzer to open tables on the various databases running under SQL Server, but whenever I try to do so with...more >>

Hello everyone, I am trying to setup a ODBC source using SQL Authentication. When I finish my settings and test the connection, the connection is successful. But, when I click the finish to exit out of the configure option of the ODBC source, and then go back into the ODBC DSN, the password is ...more >>

Hi, All SQL2000/sp3 and Sybase 11.5 There is a SP on Sybase CREATE PROC sp_test @t VARCHAR(32) = 'default string' AS SELECT @t I want execute that from SQL SELECT * FROM OPENROWSET('MSDASQL', 'MySybase';'uid';'pwd', 'exec sp_test') works file. But with the parameter it fails ...more >>

Our Webserver(win 2000) recently crashed and they were able to get it back by using the Exchange2000 restore disk. Since they restored, sql server(2000)/IIS 5.0 is not functioning. We are unable to run an asp page on the website, htm, html are the only pages that will load in the browser...more >>

Hi, I'm trying to access a MS SQL Server db from a CGI (pure C program). Which is the most efficient (fast, incl. fetching many records on a search term) ...using embedded SQL in C, ODBC or any other methods? Any suggestions? Jon...more >>

Hi all, Apologies for the cross-post. Just wasn't sure where to put this one: I'm getting this error sporadically on an ADO connection. When it happens I also cannot connect through the Enterprise Manager (or anything else!). The environment is SQL Server 2000 running on Windows 2000 Ad...more >>

Hi, What will be the connection string in the JSP to SQL Server 2000? Thanks. Jason...more >>

Hi To All i Have Encountered Such A Problem In SQLserver2k Any One To Help ME Technical Information (for support personnel) Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D) [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'MZZ\IUSR_MZZ'. /ostandari...more >>

I'm trying to copy a table from one database to another using the DST wizard. Everything works find until the last step.......at that point I get an error that says "Error at destination for row number 1. Errors encountered so far in this task: 1. Line 1: Incorrect syntax near 'Collate'. " Alt...more >>

I have created a linked server using an OLE DB service in a SQL Server 2000 database running on Windows NT 4. I can see all the tables and views of the linked server in Enterprise manager, but when I go to a client machine and try to setup a DSN to the linked server using an SQL Server driver ...more >>

I use Open(dbOpenDynaset,Sql,dbSeeChanges); to open the SQL server ,lt's very slowly, Are there any ways to accelerate ? ...more >>

Hello, I=B4m having a problem with an specific client. When the=20 user try to connect to our application, the following=20 message appears: Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E57) [Microsoft][ODBC SQL Server Driver][SQL Server]String or=20 binary data would be...more >>

Hi there, I've got something kind of weird going on. I have a stored procedure that normally takes less than one second to execute, but it has started taking over 30 seconds from time to time. The SP is called by an ASP page on a web server, running on a separate machine. The database ser...more >>

I have a VIEW SQL connected to an other database. How I can connect this VIEWS in ACCESS inserting one key in runtime? --- Posted using Wimdows.net NntpNews Component - Posted from SQL Servers Largest Community Website: http://www.sqlJunkies.com/newsgroups/...more >>

Hello, Can a SQL Server table become corrupted? The tables are linked to an Access DB and I cannot open the main Order table from Access. I am connected to the system remotely via Terminal Server and do not have Enterprise manager available. I can't imagine what the issue could be otherwi...more >>

We are running an sql server database on a windows 2000 server, aproximately 15 clients on our lan use odbc connections to connect with acces 2002 front end. No problem. Then i came up with the idea to connect a home-worker via internet, using a vpn tunnel over isdn. Somehow this vpn-over-isdn c...more >>

Hi This is new to me. I am trying to connect an asp page to sql server. Any help would be gratefully appreciated I get the error message: Technical Information (for support personnel) a.. Error Type: Microsoft VBScript runtime (0x800A01A8) Object required: '' /idataconnect...more >>

Is there a way to get the length (i.e. number of characters, bytes ... ) in the metadata information for a resultset? I'm using low level ODBC calls, and my problem is that both SQLDescribeCol and SQLColAttribute return the column size for the length. This doesn't sound bad, but when reading the...more >>

Hey folks.. I have a linked server that connects to a DB2 database through the OLE DB for ODBC Providers driver. I have a DSN created and can, through the linked server run SELECT statements to my heart's content. When I want to run a simple DELETE, for example (DELETE HCEDB.APPLQUE2), I ge...more >>

I'm trying to determine how to save a bmp into my image field. I see the bulk copy instructions, but that is only good if you know the size of the bmp and write it into the format file. I need to save directly into the field from a vb6 app. Any thoughts? Thanks ...more >>

I am trying to get SQLDescribeCol to return column names (alias) from multiple result sets in a stored procedure but it returns a nil string. I have also tried SQLColAttribute with no success. Any suggestions, places to read, different newsgroups, code to try, etc. ??? -- Thanks, Lewis...more >>

New user of SQL Everything is on the same machine My error is close to the bottom After reading it today, I can see there is a problem with 2 dbases 'PUBS' and 'Master' There are also some comments from the group: ---microsoft.public.sqlserver.odbc-- subject: Permission Denied -- Thanks for h...more >>

Hey, I'm trying to link a table in an Access 2000 DB to a table in an MS SQL Server 2000. As you might have guessed by now I'm not having any luck with this. This is what I've done: I've used a file-dsn, which logs on to the SQL Server DB using the logged on NT account. This account, which ...more >>

Hi, I need to setup an ODBC link over our Internet connection between MS Access (local) and a MySQL server (Remote - the local PC has the MySQL ODBC driver installed). What kind of bandwidth requirements am I looking at? Will it function over a 64k leased line? If this would be slow, could the...more >>

We have an application that logs into our SQL Server 2000 using ODBC. All service packs and critical updates are current on the server and clients. SQL Server uses mixed authentification and runs under a domain account, the users login with their domain\username, or at least they used to. Nobody ...more >>

Hello Situation: Application->ODBC->MSSQL2K I need to change some queries (replace) between ODBC and MSSQL on the fly, or, in the other words transparently to application modify some query before they executed by SQL server. Another Q. There is the query: SELECT COUNT(A) FROM B WHERE B.A='C'...more >>

Upgraded a server to MS SQL SP3a and Windows Server 2003. Now when in SQL Enterprise Manager and I try to access a linked server from this upgraded server I get the following error: Error 7302: Could not create an instance of OLE DB provider 'SQLOLEDB'. OLE DB error trace [Non-interfac...more >>

Has anyone ever had problems with linked Sequel2000 tables in Access? I = have one database that keeps shutting down when you place the mouse over = a linked Sequle2000 table. The only thing I have noticed is it is only = on one machine. Other machines open the same database and have no = pro...more >>

I have developed an Access 2002 fornt end for an SQL database. When an form is run, it opens a limited set of data that is updatable - the sql table is updated directly from the access table, query or form. This works fine on our intranet. When accessed from the internet, however, I am ...more >>

Hi all! Is there a way to get a list of indexes via a SQL statement? I'm working on a DB documentor, and am able to retrieve almost everything else about the definitions, but I haven't been able to get a list of indexes. Thanks! Sloan ...more >>

What's the best way to restore or create a copy of production db (15 GB) on development server and also another copy on same sql server with different name. The copies need to be refreshed on a monthly basis. 1. For doing above things what's best and can some one post sctips or TSQL stateme...more >>

Hi, I am using MFC ODBC classes in my VC++ application for database accesss (on a SQL Server/Access Database). Some times after opening a Recordset (containing bound columns generated using the ClassWizard) I have to use the CRecordset::GetFieldValue( LPCTSTR lpszName, CDBVariant& varValue, sh...more >>

Windows Pro VS.Net ..Net Framework ASP.NET My 1st time using Web Forms in .Net 1st time using SQL I am receiving the following error: System.Data.SqlClient.SqlException: CREATE DATABASE permission denied in database 'master'. Could not attach database 'pubs' to file 'D:\Program Files\Micr...more >>

I have sql server 6.5 with sp5a on windows 2000 sp3. I am trying to upgrade to sql 2000. I have no problems untill I try and export the data from one of the tables and then I get the following error [Microsoft][ODBC SQL Server Driver] Protocol error in TDS Strea According to the web site, microso...more >>