|
|
|
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 |
Access queries using up space on server's C: drive Posted by Andy S. at 9/29/2005 4:48:20 PM I have users who are running large SELECT type queries in Access against
a SQL Server via ODBC. What happens is that the c:\documents and
settings\<username>\Local Settings\Temp on the SQL server itself gets filled
until the drive starts running low on space. Other than to free up space ...more >>
ODBC Connection Posted by Yifei at 9/29/2005 12:16:09 PM Hi, All,
I got problem with ODBC connection, I have a product server and a stage
server, I made a sysdsn called SQLDSN, create a com+ called login and just a
very simply statement: list below:
private oconn as new adodb.connection
Public Function vPWD() As Boolean
Dim lngID As Long
...more >>
PHP and Navision C/ODBC Posted by Jasperinho at 9/29/2005 11:16:40 AM Hello! I have a problem trying to access with PHP to a Navision Database
(actually the demo Navision database).
I have created the system DSN, named "NavisionSystem", with the Navision
ODBC driver, in a Windows 2003 server, with Apache 1.3 and PHP 5.0.2
My call to the database (local) is:
...more >>
Newbie Database Diagraming Error Problem Posted by Don at 9/24/2005 10:42:12 AM
I am in the process of taking my first stab at a MS SQL Server based DB.
The original DB was in MS Access and had a front end DB with the GUI and a
back end with the data. The data has been successfully transferred to the
SQL Server. Now I am in the process of re-building the relationships...more >>
Connecting to SQL from Within VFP Posted by Preacher Man at 9/23/2005 4:36:03 PM In this post I am going to try to simply a question that I posted earlier.
Can I use VFP to access a SQL Database? If so what is the command?
What is the best software for creating applications to work with SQL?
I am just getting my feet wet with SQL so please take it easy on a rookie.
...more >>
NEED VERY BASIC HELP Posted by Preacher Man at 9/23/2005 1:37:38 PM At my workplace our ERP software in on a VFP database. I have learned quite
a bit about extracting data with the select statements from the VFP
database. We are in the talks of converting the the SQL version of our ERP
and I have some very basic questions since I am extremely new to the SQL ...more >>
Select qry is not working properly Posted by K R Lal at 9/23/2005 1:07:30 PM Hello,
I am writing an sql qry for cursor function. the Select qry is not working
properly. please check this and help me
declare @m as varchar(20)
declare @mm as varchar(400)
set @m='r-01,r-002'
set @m=char(39)+replace(@m,',',char(39)+', '+char(39))+char(39)
select @m
set @mm ='select ...more >>
Maximum Databases in ODBC Posted by Rowland Costin at 9/23/2005 12:00:00 AM What is the maximum number of Databases you can have connections to using
ODBC connection to SQL? I am talking hear about the entries in ODBC Data
Sources as System DSN's.
Anyone got any ideas? Assume Windows XP SP2 workstation and Windows 20003
server with MS SQL 2000 SP4.
In fact is t...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
ODBC drivers Posted by news.infonet.ee at 9/23/2005 12:00:00 AM After I installated Service Pack 4 on SQL 2000, suddenly all my ODBC
drivers
dissapered.
How I can get them back?
...more >>
Linkedserver , Navision C/ODBC, Null columns Error Posted by Ricardo Meechan at 9/21/2005 10:05:57 PM hello
i am having a few problems with Linkedserver and Navision Financials.
Most of the tables in navision (Customer, Prospect, Sales Line etc) have
DateTime columns that may contain nothing (null).
if i try to select these records i will get an error but i need access to
these columns s...more >>
Security Posted by Rick at 9/21/2005 11:04:00 AM Suppose I have an appliation made in VB6 which connects to SQL2000.
The applications creates a DSN(old style) to connecto to the server.
The user has a login an a password to use the application. The server
validades Windows NT login.
Every effort had been made to protect the database from in...more >>
[SQL Server]Transaction (Process ID 52) was deadlocked Posted by Sudhanshu at 9/21/2005 12:06:02 AM I am using SQL Server 2000 and running number of query simulatneously. While
running update query it is always giving above error. The error discriptions
are -
1. [SQL Server]Transaction (Process ID 52) was deadlocked on {lock}
resources with another process and has been chosen as the deadl...more >>
Optimize Linked Server to Oracle Posted by David J. Cartwright at 9/19/2005 12:00:00 AM I have a linked server to Oracle (I have one using MS and one Using Oracle
Driver), both take about 20+mins to return 114k rows using OPENQUERY, is
there any way to speed this up, and why does oracle always ruin my day ?
- David
...more >>
ODBC Driver for Linux Posted by Steve Kitley at 9/16/2005 5:16:56 PM Hello,
We have an instance of oracle on linux and another with sqlserver on
windows.
We need an odbc driver for the linux box to connect to the sql server.
Does anybody have suggestions on what odbc drivers there are out there for
linux in order for us to connect these two boxes?
Tha...more >>
Accessing database through CRecordset Posted by Ashish choudhari at 9/16/2005 3:52:11 AM Hi,
In my VC++ 6.0 application, I have a database with 3 different
tables say Client,Task, and Algorithm. I want to access this three
tables through CRecordset. As far as i know i need to derive three
different classes for each table, from CRecordset. Can anyone please
help me so that by ...more >>
Binary or Byte data linked to Checkbox Posted by Max Yaffe at 9/15/2005 10:37:37 AM Dear Group,
I'm using Access 2003 linked to an SQL Server data table via an ODBC
connection.
On one form I have several check boxes which want data mapped to a
TRUE/FALSE datatype. Is there a direct way to bind a checkbox to a
bit, a binary, or a tinyint? I've only been able to get it to ...more >>
Server side ASP, Client side JavaScript and MS SQL Posted by Charles E Finkenbiner at 9/14/2005 8:01:22 PM Hi All,
If this is not the correct group for my question please point me in the
right direction.
I am using server side VBScript to connect to an MSSQL database, on the
Internet, extract values and serve them up in text, drop downs, etc...
controls via a web page. So far this seems to w...more >>
How to use ODBC to find a record by key in a larger result set Posted by BobMTenn at 9/14/2005 8:34:08 AM I'm using SQL32.INC,SQLEXT32.INC etc for the first time. I have some code
working fine in a report style program and it's very fast. In Maintenance
programs, I need to find a specific record and/or scroll from there. I can
get the scrolling next and prior working ok and I can get the calling u...more >>
ODBC: Driver's SQLSetConnectAttr failed? Posted by Jerome at 9/14/2005 12:00:00 AM Hi,
I've got a very weird ODBC problem and the log file mentions this: DIAG
[IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr
failed (0)
The situation is the following:
* I've got several Windows 2000 and Windows XP PCs. Each PC has Access
2003, some also Access 2000...more >>
Microsoft Drivers for Accessing data from Unix. Posted by MZeeshan at 9/13/2005 10:26:01 AM Are there any microsoft provided ODBC drivers that can be installed on Unix
side for accessing SQL Server data? OR they are only available from third
party.
--
Regards,
MZeeshan...more >>
ODBC driver for SQL server using mfc Posted by Bhavin Patel at 9/13/2005 12:18:07 AM Hi,
I am currently using ORACLE 9i but I am trying to move to SQL server.
Below is my code, I am getting very strenge error, I can retrieve all the
data from database, but when I do .Edit(), the code crashes. Eventhough, I
am opening the recordset dynaset, it still does not let me edit the
...more >>
Does anyone have example of opening SQL Server with ODBC using MFC Posted by Bhavin Patel at 9/13/2005 12:13:42 AM
...more >>
Retrieving ODBC Settings. Posted by Billr17 at 9/12/2005 5:22:01 PM I'm having some issues grabbing ODBC Settings. First off I need to
present a user with the options to select thier DSN, Server, UID, PWD, and
Database settings. I have come up with a way using the SQLBrowseConnect
function to obtain the Server and Database information I need. Therefore, I ...more >>
Problem with 64-bit ODBC code and SQLConnect and SQLWCHAR Posted by Nick Palmer at 9/9/2005 4:51:42 PM Hi all,
I'm trying to test some 64-bit ODBC stuff and I'm running into a slight
problem. First, my configuration.
Windows XP x64
VS.Net 2005 Beta 2
SQL Server 2005 CTP
So, I have built and tested other 64 bit apps so I know that things are all
working, but now I'm trying to test ODBC a...more >>
mssql & msaccess .mdb file with database password Posted by paul a at 9/9/2005 2:49:45 AM
i get daily updated .mdb file from another office.
i have mssql as b/e and msaccess as f/e.
the .mdb file i get daily has a database password,
and i am looking for ways to access the .mdb file through my sql server.
(i want to upload the file to the sql server not having to remove the
passw...more >>
Microsoft OLE DB Provider for ODBC Drivers Posted by jeff.jones NO[at]SPAM papermagic.com at 9/8/2005 11:27:27 AM I am using an system ODBC created to access data on an AS/400.
I can access the data fine, using the following query.
SELECT F0101.* FROM CRPDTA.PILGRIM.CRPDTA.F0101 as F0101
where the first CRPDTA is the DSN name, PILGRIM is the AS/400 catalog,
the second CRPDTA is the SCHEMA, and F0101 is ...more >>
Asking again - ResultSet.getString() & unicode Posted by David Thielen at 9/7/2005 11:26:06 AM Hi;
I have put a sample program, output, DB contents, etc. at
http://www.windward.net/jdbc_unicode.zip
When I call ResultSet.getString() it returns the ? char for any unicode
character that does not map to ASCII 0 - 127.
Yet when I access it with hibernate, which appears to do the exact...more >>
Err Msg: String data, right truncation Posted by Yoke Heng at 9/6/2005 10:14:02 PM Fieldname: Description - varchar(100)
I tried to insert a record together with the above field - Description - in
Chinese characters. Once I enter the Chinese characters more than 50
characters, the err msg promt out : "[ODBC SQL Server Driver]String data,
right truncation".
I have tried to ...more >>
JDBC - Can't get unicode with ResultSet.getString() Posted by David Thielen at 9/2/2005 12:40:04 PM Hi;
I am using MS Sql Server and it has an nvarchar field holding a name.
For ascii chars I get back the text in the database.
But if it is anything other than ascii, I get back a ? for each non 7-bit
character. So a field with "a風bбc" returns "a?b?c"
What do I need to set/do to get...more >>
Access connection to SQL shows as system account in SQL Monitor Posted by mbg at 9/1/2005 4:41:02 PM SQL Server 2000 SP3 on Windows Server 2000 latest service pack
Workstations XP sp2 with Office 2003
SQL ODBC driver 2000.85.1117.00
System DSN's using NT Authentication used with Access.
As of the date of the last OS server patch, users logging in to several
Access database linking tables f...more >>
TCP/IP Sockets General Network Error Posted by HSP at 9/1/2005 7:22:02 AM Getting the TCP/IP Socket General Network Error when trying to connect to an
SQL 2000 database using Access 2002 as a front-end.
Access application hangs and then presents the user with this error.
Verified that ODBC is setup correctly.
Machine can successfully ping SQL Server. by name and IP A...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |