|
|
|
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 |
Decimal Formatting Posted by Jonathan at 5/31/2007 1:55:00 AM Hi Group,
This is my probelm, I have a SQL view which holds prices to 2 decimal place
in the Management Console they are displayed to two decimal place i.e. 1.99.
However when I run an ODBC report the values are all to mutiple decimal
places i.e. 1.9900000000000000000. I have been told th...more >>
ODBC connect string for named instance? Posted by Richard M. Hartman at 5/25/2007 10:08:55 AM
I am familiar with constructing ODBC connect strings for SQL server
databases using "SERVER=" and "Database=" clauses. If the SQL server is
running a named instance, instead of an unnamed one, do you put the instance
name in the "SERVER=" clause, or is there another clause for that?
--
...more >>
SQL Linked server to MS Access DB on remote PC Posted by Kevinst at 5/24/2007 7:50:02 AM Hello,
I'm trying to create a linked sever from SQL 2000 to an Access 2000 database
on a remote PC with the following command:
EXEC sp_addlinkedserver
@server = 'MyEventLogging',
@provider = 'Microsoft.Jet.OLEDB.4.0',
@srvproduct = 'OLE DB Provider for Jet',
@datasrc = '\\172.29.61...more >>
Single row query slower than multirow query Posted by clintonb at 5/21/2007 3:17:44 PM I have an application written in Powersoft Power++ that uses ODBC to
connect to a sql server database.
The program has a search screen that generates an SQL statement like
this:
SELECT
Parcel.ParcelID, Parcel.TaxYear, UserDefinedID, UserDefinedID2,
NamePrefix, FirstName, MiddleName, La...more >>
Linking access tables to SQL Posted by Kevinst at 5/21/2007 9:37:01 AM Hello,
I'm familiar with using linked tables in MS Access to access SQL data, but
can I do the reverse? Use SQL to access/query an Access 2003 database via a
linked table in on the SQL server? Reasong being I'd like to utilize a SQL
sproc against the access database and I am unable to mak...more >>
ODBC error 3151 (Connection failed, Access <-> SQL Server) Posted by StephanG at 5/16/2007 11:51:00 AM Hi,
We are using SQL Server and Access for a database application. Database
access is via ODBC.
The application was functioning correctly since appr. 2 years - but suddenly
we get the >>error 3151 "ODBC--connection to <...> failed"<<
This error is only raised by one function in VBA (whe...more >>
exception in in connection with SQL server Posted by tomar at 5/14/2007 11:03:36 PM Hi all,
I am using OdbcConnection for coonectivity with SQL Server db. My code
is working fine with windows application but in ASP.NET or in
webservice its raising following exception -
"ERROR [08001] [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL
Server does not exist or access denied.
E...more >>
SQL ODBC Connection Error Posted by TomLin19 at 5/11/2007 8:25:01 AM Good Morning Everyone,
I recently re-compiled a SQL database-reading program with Intel Visual
Fortran. The program seems working fine when I tried to read data in a 64-bit
server from my PC. But when I moved the executable to the server and tried to
read the same data from the server (now ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Importing ISAM data into SQLServer Posted by barthome1 NO[at]SPAM comcast.net at 5/8/2007 2:16:17 PM Hello,
My company has some old ISAM datasets we need to resuscitate. We
would like to import the data into SQLServer. It looks like there are
some ISAM ODBC drivers available, but I was wondering how well it
works.
There would seem to be a step where you have to specify how the input
rec...more >>
What is the sa password after changing the Server Authenication Posted by Jodie at 5/4/2007 11:03:01 AM Hi All,
I changed the Server Authentication from Windows Authentication mode to SQL
Server and Window Authentication Mode and I don't know what is the password
for login as sa. How to find out what is the sa's password in this case.
Thanks,
JP...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |