hi, I have a question. Maybe You know the equivalent to command LIMIT from MySQL I couldn`t find something like this in MS SQL PS I try to display 10 records begining form e.g. 4 sort by id something like: "SELECT * FROM table WHERE name=... LIMIT 4, 10 ORDER BY id" in MySQL thanx, Urba...more >>

Hi, I am using Windows 2003 Server. The VPN works fine, but I want to FTP through the VPN so the connection is encrypted. The problem is each of my IIS sites has a real Internet address specified, w.x.y.z. So when the VPN comes up using a private IP, I can't connect to any of the FTP sites u...more >>

I'm setting up a DSN for a new SQL Server install, and had some problems with an existing Access app. Every query resulted in an "object not found", and after a little poking about it became clear that it was because the app was connecting to "master" instead of our database. The connection...more >>

Hello NG, the code below works, but if i add the outcommented part of it (the Uid and Pwd section) the function fails and returns false. Why is that so? Do I have to add a addidinalt Parameter? Regards Michael <CodeSchnipsel> private bool AddSQLUserDSN(string DSName, string DBP...more >>

I have an app which connects to SQL Server via an ASP (thru IIS). At times I get SQL errors which are listed on the site below - http://support.microsoft.com/default.aspx?kbid=328476 I need to know the following 1. How do I know whether I am using ODBC or OLE DB ? 2. How do I set a retry co...more >>

I have a form whose source data is a select query on three tables with inner joins connecting them: SELECT dbo.LOCATION.[Location code] AS LocationCode, dbo.Clusters.ClusterNumber AS ClusterNumber, dbo.Clusters.ClusterName AS ClusterName, dbo.LOCATION.Cluster AS Cluster#, ...more >>

When creating a SQL Server ODBC connection via Data Source applet on a WXP workstation, when clicking the drop down menu to select the server, two instances of the same server appear. We recently migrated our SQL server to new hardware. Turned off the old server and gave the new server the sam...more >>

Hello everybody, one of our users gets an error message when trying to connect to our SQL Server database: Connection failed: SQLState: '28000' SQL Server Error 18452 [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL S...more >>

Designing a Simple Database --------------------------- Design a simple database for storing information about your private Book collection. The ideal design for the database will represent all the information specified in an easily understood schema without unnecessary redundancy. You ...more >>

Friends, Hi .... I have been connecting Excel pivot tables to SQL server tables and views through an ODBC DSN connection. I know there is a way to connect a pivot table to a SQL Server stored procedure, but can't figure it out. The Excel pivot table connection wizard doesn't seem to...more >>

Hello, I am using SQLPutData() in a loop to move a large BLOB (3MB in total) to and from the database and when I retrieve the BLOB I find that a large section of data has been replaced with the "BAADF00D" data sequence. This is used in many cases to init memory, including, I believe, by XP to...more >>

We are running an SBS2000 network with around 40 clients being 60% Windows 2000 Pro and 40% WinXP Pro. We have around 3 member servers (not DC) and one of the servers is a SQL server running SQL 2000. A user on the domain has created a dBasev5.7 form that needs an ODBC System DSN connectio...more >>

Is there any trick to setting up a System DSN to connect to a SQL 6.5 = Sever that is in a different domain. The domains are trusted. I've = tried every type of authentication but my Win XP system just can't get a = DSN to connect again the SQL Server that is running Win NT4 SP6. Is = there a...more >>

Is it possible to update a SQL Server table from Excel? We have some Mac users who have Excel, and need to add data to some tables. -- Greg Stigers, MCSA remember to vote for the answers you like ...more >>

I'm getting the following error on my XP machine: The ODBC resource DLL c:\windows\system32\odbcint.dll is a different version than the ODBC setup dll c:\windows\system32\odbccp32.dll reinstall the ODBC components to ensure proper operation. I've reinstalled SQL 7.0 several times, how do I...more >>

I had to make some changes to SQL Server tables; not knowing about the Linked Table Manager, which I guess I should have used to refresh the connection, I instead deleted the connection to the table then re-established it. The minor annoyance here is that any time I query against the table, I...more >>

Hi Please help .... How execute such queries "-- ? " Dim con As New Connection con.Open "Provider=Sybase.ASEOLEDBProvider.2;Persist Security Info=True;Mode=ReadWrite;User ID=Savtchin;Data Source=SYBASE12;Initial Catalog=SWIFT;Pwd=98523" Dim com As New ADODB.Command com.ActiveConnectio...more >>

Hi I try to create SP from ADO. Open connection and excecute queries. con.Execute "SET QUOTED_IDENTIFIER OFF " con.Execute "SET ansinull ON" con.Execute TextProc TextProc content " create procedure BISSGetDllName ( @ID_MESS numeric(10) = 0, @SwiftOperType int = 0, @IsAc...more >>

I am using SQLServer 2000 on multiple Windows operating systems and the application accessing the database are also on multiple Windows OSs namely Windows 2000 server, Windows 2003 Server, Windows 2000 and Windows XP. The issue is only noticed when the database resides on windows 2003 box. The a...more >>

Hi, I am trying to speed up database operations of an application. The app is separated from the SQL Server database by a WAN and they talk through ODBC. Operations are as slow as cold molasses. Today I am looking at the option of enabling connection pooling. But from what I read, I am...more >>

Utilized FrontPage 2003 Database Wizard to create an online feedback form. The Submission form indicates that everything transferred smoothly to the database. BUT. When I ask to see the results online or edit the database content I receive the following error. Database Results Wizard Error T...more >>

Hello All, We have started getting error 18456 when an Access (happens on two different ones)accesses a SQL 2000 database. I read the knowledgebase articles and the do not apply and the fixes don't work. As always, we are using the domain (now AD) user login. Not sure when this broke, I ...more >>

Hi, please help me! I'm connecting to my database using... Database_ConnectionString = "Provider=Microsoft.JET.OLEDB.4.0;Data Source="&server.mappath("/db/db127/store.mdb") set con=Server.CreateObject("ADODB.Connection") con.open(Database_ConnectionString) I'm assuming this is corr...more >>

Hello all, Having problems connecting to an Oracle 9i database from within SQL/Server 2000 using the Security/Linked Servers feature. Server1 (SQL/Server) ----------- Windows Server 2003, Standard edition MS SQL/Server 2000 Oracle 9i Client kit (OLEDB & ODBC) & Enterprise manag...more >>

Hi, I am trying to restore a database from a different server to my server and also with a different name. But it gives me an error. ODBC-SQLState 42000 Device Activation Error. Does anyone know what this is ? Any help is appreciated. ...more >>

Hi I am having some trouble importing certain tables from an odbc database (Sage Line 50). Most of the tables import without any trouble whatsoever, however there are 2 tables (SOP_items and POP_items) that always crash dts when it tries to import them. The DTS screen simply dissappears from...more >>