Connection string settings
How to pick connection string from excel cell. I want to configure my connection string with drop down as soon as change the name in drop down connection string update according to that everytime.
How to pick connection string from excel cell. I want to configure my connection string with drop down as soon as change the name in drop down connection string update according to that everytime.
Hi I am trying to connect to a Oracle Database from SSIS using kerberos /keytab authentication. What will be the connection string for database in case i want to read the pwd from my keytab file
How to connect to MySQL from power automate desktop?
Re : IBM DB2 for IBMDA400 OLE DB Provider I am trying to make the provider connection READONLY I have added the parameter Read Only Connection=TRUE; to the connection string, but it still allows SQL updates
I tried to connect and access MySQL database with VBScript script, <% rem ASP link mySQL DATABASE: dim mysqlConn,mysqlodbc,conn,adoconn,sqlcmd,objrs,theDriver,isCharSet dim iporUrl,dataName,admYouid,strPaswd,opeKey
Hello, Been searching for a way out, How can i make a connection to a folder on sharepoint
Hello dear friends. I have an issue trying to connect Blazor Server using Dapper to Postgresql. So, I have the current connection string: "Server=localhost; Port=5432; Database=Blazor_Users;User Id=postgres; Password=dom.1**;"
conn.Open(("provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\QC\rendemen.accdb;Persist Security Info=False;")) Provider cannot be found. it may not be properly installed
I'm fairly new to Computer Ease construction software. I need to know if there is a way to re-open a closed month end period. Would there be an expert here who could answer this question? I looked at the manual online and there is no subject relating to month end. Thank you, Pang
Hi, I am trying to connect to a SQL cloud hosted database using VBA on excel Microsoft 365. I have tried a number of online posts but the connection will not open.
I don't know how to write the connection string. my .mdb is access 95.... and I tried those two string string connStr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+ DB_path + ";User Id=admin;Password=;";
When i try to connect to a remote database using visual studio 2019 or directly from a webapp i get the error: (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server.)(Microsoft SQL server error:53).
Hello Experts, We are trying to fetch the table data from PostgreSQL into another SAP tool hosted on windows 2016 server. ODBC driver 64bit has been installed in the server. Connection string has been defined in the tool.
I have a single table with multiple clients who have 2 services that need to be compared via date. One services is a MUST and the other has 5 other possibilities.
I tried to connect PostgreSQL in Blazor Hero but I got this problem. System.ArgumentException: Keyword not supported: data source (Parameter 'keyword') at Npgsql.NpgsqlConnectionStringBuilder.GetProperty(String keyword) at
What is meant by changing Namespace and how do you do it, for the new Microsoft.Data.SqlClient
Hi guys I'm trying to retrieve deleted records in a DBF(dbase IV) for now I'm using this connection string Constring = " Provider = vfpoledb; Data Source=" & path & "; Extended Properties=dBase IV DELETED=true"
I have a AWS architecture where I have a Postgres DB to connect via SSH jumphost. I can connect to this DB using pgAdmin (using SSH tunnel and DB info). What is the connection string should I use to connect for this DB (in .NET)?
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"))