Aug 10, 2017 · Our tutorial demonstrates a connection to SQL Server with pyodbc, but you can use the same steps to connect to any data source using a DataDirect ODBC driver. Instead of using a data source, the code can also be modified to pass a connection string to the pyodbc.connect() function for DSN-less connections.

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 the program or ODBC admin locking up for about 10 minutes before finally returning with the query or test result. Apr 21, 2015 · The ODBC connection has been setup using ODBC driver 11 for SQL server (and SQL Server Native Client 11.0 – on a different machine – still doesn’t work) Access is 2007 and Excel is 2010 versions. To note- even trying to connect using Excel 2013 has the same problem. Sep 27, 2012 · Hi All, We currently use an SQL Express database with a Microsoft Access front end, using odbc to connect them. I am in the process of setting up a VPN using one of our branch offices and want to give the users connection to the database without directly connecting to sql over the VPN. Aug 21, 2006 · I am trying to connect to an instance of SQL Express through a vpn, simply using the SQL Management Studio, providing the server ip address x.x.x.x\MSSQLSERVER, and using SQL Aug 10, 2017 · Our tutorial demonstrates a connection to SQL Server with pyodbc, but you can use the same steps to connect to any data source using a DataDirect ODBC driver. Instead of using a data source, the code can also be modified to pass a connection string to the pyodbc.connect() function for DSN-less connections. I have a local SQL 2005 database that I connect to via an ODBC connection. Lately I have noticed that once I connect to a Remote database via my VPN Client the connection to my local SQL database is lost, and stays lost until I reboot my system. I am using VPN Client 5.0.01.0600 and Window Vista. Any suggestions for fixes will be apreciated.

Everything is set up thru ODBC to connect to database and everyone logs into the domain just as if the where in the main office. Both servers are running on 1 GB netcard on 3Com superstack 4200 switch , the vpn is setup on a Adtran 600R and Cisco Pix 506E in the main office and a Westell Modem and Cisco Pix 501 in the clinic.

Hi, I did a migration from postgresql 8.1 to 9.4.1 and I have this problem, only for clients who work through the vpn, queries are very slow and this problem did not exist before migration,the network is the same , the server is the same, the current version of postgresql is 9.4.1 and odbc is the latest 32-bit version. This lesson demonstrates how to use ODBC to connect to a database. Here we have accessed MS Access Database and have fetched results from it. We have created this example using LiveCode, MS Access 2003 and Windows XP, but you can use ODBC to connect to any database that supports it, from within LiveCode. Everything is set up thru ODBC to connect to database and everyone logs into the domain just as if the where in the main office. Both servers are running on 1 GB netcard on 3Com superstack 4200 switch , the vpn is setup on a Adtran 600R and Cisco Pix 506E in the main office and a Westell Modem and Cisco Pix 501 in the clinic. I'm attempting to connect a windows server with oracle from a linux machine via VPN, we use a VPN client from cisco for linux, the connection seems to work. I have the odbc-oracle driver and I have installed OCI libraries from Oracle oficial server and configured then to connect to ORACLE server.

Aug 10, 2017 · Our tutorial demonstrates a connection to SQL Server with pyodbc, but you can use the same steps to connect to any data source using a DataDirect ODBC driver. Instead of using a data source, the code can also be modified to pass a connection string to the pyodbc.connect() function for DSN-less connections.

ODBC over a network is pretty stable, but any database operation over a VPN is going to be problematic. Connection qualitity (dropped packets), available band width, and latency (how fast is your packets getting there) are all issues with a VPN. Starting with the ODBC Driver 17.1 for SQL Server, the SQL_COPT_SS_TRUSTEDCMKPATHS connection attribute allows an application to require that Always Encrypted operations only use a specified list of CMKs, identified by their key paths. By default, this attribute is NULL, which means that the driver accepts any key path. Apr 14, 2016 · Route ODBC over VPN, no direct SQL server access - posted in Networking: We have a client with multiple sites that need access to their SQL instance to run a small application locally. The SQL ODBC DSNs installed on your system If the odbc package is installed, any system DSN (Data Source Name) you have installed will be listed. For more information, see Integrated security with DSN . Connections supplied by your administrator An administrator may put connection snippets into a folder to make them available to end users. Pretty new to SQL problems, Have a user that connects to sql over vpn. worked fine for about a year, I don't know what changed but now can't connect. When I try to connect via odbc get