hello. i'm trying to use tables from ms access and explore the data in excel so i want to write a code in vba excel that enables me to connect to the database in access. i searched and i found that i have to use connexion strings..
I have created one Windows Form Application using VB.Net along with MS-Access Database. Currently that Ms Access Database saved in the Project path. But i want that MS Access database in Sharepoint Shared Document folder.
Hi. I am looking for the right connection string to retrieve data from microsoft sql database (2019 version) to an excel worksheet, using vba. I am currently using the MS Office 2016 version..
I am unable to connect SQL Server database from my Julia Language code web server; I suspect I am not able to figure out proper connection string.
Hi, I have one Env where I am trying to connect to postgres db from load runnner. conn = PQconnectdb("host=***** port=*** user=**** password=**** dbname=**** sslmode=require"); Response
how to connect ssms from visual studio using a domain account or service account ?
Hi, I have exported data into excel file using oledb since I cannot use interop or any third party library. Here is my code ''' ''' Export datagridview's data contained in an data table to excel file
I want to automate queries I repeatedly perform in SQL Developer. How can I determine the connection string based on the right-click properties of each individual DB connection in SQL Developer?
When I add this security section in the connection string (SECURITY=(SSL_SERVER_CERT_DN="cn=sales,cn=OracleContext,dc=us,dc=acme,dc=com"))
What is the connection string for Google Sheets?
The working JDBC connection to a Oracle 18c database is like this: "jdbc:oracle:thin:@//the.server.name.org:1580/boilerinfo" What is the correct ODBC connection string to connect to the same database? I tried just
Hello - Is everything related to "Access for MS365" identical to Access 2013? Thank you, Stefano
I am using asp classic and access 97 database. I am trying to connect two databases at the same time. I want to join two tables in dfifferent databases. I couldn't connect them. How can we join two tables from two databases? I will be gratefull for your help.
I am attempting to use a VB.NET ODBC Connection to connect to an AS/400 iSeries database. I need to be able to pass special characters in users' passwords, but am getting an "Syntax error in connection string" because of the special characters in the password.
Hi All, I am trying to import data from PostgreSQL database using ODBC Driver. I have installed the ODBC driver and created a System DSN as required. The connection within the DSN is successfull.
Hello Everyone, I am trying to create a iSeries Access ODBC Driver connection via TestComplete tool. The connection string used is : "Driver={iSeries Access ODBC Driver}; System=; Uid=UserId; Pwd=Password; MGDSN=0";
how to connect to mysql database from vb6 remotely. please share sample code or video for this connectivity
Is there new or existing method parse a connection string’s keys to determine the connection type (OleDbConnection, OdbcConnection, SqlConnection, MySqlConnection, DB2Connetrion, etc) ?
Hi every one, I've been done a project and i want run it on another device but its need the server name inside connection string that i used in the system which i made up the project, and it also does not support (".")
hi, Do you know how could read old btrieve file?
I'm trying to connect to some dbf files using the Advantage Odbc driver. The problem is that PowerBuilder is only showing one table and only one record in that table.
When I run the following in my Postgres database, it gives Message 42704: unrecognized configuration parameter "sql_mode". **SET sql_mode='PIPES_AS_CONCAT';
I get the error below when I run code to write clear data and write data into a SQL Server Database.
I have a large collection of small databases that open in Access. I am trying to open them in a vb.net application (.net framework 4.7.2) with this connection string (and variations for the many directories that contain the other database files):
Hello everyone, I'm trying to make a VB console app to send mails extracting the data for the mail from a database located in the same pc. I didn't set up anything of the mysql server client.
With the following in my C# Visual Studio .NET Core Winforms app, I'm getting "unable to open database file": using System.Data.SQLite; . . . string cs = "Data Source=\F4FDataSQLite_SingleTable.db;";
I am a Continuity Management consultant, and work with app and infrastructure resources to create and validate recovery/resiliency plans.
How do I connect from an Azure Managed Instance to an On-Premise SQL Server database. What does the connection look like ?
I was using the below line for connection in my VBA application in window 8 and excel 2013 but when I tried to use my application from window 10 and Excel 2016, it fails to start with an Error.
My operating system is Windows 10 Pro 64-bit. I am using Microsoft 365 32-bit. I am trying to use ODBC to connect to an xlsx file from Exportizer Enterprise 64-bit (https://www.vlsoftware.net/exportizer/).