(page 4) Questionssubmit your own question

My Data Source (path and name) is saved as a Constant string in the VBA module. Is there a 'workaround' for the error message: [Microsoft] [ODBC Driver Manager] Data source name too long ?

I'm setting up new pc workstations with office 365 for business which includes Access. For year's i've been linking FoxPro database files to access accdb files.

Is there a data provider for Salesforce

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.