Questionssubmit your own question

how to connect sql lite and vb6 database

Hello, i'm working on a portable app with Excel VBA and sqlite, i would like to specify a personal path for dlls in the connection String. can you help me with that ' Chemins personnalisés vers les DLLs et Base de données

Nome da fonte de dados não encontrado e nenhum driver padrão especificado

Hi, guys... I'm having trouble connecting to the Firebird 5.0 through ODBC connection. Can someone who's got the same issue help me? Any tip will be valuable. Thanks in advance. Giovane

Getting an error ADODB open connection -2147217887 (hex: 80040E21) - Multiple-step OLE DB operation generated. This is after out DB2 moved from a AS400 server to a new server. The conn string PROVIDER=IBMDA400;Data Source=198.19.236.75;UID= ; PWD=

Hello, I have an excel macro which connects to a sharepoint list and extracts data. The Sharepoint has a column which uses multiple lines of text with append changes to existing data set to true.

Buenas tardes Desde EXCEL VBA Necesito conectarme a dos listas de sharepoint on line para realizar una consulta SQL a las dos listas utilizando JOIN, pero me da error porque no reconoce los nombres dos listas.

How to connect multiple database using sql server

[MySQL][ODBC 3.51 Driver] Lost Connection to MySQL Server during query: I Used this Code and receiving the above error. The PhPMyAdmin is fully accessable from remote computer while browsing the ip address "192.168.1.160":

Private Sub Class_Initialize() ' On Error GoTo ERR_HANDLER DoEvents '/// for remote server Set mySQLCn = New ADODB.Connection With mySQLCn .connectionString = "Driver={MySQL ODBC 3.51 Driver};" _

Hi am currently wrtting a vba subroutine that i want to use in order to query a datatable in a worksheet, and then load the recordset into a different datatable in my current worksheet.

Hello colleagues, I have a question about the connection to SQL SERVER v15.0 database with the ADO toolkit in Labview.

exe.config, exe,database available after instal ssms in other pc unable to connect to database from exe to database, exe opening, database opening in sql server, but in exe login form user not showing , means data not showing, kindly help to connect it

Hello, I'm seeking assistance with connecting to an online website via an API call from SQL Server. I suspect my issue lies with the connection string configuration, but I'm unsure how to set it up correctly.

I have a Microsoft Access 2019 database and have a process external to the Access database that pulls some data and processes the data to email a summary to end users in my company. The process has been running for years without a problem. A few months back the external process

I need a connection string for a Power BI data source in a Fabric warehouse.

How to enable Column always encrypted to SQL server via OLEDB provider

Do you have an entry for Azure SQL Server Managed Instance? I see for Azure SQL. but Azure SQL Managed instance can hold multiple databases

Connection String for Excel 2016 32 bit. The script work without a problem on Office365 Excel version, When the same file is sent to a different user with excel 2016. It get Connection initiation error. "An Error occurred after the connection was established" .

Dear Community, I am using Microsoft Access ACEODBC driver v. 16.00.16827.20014 on Windows 11 and connection string: 'Driver={Microsoft Access Text Driver (*.txt, *.csv)};DBQ=path\to\tmp_dir;Extensions="asc,csv,tab,txt";'

Hello everyone; I need you kind help to solve the following connectionString Data Source=11.111.111.11,1433;(localdb)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\mydbase.mdf;Initial Catalog=mydbase;User Id=Ibrahim;Password=?????????

Hi, I must to configure the follow string connection jdbc:informix-sqli://ermes_sec:1530/ermes:INFORMIXSERVER=dbhermes_tcp Login : appestrd Pwd: Pd4pper! into oledb connection. thanks.

Hi all, Apologies if this has been answered already, but I'm struggling to find a solution. I'm trying to build a connection string that connects to Azure SQL Database using a Service principal.

Hi, Our database server is hosted on AWS and accessible through bastion server. To access postgreSQL database server, we will first have to create SSH Tunnel in putty and then only we can access database.

Hello, I wonder if you can give me some direction. I have a SQL site developed for data forms inputs by my brother-in-law, a password was given to me to do misc. admin stuff like adding users and data inputs.

Learn where and how to download the Provider for Oracle (OraOLEDB). The link on your page https://www.connectionstrings.com/oracle-provider-for-ole-db-oraoledb/info-and-download/ which refers to http://www.oracle.com/technology/ software/tech/windows/ole_db/index.html now results in page not found.

Can I please get internet Can I get internet

I need a connection string to connect to an Excel workbook that is stored ona corporate sharepoint site. I get a "Failure creating file" exception. Here is what I have been using:

Using connection string "Provider=OraOLEDB.Oracle; ....", my VBA code is connected to Oracle 19c. Next, how do I call an Oracle stored procedure of having input parameters and IN/OUT Ref cursor from an Excel VBA script?

I have an application provided by a 3rd party. I can no longer get support for the application. It uses an OLEDB connection to my own database to import information. A security patch is now blocking the use of the OLEDB connection.