Hi, I have connected a Excel 2016 file to a SQL Server and it works ok. An user, who has Excel 2007 version should use the same file and he is reporting this error while refreshing the data: Run-time error '1004': Application-defined or object-defined error.
Hi I've taken over a ASP.Net site using an Oracle back-end, I can get it to connect to the database on our development PCs but on the live server, I'm having an issue as follow and wonder if anyone could help as not an Oracle expert and the Oracle server was setup many years ago...
Hi I've taken over a ASP.Net site using an Oracle back-end, I can get it to connect to the database on our development PCs but on the live server, I'm having an issue as follow and wonder if anyone could help as not an Oracle expert and the Oracle server was setup many years ago...
Hi I've taken over a ASP.Net site using an Oracle back-end, I can get it to connect to the database on our development PCs but on the live server, I'm having an issue as follow and wonder if anyone could help as not an Oracle expert and the Oracle server was setup many years ago...
I have tried the following variations of the same statement in Powershell 5.1: $objCon.Open("Provider=Microsoft.ACE.OLEDB.12.0; Data Source=C:\MyDocuments\WWW.mdb")
I have developed an ASP.Net Web Forms website on my local computer. I installed SQL Server Express 2017 on the local computer. I have a SQL Server database connected to SQL Server Express using the following code in web.config:
I have an Acces 97 database working on a Windows 7 PC where I can get data from it by XAMPP with phppdoodbc. I want to have this database on a QNAP NAS with Linux arm5, on Debian9 with a working Apache2 and PHP7, but I cannot get it to work. I now use:
Greetings, I am trying to figure out a connection string to a ProvideX database in ASP.NET via the Web.Config and App.Config files. Any assistance would be most appreciated. Thank you!
Hello, I am trying to connect to a database that was set up using PostgreSQL. I connected to the database via Microsoft OLE DB Provider for ODBC Drivers.
Connection is not opening when I try to open using VB.Net to MS SQL server 2016 with port 1600. My connection string is "Public globconnectionstring As String = "Server=learningserver.com,1600;Database=learning;User ID=readonly;Password=readonly"
Hi All, I have a connection string in an Excel Spreadsheet that links to other spreadsheets. All works well. However, the file and directory are written as absolute. Can this be relative?
Hi ADO is undeprecated. There is a new release of ADODB driver for SQL Server. It supports SQL Server from 2012 to 2017 and Azure also. Follow the link: https://blogs.msdn.microsoft.com/sqlnativeclient/2018/03/30/released-microsoft-ole-db-driver-for-sql-server/
iSeries Access ODBC Driver connection query returns empty recordset if library is not specified. Is there a way in which I can use this string to connect to ISD (As400) and quesry without specifying a library?
I'm composing a chart from 3 columns of data, and need help to format on Excel for Mac, Office 365. All columns are %s. first is X axis: relative % 0 - 200, of Y and Z.
I am working with an MVC application, problem is, is it possible to write to a Visual FoxPro database from an MVC application? .. If possible any help in regards with this will be highly appreciated.
Hi, I have an MVC app that connects from it's web config file using another class within it called PetaDb (derived from PetaPoco class).
Hello programmer friend I made a program C # .net with visual studio connected to a database sqlite which I made the executable to be able to run it on other pc but the problem is that I can not to save in my database ... here is the error:
Hi , I had ASP.net Application connect with SQL server 2016. Now we upgrade SQL server to Always on High Availability. we had three Server 1) Witness 2) SQL-Cluster-1 3) SQL-Cluster-2
I have to use fixed Domain user in connection string to connect to SQL server. But the logged user for windows is different. Is there any solution . this is requirement of our project. Please help .
Hi I am using excel 2010, my excel file connected to dbf file and excel file has my pivot tables based on the dbf file and once the dbf file is updated I refresh the excel file and all the charts are updated.
Hello, I'm working on programmatic queries relying on the Oracle provider for OLE DB (in VB script). I can successfully query my database using the standard syntax: Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;
I am trying to insert excel data into an access database. The code below works perfectly for me even though it gives me access denied after successful upload. <% Set cn = CreateObject("ADODB.Connection")
I have been successfully using the following PostgreSQL connection string in multiple Excel 2010 vba applications running on 64 bit Windows 7 systems. I have moved to a Window 10 system and my application will randomly lose it's connection to the DSN.
Hi I can connect to a remote SQL Express server using the connection string strconnectionStringX = "Data Source=192.168.1.67; Provider=SQLNCLI11; DataTypeCompatibility=80; Network Library=DBMSSOCN; Initial Catalog=vocab; User ID=[ID]; Password=[Password]"
Connecting using ADO in VBA / Excel. I've done the ado stuff before .... 5 years ago so I'm a bit rusty. Installed MySQL on my laptop and trying to work with DBases again.
Data Source=190.190.200.100,1433;Network Library=DBMSSOCN; Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword; i configuered the connection ok and from my laptop-1 i connect to sql server and success
I am trying to connect from vb.net with the string below strConString = "Driver={PostgreSQL ANSI};Server=192.168.136.1;Port=5432;Database=postgres;Uid=postgres;Pwd=ragu1234;" DbCon.ConnectionString = strConString
Hello, we need to use parameters for MS OLE DB Provider for FoxPro connector. We can use not easy questions into tables, we need a named parameters. Now we have to use ? convention, but it's not comfortable for complicated questions.
Hello, I am trying to connect to Sybase server using ssl enabled connection string. But I always get exception "[AseException: Could not load sybdrvssl library]
Hello, Could anyone please tell me what do I need to do in order to connect to Oracle 11g through VB script. I already had my tnsnames.ora file set up on my machine and I was able to TNSPING to the Oracle 11g database and I was also able to SQLPLUS mylogin/mypassword@database.