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
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 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=;";
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.
What is meant by changing Namespace and how do you do it, for the new Microsoft.Data.SqlClient
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.
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.
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 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 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.
I am a Continuity Management consultant, and work with app and infrastructure resources to create and validate recovery/resiliency plans.
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.
If i will use other domain i cannot connect to the MS SQL Server but if i am using the same domain i was able to connect to the MS SQL. Another domain is okay i can ping and i can remote also share drive ok also only the application cannot.
I have windows 8 Trying to Connect Access 2007 from VB.Net 2012 using the ADODB Connection con.open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Temp.mdb;Persist Security Info=False;Jet OLEDB:Database Password=")
how to create dns-less connection from ms access to sqlite
I don't know if I'm in the right place. I have done everything with PHP and ODBC so far. Now I wanted to make my homepage show-like and I made it with WordPress. so far everything OK
buenas noches, tengo problemas para ingresar a mi dominio en wordpress, cuando coloco para entrar al admin me arroja un error que dice:
I am trying to connect from my Azure function app to a SQL server which is installed on a Azure VM. Kindly help with the connection string "Server = MyVMIpAddress;Integrated security = true;Database = mydb;User Id = myuser;Password = mypwd;"
I am trying to make a data connection between Excel to csv file but the csv file every date is change.
Hi, current environment: AccessDatabase (.mdb) file located at secured network share special domain user account has read/write permissions to this network share
Using vba and Microsoft.ACE.OLEDB.12.0 connection to Excel 2013 workbook. Inserting records into worksheet work fine. Problem occurs if I update a field in a record with a blank ("").
Corporation updated my server and i started getting this error (provided from the server team): GET, /page/pages/MarketMatrix-2.asp, |236|800a0e7a|Provider_cannot_be_found._It_may_not_be_properly_installed.,
I need to know how to open a password protected Excel file using OleDBConnection. I saw a post that provides a work around. I am using Excel 2016. Is there a way in this version? The excel is 2013 and older.