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…
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…
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…
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…
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…
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…
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…
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?…
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…
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…
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…
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…
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?
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