|
|
|
June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 |
Filter by week: 1 2 3 4 5 SQL Error Message Posted by Jessie Burchfield at 4/21/2004 11:25:54 AM I am getting the following error message when trying to
connect to a existing database.
The LSN (459:410:1) passed to log scan in
database 'I2000_52' is invalid.
The I2000_52 is the database I am trying to connect to
using a ODBC connection.
Can you help me please?
Thanks
...more >>
data migration Posted by whitegoose NO[at]SPAM inorbit.com at 4/20/2004 7:12:13 PM Hi all.
I need to to a lot of data migration from excel spreadsheets, access
databases, and SQL Server databases into a SQL Server database.
In the past I would have achieved this using a combination of linked
servers and ad hoc connections using opendatasource(). However my new
site is hav...more >>
sysprocesses displays wrong Network Address Posted by Len Cardinal at 4/20/2004 2:58:12 PM In SQL EM's Current Activitiy window, the Network Address of TCP/IP
connections shows the wrong MAC address for client machines.
The MAC shown is often one for a different ethernet port than the one that
SQL traffic is going over.
Any idea on why this is happening? Machines are multi-homed....more >>
Linked server against DB2 using DirectLink driver. Posted by Kjell Nilsen at 4/19/2004 9:12:41 PM Hi,
does anyone know if the DataDirect Connect driver for DB2 driver support
four-part-names?
I'm testing this driver and have been able to set up a linked server and
query the database using the openquery syntax, but when I use syntax with
four-part-names or try to view the db2 tables in E...more >>
ODBC in MS Access ignores DSN authorization method Posted by tina NO[at]SPAM interland.com at 4/19/2004 1:15:16 PM I have found info on this problem at MS, but they say this problem
does not occur with SQL 2K and MDAC 2.6 SP2, yet I am still
experiencing it:
I have a SQL user specifically created to SELECT on 5 tables in one
database. I have created an ODBC file DSN using that login/password. I
create an ...more >>
connecting ODBC form dos mode Posted by msr at 4/18/2004 4:32:33 PM hi,
some one help me, i am trying to connect DATABASE on local
machine from DOS mode ..is it possible..if so how....more >>
access-SQL ODBC link Posted by JIM.H. at 4/17/2004 1:34:26 PM > Hello,
> I am using trusted windows user connection to SQL
server.
> I created an ODBC link from Access to SQL server. I am
> able to modify data in tables through SQL Enterprise
> Manager however I am not able to modify them in Access.
> What is missing?
...more >>
Can not registre SQL in Enterprise Manager Posted by Charles at 4/17/2004 12:20:44 PM Hello,
I try to register a remote SQL Server 2000 installed in a W2003, but it
doesn't work. Afer about 5 or 6 seconds, it says: Timeout expired.
In that network , there is not any firewall and port 1433 is open in the
router. What it really surpises me, is that
I can connect via ODBC to a...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
ODBC Version with MDAC 2.8? Posted by John Smith at 4/16/2004 6:40:42 PM I am unable to determine what version of Microsoft's SQL Server ODBC
driver comes with MDAC 2.8.
Currently I'm using driver "SQL SERVER" SQLSRV32.DLL, 10/27/2003,
version 2000.81.9042.00 (with Windows 2000, SQL Server 2000, Access XP)
and I only want to upgrade to MDAC 2.8 if it updates thi...more >>
Connection Problems to SQL 6.5 Posted by Mansoor Azam at 4/16/2004 5:13:57 PM We connect to a SQL 6.5 server (IP for example 202.64.213.11) on WIN NT
using ODBC DSN and / or SQL Client (DB-LIB). Everthing was working fine then
the some XP client machines (192.168.0.1 and 192.168.0.3) started giving
problems. All TCP/IP connections go thru the WIN 2000 multihomed machine
...more >>
ODBC Connection to SQL Server Posted by Mark Kovach at 4/16/2004 7:52:32 AM I am setting up SQL Server ODBC connections on 5 machines
and everything has gone fine until I came to the last
machine.
When I go to choose the server I want to connect to from
the server drop down list, it isn't there. There other
machines listed, but not the one that I want.
The ...more >>
ODBC Error - Connection Broken Posted by Ron Hinds at 4/15/2004 5:20:21 PM I get the following error (from my front-end Access app AND Query Analyzer)
when accessing a particular table. It is a rather large table, ~1,750,000
rows in it. I tried looking through "limitations" in BOL and couldn't find
anything. Is this a server setting or ODBC setting or... ?
[Microsoft...more >>
ODBC Error Posted by Ron Hinds at 4/15/2004 5:03:47 PM I get the following error (from my front-end Access app AND Query Analyzer)
when accessing a particular table. It is a rather large table, ~1,750,000
rows in it. I tried looking through "limitations" in BOL and couldn't find
anything. Is this a server setting or ODBC setting or... ?
[Microsoft...more >>
Linked Server Access Posted by Joe LeBaron at 4/15/2004 8:45:19 AM I create a linked server to an Access database with T-SQL is a stored
procedure.
Does anyone know how to create a table in the Access database within the
stored procedure?
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |