|
|
|
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 ODBC driver for MySQL Posted by Cary Lewis at 1/28/2004 4:10:37 PM Hello,
I have a MySQL database residing on a Linux box and a MS
SQL Server residing on a Win 2000 box. I have installed
a MySQL ODBC driver that works fine with ACCESS, however
when I try to use that same Driver in SQL Server (as a
Linked server), I get errors.
For example, in Query A...more >>
Help Please trying to convert an access 2000 DB to SQL Server Posted by Yeric at 1/28/2004 3:37:11 PM Hi,
I am currently transfering a db from Access 2000 to SQL server 2000 (
Developer Edition)
I used the import feature and this seems to have worked ok, but having a
problem with a couple of queries
I am connecting using ODBC and RDO from a vb program, and passing this query
to the serve...more >>
Is password case sensitive on SQL Server? Posted by Bing Du at 1/28/2004 2:21:09 PM When I configured the System DSN, seems no matter what case I entered the password in, they all worked. Does that mean, password is not case sensitive on SQL Server?
Bing...more >>
FYI: SQL Reporting Services download is available!!!!!! Posted by Andy Svendsen at 1/28/2004 11:41:16 AM http://www.microsoft.com/sql/reporting/productinfo/trial.asp
If you have a SQL 2000 license, you can use the software. I don't work for
Microsoft, but I am excited enough to see this that I wanted to send out the
link. I have been waiting a long time to move beyond the limits of
Infomaker or...more >>
Problem accessing individual recordset fields in a Sql Server 7 view via ASP Posted by darren.smith NO[at]SPAM ca.trader.com at 1/28/2004 10:50:26 AM I am having a great deal of difficulty accessing individual fields
generated from a Sql Server 7 view.
When I specify the actual field name, I get the error:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]The column prefix
'inventory_h...more >>
ODBC fail via cross-cable Posted by Edward Hui at 1/27/2004 6:04:09 PM Hi all,
I have 2 PC. One of them install SQL Server2000 and the other one acts as
client. Currently, these 2 PC have connected to company network and I can
connect from client PC to server via ODBC.
One day, I connected 2 PC via cross-cable. Then I cannot connect to the
server anymor...more >>
error '80004005' [Shared Memory] ConnectionWrite(WrapperWrite()) Posted by Ricardo Cairello at 1/27/2004 11:39:50 AM I´m randomly getting the following error in my development environment:
error '80004005' [Microsoft][ODBC SQL Server Driver][Shared
Memory]ConnectionWrite(WrapperWrite()
My platform is: Windows 2000 Server SP4 + SQL Server 2000
I´m developing a 3-tier system, using IIS 5 and VB6-...more >>
Access app to SQL Server - Login failed for user '(null)'. Reason: Not associated... Posted by JRE at 1/26/2004 9:29:31 AM I have an Access 2000 application that connects to a mixed mode SQL Server
2000 database. I connect via a SQL autentication DSN and a co-developer
connects via a Windows autentication DSN. We both connected fine until my
co-developer copied the Access application to make changes. Now it seems
th...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
ODBC error code 126 Posted by Mark Newland at 1/26/2004 7:20:48 AM I get this error when setting up the ODBC connection: the
setup routines for the SQL server ODBC driver could not be
loaded due to system error code 126...more >>
SQL connection forcing login for each table Posted by gholtz NO[at]SPAM dslextreme.com at 1/25/2004 12:35:31 PM Does anyone know how to ensure a persistent login??
I have a MS Access application utilizing a SQL 6.5
database. I've created the odbc driver and have
successfully connected using MSQuery from a desktop
running MS 98.
However, each time the Access application connects, I'm
forced to log...more >>
Repost of VB Run-time error '3211' Posted by Tony Girgenti at 1/25/2004 8:31:11 AM I'm reposting this because i tried deleteing the table manually and
recreating it manually. It works OK after that, but when i try it again, it
gives the error again. There are four tables, but it only happens on the
"ITEMS" table.
I'm trying to execute the following code and i am getting th...more >>
How can I check if table already exists in a DB? Posted by GTi at 1/24/2004 12:44:51 PM How can I check if table already exists in a DB?
Today I just create my table at startup, if it exist I get a error telling
me that the table already exist, ignoring the error message.
But this is a dirty way of doing it. Any other idea.
It must be quick and clean.
...more >>
How to save Excel spreadsheet in SQL Database Posted by ddg1950 at 1/23/2004 12:31:43 PM I need to understand how I can save an excel spreadsheet in the SQL 7.0 db.
Am I trying to save the XLS file or just a link to it?? I have a VB6 front
end to the SQL database.
Thanks
...more >>
SQL SP expects parameter which is supplied. Posted by mark_wilson74 NO[at]SPAM hotmail.com at 1/23/2004 9:01:43 AM We have an application which suddenly broke, I am trying to find out
if anyone updated MDAC or similar on the box but don't know yet.
When certain stored procedures are called I get an error OLE DB
provider for ODBC expects parameter xxx which was not supplied.
This only just started happeni...more >>
Account lock outs Posted by Marcus at 1/23/2004 12:46:25 AM I have 50 users connecting to SQL server via ODBC using
TCP/IP to connect. But 2 of the users accounts keep on
having their windows accounts locked out.
Any suggestions?...more >>
Time out error on sql update Posted by tmeadows NO[at]SPAM arizonatc.com at 1/22/2004 10:49:06 AM I'm creating a DTS package that i can schedule to run everynight.
i'm using activeX vbscript to check expiration date on all the
customers in a database if the they have expired to change them member
circle status. I keep getting a time out error on the first update. I
have no idea why. can some...more >>
odbc call to sql 7 fails Posted by Janet at 1/22/2004 8:28:47 AM Have 3 XP machines running Office XP Pro. The odbc file
dsn sits in same file as the mdb on a server (on purpose
so it gets backed up regularly). The odbc file connects
to an SQL 7 database on an NT4 machine. All sql driver
versions are 2000.81.9042.00 The authentication is an
sql acco...more >>
I understand Why can't BCP .. Posted by Hydren at 1/22/2004 2:13:59 AM Hello..
I use command BCP rceiving the following error :
(SQLState = S1000, Native Error = 0
Error = [Microsoft][ODBC SQL Server Driver]ODBCBCP/Driver
version mismatch)
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |