|
|
|
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 |
Not getting database list while trying to chage default db. Posted by cmies at 4/29/2005 2:46:06 PM I need some help!
We're correcting some security things on our SQL server and now when I try
to establish an ODBC connection, I can no longer choose the default database
for the connection from the drop down list.
It has to be related to user rights we removed on the SQL Server, but I
ca...more >>
SQL Newbie needs help getting started with MSDE! Posted by Bowen T at 4/29/2005 12:34:05 PM Hi.
I am getting started using SQL. My primary objective is to be able to
write ANSI SQL statements at a high level, outside of a certain
platform. I am using the book SQL A Beginner's Guide by Forrest
Houlette.
To get started, I downloaded the Microsoft SQL Server 2000 Desktop
E...more >>
Named Instance not Displaying --- Only Server Name Posted by BJ Marks via SQLMonster.com at 4/29/2005 12:00:00 AM I have a Dell Latitude D505 running a fresh copy of XP SP2. I am trying to
create an ODBC System DSN to our SQL 2k server. The SQL Server has about 6
instances installed on it. When I pull down the drop down box to select a
server, only the server name exists, but none of the instances. This is
...more >>
MS Access Linked Tables under SQL 2005 x64? Posted by Ohio Tom at 4/25/2005 8:14:08 AM I am running the 64-bit x64 version April CTP SQL Server 2005 under Windows
2003 Server x64 Edition. I am trying to create a Linked Server to a
Microsoft Access database, it does not show the Microsoft.Jet.OLEDB.4.0 as
one of the available providers.
I can programatically create the link...more >>
Successful connection with invalid UserId Posted by rbkaimal NO[at]SPAM hotmail.com at 4/22/2005 2:52:33 AM Hi,
In my application , the connection to SQLServer is established
through a DSN name, UserId and Password(both UsrId and Password are
non empty) . The "SQLConnect" function is used for this purpose. The
problem is that the connection to the Database is success when I give
an empty UserId. ...more >>
Using Application Roles with an ODBC or OLE DB Connection. Posted by Peter Berton at 4/19/2005 12:42:02 PM Does anyone know of an ODBC or OLEDB driver that supports the use of
Application Roles?
I am looking for one so that the Application Role information could be
specified as part of the connection String and the calling app will not have
to make a separate call to set the application role.
...more >>
Help!!! [Microsoft][ODBC SQL Server Driver]Timeout expired Posted by Chan at 4/18/2005 5:54:01 PM Hi all...
Environment
OS : Windows 2000 Advanced Server(SP4)
SQL Server : Microsoft SQL Server 2000(SP3)
DB Accessing : MSDTC, ODBC, COM+(VC++) calling Stored Procedure through
firewall
i have four databases, each size are 8G, 400M, 18G, 500M
there is a firewall between COM+ Server and S...more >>
When does SQLPrepare validate table name Posted by CompWiz at 4/12/2005 1:08:39 PM In SQL2k if I call SQLPrepare with the following select statement:
SELECT * FROM sometable
where sometable doesnt exist, SQLPrepare doesnt return any error.
However I have had reports that this fails under SQL7. Should
SQLPrepare fail in this case? or is there some option that would need
t...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
ODBC 4,099 byte record limit?? Posted by Repo at 4/11/2005 12:14:41 PM I'm connecting to an Access DB through ODBC on a windows server from a PHP
page. The problem is the text retrieved from the select (nfo) is truncated
at
4,099 bytes everytime.
How to I get around this 4k limit?
I read about SET TEXTSIZE but I don't know how to use it in the script?
The fu...more >>
sql lost conection Posted by CONCEPCION DIAZ ALONSO at 4/10/2005 3:29:42 PM
I have one sql server that runs one aplication that i use in my lan, it
had been running well, but from a few days its having error 80004005
conection lost whith named pipes and tcpip, i run this server for two
places conected by a wireless lan in the one is local doesnt give any
error but...more >>
Wrong SQLSTATE for Native Error 2727 Posted by Aleksey Dmitriyev at 4/8/2005 2:39:03 PM I get SQLSTATE 42S21 with native code 2727 when executing this query:
alter index index_junk on testauto rebuild
According to ODBC documentation the SQLSTATE should be 42S12 "Index not
found", not 42S21 "Column already exists". Is it a bug?
--
-- Aleksey Dmitriyev...more >>
How to improve CPU Time Posted by vijay at 4/7/2005 5:42:36 PM Platform: Win2000, VC7, MFC, ODBC
Hi,
I have developed a server application which runs 24x7. Backend database is
SQL Server. Application inserts data in the SQL Server database using ODBC
connection. Let Application runs on machine (M1) and SQL Server is running
on machine (M2). After 1...more >>
LInk Tables Posted by MMouse99 at 4/7/2005 12:23:02 AM Hi,
I have created a link server within my enterprise. I can see the
server - which is on a c-isam db - and all the the tables.
What I am unable to do is query any of the tables.
Link Server = Rubicon
Table Name = qc_raw_mat_cat.
select * from rubicon..qc_raw_mat_cat
What have I m...more >>
"Linked Table" from a .txt file in SQL Server? Posted by Joel at 4/6/2005 4:05:04 PM OKay, I'm really, really good with MS Access, but am just getting up to speed
on SQL Server. Is there a SQL Server equivalent of linking (not importing) a
table from a .txt file?
Thanks!...more >>
How do I connect to a DSN in SQL? Posted by Mark - HIS at 4/6/2005 3:59:06 AM I have a query to pull data from my MSSQL database, howver I need to use the
INSERT INTO statement to insert the results into a Sybase SQL Database on a
different Server to the one the MSSQL database is on.
I have set up the Sybase SQL Database as a DSN in the ODBC Administrator,
but how do I...more >>
Timeout Expired Posted by Dave Pylatuk at 4/5/2005 5:53:02 AM Hello all.
I have a table in SQL Server 2000 with 3.5 million rows in it, approximately
20 columns. I am querying this table via ODBC using the microsoft driver.
Certain
queries fail and return a 'Timeout Expired' message. I have a non-unique index
on the column I am referencing in my WHERE...more >>
SQL SERVER LINK PROBLEM Posted by Savas Ates at 4/2/2005 4:56:19 PM my sql server is not in local network.. it is in remote network... and its
ip , username and password is true...
coz i can access it from enterprise manager from my local sql server...
i looked at my permissions.. from users in my database ...
in my dbo public and db_owner permit checked......more >>
LINK SQL SERVER DATABASE FROM ACCESS Posted by Savas Ates at 4/1/2005 7:57:36 PM i tried link to sql server db from access and i failed.... (What is my
fault.. I think It doenst ask me catalog -database name so it doesnt accept
my username and password..It cant find my username and password which
database has it ..)
i follewed these steps...
1.right click and link ta...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |