Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [odbc]

179 questions
0
votes
2 answers

Only allow ability to read the views for a particular SQL Server user over ODBC

Newbie question: I have a designer who reads information from a SQL Server [2008] database. I've setup a few views for him to pull his data from and granted his user a member of the db_dataread role. His program uses an ODBC connection to grab…
Feckmore
  • 145
  • 2
  • 3
  • 7
0
votes
1 answer

Microsoft Access Duplicates Auto Incremented MySQL Record When Info Identical

I've recently run into one of the most frustrating bugs I've seen with a Microsoft Access integration with MySQL. What happens is that if you type something in a record, and then quickly move to the next record and type the exact same thing, the…
Madison Knight
  • 121
  • 5
0
votes
1 answer

Testing MySQL 32-bit ODBC connection via CMD

I'm going to make a batch script to do some basic troubleshooting. Among other things, I want to test 32-bit MySQL ODBC's for connectivity. This script will run locally on each workstation. There doesnt appear to be any option in odbcconf.exe for…
Ken Ash
  • 11
  • 1
0
votes
1 answer

FreeTDS - sudo uses different protocol version

After a while of fiddling with FreeTDS I got my connection to MSSQL from Sphinx up and running as DSN-less connection. After running indexer index Everything works as expected. But, after running (which I have to run as sudo to use rotate) sudo…
realshadow
  • 121
  • 4
0
votes
1 answer

How to read/ modify freetds.conf (for ODBC) using augtool or similar in bash script?

How can I get augtool (augeas) or a similarly common tool to work with freetds.conf, so I can automate some configuration in a bash install script? This doesn't seem to work: augtool print "/files/etc/freetds/freetds.conf" However, this works (but…
Oleg
  • 103
  • 4
0
votes
1 answer

Is it safe to Update and/or Insert records into an accounting software's database? (Pastel Evolution)

Our CRM system can post transactions to our accounts software (Pastel Evolution), but it doesn't perform the required currency conversion. Both systems have different "base" currencies (because of our location), so the figure thats sent to Pastel…
user1020317
  • 101
0
votes
1 answer

Problems configuring DB2 CLI/ODBC System DSN ODBC Data Source Administrator

I am trying to create a System DSN ODBC connection to a DB2 9.5 database, but I am getting a very strange problem. I've looked through the internet and found the following page that has some instructions on how I should proceed:…
Felipe
  • 113
  • 1
  • 7
0
votes
1 answer

ORA-01019 under Win 8.1 / Server 2012 R2, ODBC Excel

We getting error message ORA-01019 when trying to connect to an Oracle 9.2 database with ODBC in an Excel macro running in Office 2013 32bit (!!!) under Windows 8.1. We are having the same issue under Windows Server 2012 R2. We have tried several…
Ewert
  • 5
  • 5
0
votes
1 answer

How can I delete this ODBC?

I am unable to delete a specific ODBC of type system DSN. I am able to create and remove other ODBC connections on the same server, but a particular ODBC (name = Default) cannot be removed. If I try to rename it to something other than "Default",…
nairware
  • 309
  • 2
  • 10
  • 17
0
votes
1 answer

Plesk error when adding a subscription: ODBC error #08S01 can't connect to local MySQL

I'm getting this error after updating MySQL to 5.6 (Plesk 11.5, fresh installation) using the official MySQL repository right after adding a new subscription. Internal error: ODBC error #08S01: [unixODBC][MySQL][ODBC 5.3(w) Driver]Can't connect to…
gremo
  • 339
  • 1
  • 4
  • 20
0
votes
1 answer

Access to Windows event observer with ODBC

Is there a way to access the Windows Event Observer data from something like an ODBC datasource? Or a way to export data (lets say that we limit age of data to 1 week or one month) in a structured file format (csv ? xml ?) or similar?
tdaget
  • 103
  • 1
  • 5
0
votes
1 answer

Website can not connect to ODBC (no rights?) "Error: 80004005"

Background I am trying to migrate a website using MSSQL from MS Windows Server 2003 to a Server running MS WS 2008. It's been a while since I tried the last time (because I gave up on this problem) so I may don't remember correctly everything I made…
Benedikt S. Vogler
  • 125
  • 7
0
votes
2 answers

Client connectivity to MSSQL

I'm wondering if there is a policy that can be pushed that defaults a client to always dynamically determine the port for connectivity. I'm dealing with a custom C# application that connects to a remote SQL server. SQL Server Details SQL Server…
RevelingSeven
  • 1
0
votes
2 answers

32bit ODBC++ dll on Windows 2008 Server 64bit

A client of ours is trying to migrate to 64 bit Windows. They haven't got an ODBC++ dll present and our solution linked against the version shipped with 2003 server (32-bit). However, when looking at the 32-bit ODBC++ dll migrated from Windows 2003…
Woodstock
  • 103
  • 1
  • 1
  • 11
0
votes
3 answers

PDO ODBC error just resets connection

Trying to write an ODBC PDO driver for CakePHP. Seems like I get closer and closer however whenever a PDO function is called that it doesn't like the connection just gets reset immediately and I'm not able to get any error information whatsoever.…
Shawn Welch
  • 541
  • 2
  • 5
  • 19
1 2 3
…
11 12