all groups > sql server odbc > august 2004 > threads for august 22 - 28, 2004
Filter by week: 1 2 3 4 5
Connection to ODBC without a DSN
Posted by Tony at 8/27/2004 3:53:47 PM
Is it possible to connect to an ODBC driver (e.g. SQL Server or Oracle)
directly without having to create a DSN before hand.
This would be great as dumb users can't handle creating a DSN.
Would be nice if I could ask them SQL Server or Oracle, server name, user
name and password only and progr... more >>
String data, right truncation
Posted by Leon McCalla at 8/27/2004 11:54:15 AM
after executing a Stored procedure that returns about 10 strings I get a
"String data, right truncation" error in ODBC. how do I know which string
was too long?
Leon
... more >>
Compatibility of ODBC 2000 vs ODBC 2003
Posted by chanjo at 8/27/2004 11:22:15 AM
Will there be a compatibility issue between my client ODBC
version 2000.80.194 and the SQL server 2003.... more >>
Mainframe file import
Posted by AlexB at 8/25/2004 6:01:01 PM
I am hoping to import a file exported from mainframe (packed decimal) into a
SQL Server database. Is it possible and if so, what is the best way to
accomplish this?
Thanks in advance.... more >>
Nested Transaction between ADO.NET and T-SQL
Posted by SK at 8/25/2004 5:25:03 PM
I am writing an application that calls numbers of stored procedure wrapped in
an ADO.NET transaction. Some of the stored procedure implements T-SQL
transactions.
Is it safe to call Stored Procedure like this or there is potential of data
corruption.
Have anyone seen any document or article... more >>
create same Database connection on multiple computers
Posted by #'ak at 8/24/2004 4:37:13 PM
Hi,
is there a possibility to create automaticaly a ODBC database connection on
the multiple client computers (equal for all of them), in ex. on windows
2000 Profesional or XP?
And secont thing. Is there a possibility to automaticaly change all of the
ODBC connections without changing one by on... more >>
MDAC version
Posted by Ian at 8/24/2004 1:47:27 PM
Hi
How can I find out what version of MDAC is installed on a Machine.
And would there be any problem with me installing both MDAC 2.7 and 2.8 on
the same machine
Ian
... more >>
not function
Posted by Michel at 8/23/2004 6:08:26 PM
I'd like to do the following query
update myTable set myField = not (myField)
But it looks like not isn't a function.
How can I write this?
Thank you
... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Importing views from Oracle
Posted by Scott at 8/23/2004 1:49:01 PM
I've been able to import tables successfully from Oracle
to a SQL Server database. However, when I try to import
views from Oracle it wants to import them as tables in
SQL Server. Any ideas how I can import views as views
from Oracle to SQL Server?... more >>
Help with MS Access Error Trap
Posted by rob at 8/23/2004 10:04:54 AM
Please excuse if you feel this is posted in wrong group (I have posted in
Access groups as well)... I do know there is at least some some cross-over
base here that may help...
I am trying to establish links from Ms Access to tables in a SQL server
database. There is an Access table (tblLinkMa... more >>
ODBC security parameters
Posted by stevesklar at 8/23/2004 7:12:42 AM
We have several machines where multiple people login.
Normally we set the ODBC to 'with NT auth with network
login id'
When we change it from this to 'SQL server auth asking for
login id/pwd' our Visual Basic apps no longer work.
Our VB apps do have a login screen & pwd and that string... more >>
Transfer data from progress to SQL, character field format
Posted by Ofer at 8/23/2004 2:44:05 AM
Hi All,
I am using OpenLink's ODBC in order to transfer data from Progress Data
Server into the SQL.
When trying to transfer a field which has a character format on the
Progress Server, the DTS transfer only the first 8 characters of this
field.
The format of the field in the progress databa... more >>
|