I need to turn on Multiple Active Result Sets for an ODBC data source, but I can not figure out how to set it. And the end of the wizard I see this in the configuration summary: Multiple Active Result Sets(MARS): No Asked by mikerobi It’s best to enable MARS in an app’s connection string when that app is specifically designed to make use of this feature. That said, you can edit the registry entry [...]

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 make a new DSN. What do I put for: Which SQL Server do you want to connect to? Server: The server is windows server 2008, and it is remote. [...]

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 everything is identical (md5sum) save for the existence of that file. There is no difference in the environment and the odbc.ini and odbcinst.ini files are also the same. I’m currently at a loss. I’m [...]

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 some embedded connection strings which reference a server that does not exist. My guess is that the client tries to use the embedded connections when loading the report. I [...]

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? Do I need to install anything on the server to allow this to happen? Asked by penyuan It’s easier to maintain a machine if you [...]

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 tunnel as part of a requirement for a client app to run. So far that is working perfectly. Computer B is on the same [...]

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 error: Microsoft OLE DB Provider for ODBC Drivers error ’80004005′[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified/includes/<File Name>.asp, line 100 What I’ve tried: The connection [...]

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 change the ODBC connections on all the application servers, report servers, some workstations, etc to point to the new SQL Server instance. Is there a way to point [...]

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 drive (Z:) connection. Several months ago they began getting this error intermittently: Data source name not found and no default driver specified This results in the ISV having to connect to [...]

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? Unfortunately, ODBC is is the only game in town. Currently there is no better way in the market that allows you to do it without ODBC, nevertheless the [...]