Fetching data problem....
Wed, 7 Nov 2007 13:12:15 +0100
Hi,
When I'm using ODBC SQLFetch method in my code it retrieves data using
database cursor. In fact it calls sp_opencursor in DB. Is it possible to
retrieve data without using cursor? What is the fastest way to fetch data?
I'm afraid of using cursor because of the performance. Do you have any
suggestion? (I'm u ...
|
ODBC Dynamically
Tue, 6 Nov 2007 12:46:01 -0800
We have some users that we'd like to test some things. In order to do so,
we'd like to build them a function where they can click on something and
dynamically change their ODBC connection to point at our Test SQL Server
rather than the Production SQL Server.
Has anyone ever developed anything like this that ...
|
adding new tables after ODBC linking
Tue, 6 Nov 2007 10:02:10 -0800
Hi,
I have an Access2003 database -- which I upsized to sqlServer 2005 -- as
linked ODBC tables
I have numerous access forms I would like to continue to use for quick data
entry -- for the time being.
Is it possible to add a new table in Access (or in SQLServer) and then
depending on which route I go ...
|
ODBC download question
Tue, 6 Nov 2007 12:02:48 +0800
Hi,
One of my client's PC (Win XP SP2) is using ODBC 3.52, and I need to install
the newer version ODBC for that client.
I searched the web and execute the mdac 2.8 sp1, but it won't allow to
install on that PC.
Where can I get an ODBC for installing on my Windows XP SP2?
Thanks for help.
Jason
...
|
ODBC Connection Ports TCP UDP
Mon, 5 Nov 2007 07:37:01 -0800
What are the standard UDP and TCP ports for an ODBC connection?
--
NC Beach Bum ...
|
SQL Domain autentication display name
Sun, 4 Nov 2007 19:12:41 -0800
Hi There,
We are using SQL 2000 with Windows Domain authentication. We are using
EFI-LOGIC program.
1) Because of security issue I can only create ODBC connection from
Administrator login not as a user. ODBC connection is fine, but when we login
as user from EFI-LOGIC software the name display is Administra ...
|
import dbf to sql
Thu, 1 Nov 2007 01:56:56 +0530
Hi All,
I need help to import dbf files into sql or msde database
The dbf file is currently managed by sql server
Please suggest how can we import data from dbf file into sql or msde
Regards
Samir Shah
...
|
|
|
Connection to SQL using domain
Wed, 31 Oct 2007 15:03:38 -0400
Is it possible to open a SQL Server connection using domain credentials that
are not your own? In ODBC dialog, you have the option for Windows
Authentication (your own domain account - this works, but not what I want)
or SQL Authentication.
In SQL Server, I have a login created as a domain account and it s ...
|
SQL Server 2000 not showing up in list of Servers
Wed, 31 Oct 2007 09:57:01 -0700
I have both SQL2005 and SQL2000 installed in the same machine.
When I am trying to configure a ODBC connection to SQL2000 database, using
SQL2000 driver, I do not see the SQL2000 in the list of servers.
Please let me know how I can make it available in the list of servers. ...
|
install ODBC connections with login scripts or GPO
Tue, 30 Oct 2007 12:56:03 -0700
Is there any way to add our standard System DSN or equiv, ODBC connections on
XP clients via scipt or GPO?
THis cannot be the first time this question has been asked but I cannot find
a satisfactory answer.
Thanks in advance! ...
|
