|
|
|
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 |
Data source name not found Posted by Scott at 2/28/2007 9:32:05 AM Hello, I am trying to retrieve data from an Informix UniData database to SQL
Server. I am doing all the setup and work from the SQL Server. I have
created the package in SSIS and the Connection Manager item (which is setup
as a System DSN on the server) tests ok when manually tested. Howeve...more >>
[Microsoft][ODBC SQL Server Driver] error Posted by Kolos at 2/28/2007 1:52:09 AM Hi All,
A strange thing has been happening for a month or so when I retrive data via
QA. Sometimes the queries fail to run and I receive the following error
messages.
[Microsoft][ODBC SQL Server Driver]Protocol error in TDS stream
[Microsoft][ODBC SQL Server Driver]TDS buffer length too...more >>
Oracle10 ODBC connection Posted by HelpInRS at 2/27/2007 6:07:02 PM I have a windows 2003 server with sql server 2000
I run daily jobs that delete contents of sql tables an insert data from an
oracle9 database using
SELECT
*
INTO
DBname
FROM
OPENROWSET
(
'MSDASQL',
'DSN=ODBCOracleAccount;UID=oracleuser;PWD=password;',
'SELECT
...more >>
OpenDataSource() Posted by Mark T at 2/27/2007 1:18:23 PM Hello, I am trying to connect to a JBase database via an Attunity Connect
ODBC machine DSN but I'm struggling with the syntax. The DSN is called
ClarityODBC and this is the syntax I'm using:
SELECT *
FROM OPENdatasource('SQLOLEDB','dsn=ClarityODBC;').CLARITY.[PUBLIC].[TRANS]
I get the fo...more >>
Problem with default schema Posted by Michael Bruegmann at 2/27/2007 12:00:00 AM Hi,
under SQL Server 2005 I greatet a user with:
USE MYDB
CREATE USER TEST FOR LOGIN TEST WITH DEFAULT_SCHEMA = TEST
ALTER LOGIN TEST WITH DEFAULT_DATABASE =MYDB
and schema:
CREATE SCHEMA TEST AUTHORIZATION TEST;
Connecting to the database using SQL Native Client (20...more >>
Data Download via ODBC Posted by Brian at 2/26/2007 4:23:15 PM Server is SQL 2000 SP4. We are trying to pull some data from a Progress 9.1d
server via ODBC. If I go to the local packages, open the package in question
and execute it, everything runs fine and it gets the data. If I try and run
the job manually from the job list in the SQL server agent, it f...more >>
ODBC error Posted by Ram at 2/17/2007 8:59:08 PM Dear all,
We are using Ipswitch email application “ICS 2006’ with SQL 2000
enterprise edition as database. Occasionally web mail users are facing the
below
error on their web page.
‘ERROR [HY001][Microsoft][ODBC Microsoft Access Driver] Not enough space on
temporary disk. ER...more >>
Creating System DSN on Vista Box Posted by mlimaye NO[at]SPAM gmail.com at 2/16/2007 2:55:28 AM We are trying to create System DSN on vista using the API
SQLConfigDataSource(...) it give error Access denied.
Can any one help? This is going very critical every hour.
Thanks in anticipation,
Cheers,
Madhav
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Will pay for need help and occasional advise on using excel Posted by Jerry in Oklahoma at 2/16/2007 12:00:00 AM
Will pay for need help and occasional advise on using excel
database
" sorry if this is off post ...will be my last"
Thx in advance for your help and interest.
i am an independant oil and gas consultant and have a fair
amount of computer experience but, am absolutely lost w...more >>
ODBC driver for W95 Posted by SteveR at 2/14/2007 3:28:10 AM We have a lot of W95 clients that can't be upgraded. I want to use SQL CLR so
I need to use SQL 2005. Is there an ODBC driver for W95? I've tried MDAC 2.8
but without success (installation fails on W95).
--
Steve...more >>
Can't Find SQL Native Client in ODBC Connection Manager Posted by Jim Strickland at 2/13/2007 10:31:01 AM I am running Windows XP Pro SP2. I have installed the SQL Native Client for
XP. However, when I try to add a new data source through ODBC Connection
Manager, SQL Native Client is not listed as an option. I have followed this
procedure on three other systems with no problems. What would be caus...more >>
MS SQL and MSDE Posted by Tom Parke at 2/8/2007 8:14:04 AM I need to develope a c++ application that connects to a MS SQL 2000 server,
soon to be 2005, via OBDC. I want to develope the app on my workstation
which rarely connects to the server. Can I use MSDE as a development engine
and all the ODBC will be the same for the SQL server?
Tom...more >>
how to link Access with a .mdf file? Posted by ben at 2/1/2007 11:00:47 AM Hi,
i want to import data from a stand-alone .mdf file.
I use sqlserver express 2005 (windows xp prof).
In sqlserver, i attachted the .mdf file.
Then I created an odbc link, but when i try to import data from Access, i
only see the master database, not the tables of the .mdf file.
How c...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |