Questions tagged [odbc]
172 questions
0
votes
4 answers
ODBC connection to SQL Server through firewall
The Status Quo:
There's a SQL Server (2005) database. On the same network, There's a user who connects a Visual FoxPro instance to said database via ODBC. This works, the user is happy, and everything is hunky dory.
Looming on the horizon:
The SS…
![](../../users/profiles/11328.webp)
RolandTumble
- 103
- 1
- 3
0
votes
1 answer
Create ODBC Connection from Access to SQL Server
I need help connecting from a blank access 2010 database to my remote SQL Server 2005 database. This is because I'm going to write all my client apps in Access, and store everything on the server with SQL Server. I'm using the wizard, and trying to…
![](../../users/profiles/118800.webp)
Scriptonaut
- 137
- 6
0
votes
3 answers
How do I trace from my client PC what databases it connects to
I wonder if there is some way to trace what servers my program using OLEDB tries to connect to.
Problem:
I have a program displaying some reports made in Crystal Reports.
The loading of some reports are really slow when.
My guess is that they have…
![](../../users/profiles/116283.webp)
mortb
- 103
- 5
0
votes
1 answer
Is it possible to share an ODBC connection with other computers on the network?
I will try my best here but I am going a little out of my comfort zone so bear with me.
Computer A: Windows XP Pro
Computer B: Windows 7
Computer A has an SSH Tunnel to our web server (linux). Computer A uses an ODBC connection to connect to the…
![](../../users/profiles/19349.webp)
Bill H
- 113
- 5
0
votes
1 answer
what is DDODBC.DAT
The file /var/local/odbc/DDODBC.DAT is being created/accessed on some (not all) servers when the database is accessed via Perl dbi:ODBC.
I did a full crawl through /var/local/odbc on a server that does create the file and a server that does not, and…
![](../../users/profiles/102773.webp)
Christopher Neylan
- 477
- 5
- 13
0
votes
2 answers
Encrypting an ODBC connection
Situation:
We have a SQL Server 2008 R2 database sitting in a data centre
We would like to allow analysts to connect to the database and query the data using desktop based tools (e.g. Tableau) via ODBC. The desktop based tools do not necessarily…
![](../../users/profiles/46479.webp)
mikera
- 165
- 1
- 7
0
votes
1 answer
FileMaker Server not listening on Port 2399 for ODBC/JDBC
I am trying to create a ODBC connection from an OSX machine to a Filemaker server 10 using a DataDirect SeQuel Link 5.5 JDBC drive. I have ODBC/JDBC enabled on the server and I followed all of the instructions to set up JDBC properly (and the…
![](../../users/profiles/33492.webp)
Greg_the_Ant
- 489
- 7
- 25
0
votes
1 answer
Registry for odbcad32 on Window Server 2003 64-bit
I used to use below registry to import some settings for setting up odbc on Windows Server 2003 32-bit. Now I want to do the same on a Windows Server 2003 64-bit for 32-bit odbc driver not the 64-bit one. Is there any way to modify the registry?…
![](../../users/profiles/32166.webp)
Stan
- 1,367
- 6
- 24
- 40
0
votes
1 answer
Are Sybase ASE ODBC drivers for Windows x64 available for free?
Are Sybase's own ASE ODBC drivers for Windows x64 available for free? If not, does anyone know of a cheaper (preferably free!) alternative?
I believe the ODBC drivers are available as part of the Sybase SDK, but I only require the ODBC drivers, not…
![](../../users/profiles/20596.webp)
Brisbane Mango
- 69
- 2
- 5
0
votes
1 answer
Can I create an oracle ODBC driver without installing the Oracle Client?
recently I got a task to migrate the back end of an access database to oracle (the front end should still remain in access), I need an odbc connection for that and on the PC I am working on I don't have any administrative privilages. Whenever I am…
![](../../users/profiles/62154.webp)
user62154
- 131
- 1
- 2
- 3
0
votes
2 answers
Batch-script implementing 2 ODBC-connections
Thanks for all previous help! I have a question regarding av script.
My computers is all XP, and needs the following when I do my thing :
I have 2 ODBC-connections (towards MS-SQL-DB), which I have a username / password to create a connection…
![](../../users/profiles/47619.webp)
Maclovin
- 249
- 1
- 2
- 11
0
votes
3 answers
ODBC connection is extremely slow
I have an ODBC connection to a providex database. We use the database in software throughout the company, and the ODBC connection is created by a standard installer.
Trying to test the ODBC connection or query it in Crystal Reports.Net, results in…
![](../../users/profiles/577.webp)
Tony Peterson
- 109
- 1
- 1
- 3
0
votes
1 answer
How do I set up an installation script including ODBC-connection?
Easy question this time.... I have a installation file, and a registry edit in my script.
How do I set up a ODBC-connection as well, actually I need to script up 2 ODBC-connections.
Any advice for me?
![](../../users/profiles/47619.webp)
Maclovin
- 249
- 1
- 2
- 11
0
votes
3 answers
How do you connect to BusinessObjects?
I have the rights to log into a BOXI server and build queries and reports, but can only export 100,000 rows at a time.
I have tools on my desktop that can connect to databases via things like ODBC.
Is there a way to use ODBC or some other connection…
Joe
0
votes
2 answers
Problem connecting to database after a RESTORE. SQL Server 2005 and Classic ASP
I have some Selenium test scripts which I'm using to test a Classic ASP web app, but I'm having problems after restoring the database (SQL Server 2005) with a backup file before every test is run. Immediately after the successful RESTORE (from a…
bartonlee