all groups > sql server odbc > june 2007
ODBC Data Source Administrator
Posted by thePriest at 6/29/2007 2:13:02 AM
Hi all, hope you can help?
I have created a system DSN in the usual way using the above ODBC tool
(I am trying to create a connection to our Open Accounts package using
the OpenEdge 10.1A driver). I provide the host name, the port number
and the database name, the user ID and password and tes... more >>
Problem with decimal scale using SQLBindParameter and SQL_C_NUMERIC
Posted by Mark Yudkin at 6/24/2007 12:00:00 AM
SQL Server 2005 SP2
I am trying to pass in native decimals with non-zero scale as parameters
using SQL_NUMERIC_STRUCT. Retrieving decimals works fine (SQLGetStmtAttr,
then SQLSetDescRec) (cf KB222831).
I tried calling SQLBindParameter giving the scale in DecimalDigits. The
value is passe... more >>
Invalid identifier/column names after Upsize Access data to SQL Se
Posted by didub at 6/22/2007 7:54:04 AM
I have been asked to maintain an Access 2000 database which is a code front
end linked by ODBC to a SQL Server 2005 back end. (Originally the data was
in an Access database but was later moved to SQL Server 2005 by the Upsizing
tools.)
Some tables have column names which do not conform to ... more >>
Chart lists different builds of SQL Server and MDAC needed
Posted by Peter at 6/19/2007 7:31:35 PM
I want to find out which build of MDAC is required by different build of SQL
Server 2000 and 2005.
Also, are all the keywords listed in the link below supported by all the
MDAC used for SQL Server 2000 and 2005? Are the acceptable values for the
keywords same for both 32bit and 64bit drive... more >>
sql server connections
Posted by Wendy Elizabeth at 6/17/2007 9:00:01 PM
I would like to know how to automate the following two processes with excel:
1. I would like to take data that is obtained from sql server 2000 queries
results and load the detail data onto excel spreadsheets.
2. I would also like to take data that is obtained from sql server 2000
query re... more >>
Suppressing ODBC pop up error
Posted by at 6/16/2007 4:05:21 AM
Hi there,
I have a client-server application that periodically connects to an
Access database on a network. My netowrk sometimes goes down and there
is an ODBC failure to connect. This results in an ODBC error pop up
window. I am interested in suppressing this pop up, catching the
exception a... more >>
Distrubuting ODBC DSN record to domain computers
Posted by volkans80 NO[at]SPAM gmail.com at 6/9/2007 3:54:56 AM
How Can i distrubute my ODBC DSN record to my domain computers?
... more >>
SQL server database access from VC++
Posted by Manjree Garg at 6/6/2007 2:33:00 AM
Hi
I am new to SQL server and ODBC. I am trying to retrieve SQL server database
using VC++ (using VS.net). I am using SQLConnect to connect to the SQL
server. My code contains
SQLAllocEnv(&henv);
SQLAllocConnect(henv,&hdbc);
rc=SQLConnect(hdbc,chr_ds_name,SQL_NTS,NULL,0,NULL,0);... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
|