Hello Can we create a new Package in SQL Server (T-SQL). Oracle has the option of creating a new package using 'CREATE PACKAGE' Is SQL Server has anything similar to this....more >>

Hello I have a user who is attempting to connect to SQL Server Enterprise 2000 SP3a running on Windows 2000 Server. The client has WIndows NT 4.0 with MDAC 2.8. The problem is that when I attempt to create the ODBC link , I receive the following error "connection failed sqlstate '01000' sql ...more >>

Hi all, Our company currently has no Database servers, neither centralized ones like SQL Servers or standalone/P2P ones like Foxpro. And in terms of Spreadsheet programs like Excel, can it take over, because of the data size is quite small (Excel 2000 with Macros), those database engines? We'm j...more >>

At one point I had the odbc 3.5 developers guide but I had to leave that behind as a result of a layoff. Now after several years I find I'm getting back into odbc but when I search I find that all books on odbc are out of print. Some are still available like the 3.5 developers guide but har...more >>

Hello We are in the process of migrating the Oracle database to SQL Server. We need the help on the Exception Handling in SQL Server The existing Oracle stored procedure is using the Exception DUP_VAL_ON_INDEX, which raises when the duplicate values gets inserted in the Indexed column. (typciall...more >>

I'm attempting to connect to a SQL Server named 'SQL1' using ODBC. In doing so, I receive an error stating the login has failed for user 'null'. I don't believe this to be a SQL permissions issue because the user in question can successfully connect to 'SQL1' from another pc. Also, I don't th...more >>

Is there a way to restrict an ODBC connection to the database? I.E. only allow ODBC access to a database if from a specific VB application. Do not allow the DSN to connect using Access, Excel, etc. Thanks, JB...more >>

Is there some fuction that allows me to put different types of locks on a table For example, I would like to lock a table for writing, but allow other applications to read from the table Thanks for any help Steven...more >>

Problem: I came in this morning, and our SQL server's IP address was changed from a static to dynamic IP. I changed it back, but not sure if that is the cause of the problem I am having. Running some reports in Access 2000 that queries through ODBC to our SQL Server 2k. We are getting a...more >>

I have been struggling with an MSSQL problem for a couple of weeks and hope this is something someone else has already solved. In my situation, I have a VB interactive front-end on multiple machines accessing a SQL2K database through ODBC over TCP/IP. It has been in service for over 2 ye...more >>

Is there a certain way ODBC will accept variables and if statements in one call For example: If I want to update a table, first to check if the entry exists in the table, if so update, if not insert Is this possible Thanks for any help Steve...more >>

Hi everybody, Yesterday I was unable (frusttratingly) to attach the single file (.mdf) db in any ways I found from this world and e-world. Then I figureed out I had to install SP3. Now I have my SQL Server 2000 updated with SP3, and tried to attach the db (both files .mdf and .ldf) using ...more >>

I have a user accessing SQL Server 2000 data through Excel and MSQuery...we have used ODBC DSN with no probs. It is only this user with an issue, so very specific to their setup somehow. Example databases called A and B. User had ODBC DSN set up to default database A. We want it to be B....more >>

Hello Perhaps someone can suggest a solution. I have a Domain (on the net -- Hosted). It allows me to have an MS SQL DB. The DB is created (the host creates the db).... but how can I actually design/administer it from my computer at home? Do I need special software? I know the host does not ...more >>

Hello, I have a problem with an sql script doing a conversion for example select CONVERT(decimal(25,2), amount) as amount from mytable The problem arises when there is a null or blank value for the column as expected it bombs out. I cant change the data in the table as it is too late...more >>

Any Help?? Error occurs while connecting thru QE or trying to register in EM Server: Msg 17, Level 16, State 1 [Microsoft][ODBC SQL Server Driver][Named Pipes]SQL Server does not exist or access denied...more >>

Could you tell me which conformance level sqlserver 2000 odbc drive support Core,Level1 or Level 2 and whichconformance level sql92 languange support Thank you for your help...more >>

When trying to access the sql server database I am receiving the following error: An error 1069 - (This service did not start due to logon failure) occurred while performing this service operation on the MSSQLServer sevice. Any help would be greatly appreciated!!!...more >>

I run SQL 2000 with Allaire/Macomedia ColdFusion 4.5.1. I just today received a strange error and my web server slowed to a crawl and then locked up. I got this error in the logs: ODBC Error Code = ()<P><P> Unable to instantiate environment for 'ODBC.' Any thoughts?...more >>

We recently upgraded from version 6.5 to 2000. During the process the WIzard did not complete. It apparently build all selected databases but did not migrate the data. The last line in the smmarylog reads "Preparing SQL-DMO for upgrade=0". At any rate we decided to press on with the upgrad...more >>

I'm using MFC(Visual C++ 6.0), SQL Server 2000 and ODBC to connect to SQL Server. I have a table that has a blob(image) column in it. The structure of the table is CREATE TABLE [dbo].[lbx_blob_1096] [ID] [int] IDENTITY (1, 1) NOT NULL [Date] [varchar] (11) COLLATE SQL_Latin1_General...more >>

Hi, (I'm quoting this from elsewhere but here is my problem) ---------------------------------------------------- "With MSDataShape shipped with MDAC 2.8, there is a new limitation on the query length we can supply to the Open() method of a recordset. In fact, the hierarchical query must n...more >>

Hello, I use Linked Tables to connect to my SQL Server database. I have a number of reports which worked fine when I was using test data (few thousand records). I just loaded in a million records and ran a report, and received the following error: ODBC call failed when running this...more >>

Hello Experts, When I Open Enterprise Manager and click on my server, following msg appears: SQL Server Enterprise Manager ---------------------------------------------------- A Connection could not be established to (LOCAL). Reason: Data source name not found and no default driver sp...more >>

I am doing a database query in Java, and it seems to work fine using any of the fields except for the date. I am assuming that this has something to do with my syntax, since the DATE type has the most complicated syntax. My query looks like the following: SELECT * FROM Employee WHERE BDATE='4/...more >>

Hello I have set up a sql server database with three tables, and I am using MS Access as the front end for user view, inserts, and updates The transaction properties for the database are set as follows lock_timeout = 180 Session isolation level = serializabl access mode is multiuser Recently, ...more >>

This is a re-post as I didn't get a resolution to the problem Using MDAC 2.8 I have set up my SQL Server and set SQL SERVER authentication and for some reason when I connect through ODBC I can't see any of the tables. It logs into SQL server just fine, I have set the appropriate rights ...more >>

What would be the equiv. setup with sql server that oracle has with its tnsnames.ora file? thanks --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.624 / Virus Database: 401 - Release Date: 3/15/2004 ...more >>

I have tried to install SQL 2000 standard on W2003 Web edition. When I click on "Install Database Server" (Installation pane) a small icon "Created with DemoShield" appears for few second and than disappears. Then nothing happens .. :o( All web services (IIS, FTP, NNTP .) were stopped before i...more >>

I am having trouble getting a pass-through query in Microsoft Access 2002 to work on one of my computers. Here's the setup Computer 1: Windows XP Professional, MDAC 2.8, MS Access 200 Computer 2: Windows 2000 Server, MDAC 2.6, MS Access 2002, Running SQL Server 200 My Pass Through Query invokes ...more >>

When trying to install MDAC 2.7 on a Windows 98 client I receive the following message: Setup has determined that you do not have enough free disk space to install this software. The following box shows how much disk space is required on each drive. ......and there is nothing displayed i...more >>

Hello I'd like to use a unique constraint on a field which may be null. Like CardNum in the example Id Name CardNum 1 Dupond 159599700512630 2 Durand <NULL> 3 Dubois <NULL> 4 Martin 162599710445609 5 Martine...more >>

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 >>