I am running SQL Server 2000, trying to create a new database and received the following error: [Microsoft][ODBC SQL Server Driver][SQL Server Login] is aliased or mapped to a user in one or more databases. Drop the user or alias before dropping the login. Can anyone assist me with t...more >>

Hi, I am trying to batch processing stored procedures with SQL 2000, MDAC 2.8. All settings are default. SQLSetStmtAttr is called with SQL_ATTR_PARAMSET_SIZE set to the number array elements. I am using ODBC CALL escape sequence. I noticed from SQL Profiler trace that the stored procedure...more >>

Hello everybody, I've got a C# application which has a SQL server 2000 backend. I need to make a change to the data access layer of this application to allow connections to an ODBC compliant database. The problem that I'm having is that I can't figure out a way to transfer the stored procedur...more >>

I am trying to access my sql server database using frontpage. I keep getting this error: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'JEFF\IUSR_JEFF'. I have messed with specifying a system dsn connection to this database to no avail. If there are some other settings I ne...more >>

I want to use multiple concurrently active statement handles on a single connection handle. An ODBC call to SQLGetInfo with the SQL_ACTIVE_STATEMENS key returns 1, indicating that there is a limit of 1 active statement on a single connection. If I try to SQLExecDirect on another statemen...more >>

I am hoping to find a reference for the procedure on connecting one SQL server database (SQLServerA) with another SQL server database (SQLServerB) where SQLServerA is in a different physical location and on a different network from SQLServerB. In the past SQLServerA was an Access database ...more >>

We installed the MDAC 2.8 upgrade and our existing Microsoft OLE DB Provider for Oracle stopped working. Other providers were fine, i.e. SQL Server (linking to another mssql server). Has anyone had this issue? Or does anyone have any ideas as to what changed in 2.8 that would affe...more >>

I'm running SQL 2000/SP3 on a W2k server. I have a database with a standard user (dbo rights). From any of my workstations I can create an ODBC connection using SQL authentication. When I try to create an ODBC connection on the server itself with the same credentials, I get an error msg "login f...more >>

Hello, I have been working on updating an Access 2000 application that uses linked ODBC tables to connect to an SQL Server 2000. My development machine is connected to the server over a Microsoft LAN, at 100Mbits. Both the Office 2000 on my development machine and the SQL server has all the l...more >>

Does one exist and if so, where can I get it from Thanks Dave ...more >>

I'm trying to create a binding to a stored procedure on a SQL server. I can create the database connection and view the tables and stored procedures. When I try to create a stored procedure binding I can choose the connection and the procedure. But when I check "Returns DataSet" and click Test......more >>

Hi How to create a Linked Server (SQL2K) connection to DBF´s files (Provider name, product name, data source, provider string,location and catalog options) I've tried the following provider name: Microsoft OLE DB Provider for ODBC drive product name: MSDASQ data source: BOOK (a system ODBC d...more >>

I'm trying to connect a NT 4.0 Workstation to a ODBC database (SQL 2000). When I use the the ODBC Data Administrator on the WS to create a new DSN there are no ODBC drivers available. How to install the missing driver Thanks for help Dirk...more >>

I am feeding a connection string and a query (stored procedure that uses a temp table) to a MS Office Pivot Table control. I have read the article listed below http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q235/3/40.asp&NoWebContent=1#applie...more >>

I have SQL Server Developer Edition which runs on Windows XP and it has been running fine thus far. I am now trying to run Analysis Services on it and it needs OLE DB Provider for ODBC. I downloaded MDAC 2.8 and installed it on my Windows XP platform. The installation went without a hitch but whe...more >>

Hi Sir/Madam, I have a error from my ASP, SQL application as : Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot sort a row of size 8162, which is greater than the allowable maximum of 8094. The SQL query in ASP code as: SQL...more >>

I have set up a database and set up a user assigning full rights to the database by table and views, etc. On the client, I can't see the tables via ODBC. logged on as the database user I set up. Even though I have set all the permissions. If I log on as SA then I can see the tables, but whe...more >>

How do you insert a NULL value when using bcp_moretext If I have a table with two 'text' or 'image' columns, and I am using bcp_moretext to insert a very large LOB into one of them, then BCP requires that I use bcp_moretext for both of them ("use it for one 'text'/'image', then must use it for all...more >>

I've discovered that when using BCP to insert character data, then for any sequence '\' + <newline> (backslash + ASCII 13), the '\' character is stripped. For example, try inserting this "Hello\\n and you'll wind up wit "Hello\n Can I turn this behavior off, or is this a known bug in BCP I...more >>

I can't get my stored procedure to execute from MS Access without throwing a datetime conversion error. I would greatly appreciate any help anyone might be able to give me in curing this puzzling problem. I have a stored procedure in SQL Server 2000 that has an input parameter @startda...more >>

Hi I have an old VB5/6 application ( the vendor went bust years ago) that connects to SQL7 via ODBC only. Its always worked fine, until I got some new XP clients. With these I can create my ODBC datasource and test it fine, but when the App tries to use it I get a stack dump (you know with ...more >>