Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [odbc]

179 questions
1
vote
2 answers

Listing ODBC Connections on Remote Machine

I'd like to connect to a Windows (XP & 7) machine remotely (command line or Powershell) & list the ODBC's installed on that machine, ideally I'd be able to list the server name/database setup in each ODBC.
aphrek
  • 23
  • 1
  • 2
  • 4
1
vote
1 answer

SQL Server ODBC Connection via Command Line

I need to create a number of ODBC connections to a MS SQL Server, the clients are mainly XP machines. The connection has to use SQL server authentication - is there a way to do this remotely via command line? I think that this type of authentication…
aphrek
  • 23
  • 1
  • 2
  • 4
1
vote
2 answers

make microsoft access use TCP/IP instead of Named Pipes

I got a Microsoft Access database which is constantly trying to contact the corresponding Microsoft SQL Server using named pipes, even though only TCP/IP is available and the ODBC is configured to use TCP/IP. It's not possible to link all the tables…
Zulakis
  • 4,153
  • 14
  • 48
  • 76
1
vote
1 answer

Migrating ODBC information through a batch file

I am a desktop support technician currently working on a large scale migration project across multiple sites. I am looking at a way to transfer ODBC entries from Windows XP to Windows 7. If anyone knows of a program or anything prebuilt that already…
DeskSide
  • 13
  • 1
  • 4
1
vote
0 answers

Sybase ODBC driver not working over a VPN

I need to run a client's software locally on my machine and have it talk over a VPN link (Team Viewer VPN) to connect to the live database so I can attach a debugger to the client software and figure some issues out that the client is having. When…
Scott Chamberlain
  • 1,455
  • 2
  • 21
  • 37
1
vote
1 answer

SSIS DSN Not Showing as ODBC Data Source

I have been following the directions here: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/05ccd778-b78c-4a83-a10a-c4ae412cc6e4 And ran into a problem where my System DSN is not showing up as a ODBC provider. I found…
user1114330
  • 173
  • 1
  • 3
  • 11
1
vote
0 answers

What does the error message "Communication link failure (SQL-08S01)" actually mean?

Our application is running on dozens of servers and only a few get this error message. What is worse, is that the SQL query that causes this error message seems to be executing. The application is working properly. The process that causes this…
Jason Lamoreux
  • 109
  • 1
  • 10
1
vote
2 answers

What's needed to enable JDBC or ODBC to MySQL database?

I have a MySQL server on my Scientific Linux 6.2 system. Right now I know how to create a new database, and set up users. I need to setup LibreOffice Base to connect to the MySQL server, via either ODBC or JDBC (ideally over SSL). How do I do this?…
hpy
  • 845
  • 3
  • 18
  • 28
1
vote
1 answer

Managing mass SQL Server ODBC Changes when migrating to a new SQL Server

How do you manage changing out a SQL Server and updating all the clients that connect to it to point to the new server? If I have SQLSERVER1, then buy new hardware and call the new server SQLSERVER2 and migrate all the databases over I have to…
Benjamin Bryan
  • 197
  • 1
  • 9
1
vote
1 answer

MySQL ODBC Issue: Data source name not found and no default driver specified

I'm currently trying to run a classic ASP application which I've been given source code for. I want to set up on my 64bit Windows 7 dev machine and am having trouble with an ODBC based data connection to a MySQL instance. I'm seeing the…
gbro3n
  • 259
  • 4
  • 14
1
vote
1 answer

MySQL ODBC Connector & unixODBC Issue - Garbled connections

Having a heck of a time trying to isolate an issue on a new server install: I've installed MySQL, unixODBC and the MySQL Connector for ODBC, setup odbc.ini and odbcinst.ini as I have on my other 32-bit systems, but having an issue with applications…
quidpro
  • 11
  • 2
1
vote
1 answer

Connect MS SQL server with Filemaker Pro using ODBC

I would like to connect to MS SQL server with running on Microsoft 2008 R2 Server to filemaker pro server 11 running on Mac server 10.6.8 using ODBC. HOw can i get to go about this? is there an easier way to do it apart from ODBC?
Gatura
  • 573
  • 3
  • 10
  • 24
1
vote
2 answers

What might cause and ODBC connection to report Data source name not found

I'm working with a small business that uses an Access-based database for work order mgmt. The system has been around for years and they have 6-7 PCs using custom software from an ISV to access the database. The database is accessed over a mapped…
uSlackr
  • 6,412
  • 21
  • 37
1
vote
1 answer

Can I have multiple Sybase (or any other) ODBC Drivers installed?

Is it possible to have two different version of an ODBC driver installed on a single server, specifically Sybase Adaptive Server Enterprise 12.5 and Adaptive Server Enterprise 15.5? Obviously any program would have to use one driver or the other.
C. Ross
  • 3,075
  • 9
  • 35
  • 36
1
vote
1 answer

The 32-bit ODBC client for MS-access does not work and installing the 64-bit client is not allowed, what to do?

I have a 64-bit Windows 7 laptop that I use for development. I have office 2003 installed, because I have a client that works with Office 2003. Microsoft Access is not installed, because it's my firm belief it's a piece of ehm non-optimal…
Johan
  • 312
  • 3
  • 13
1 2 3
…
11 12