Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Share tech news, updates, or what's on your mind.

Sign up to Post

Hi guys,

We have a SQL 2016 running on 2012 R2 terminal server. SQL is holding databases that were migrated from SQL 2005. Using SQL Server and Windows Authentication mode.
SQL service is running under domain admin's account.
There seem to be no problems running locally but outside the server, we get 2 problems that seem to be connected:

1. SSRS reports that were also migrate work fine on the server, both in VS and SSRS website. Most of databases work outside and inside - there are few that give this error when trying to run a local machine through SSRS website:

    An error has occurred during report processing. (rsProcessingAborted)
        Cannot create a connection to data source 'WEB_TNN'. (rsErrorOpeningConnection)
            For more information about this error navigate to the report server on the local server machine, or enable remote errors

Trying to create a subscription on those reports gives this error  - both on the server (even though report generates ok) and outside;

Subscription can't be created or edited because the credentials used to run the report are not stored, or if a linked report, the link is no longer valid.

Data Sources are identical to the sources that work without problems
I can use Custom data source with SQL login and then it works fine.

2. Unable to create an ODBC connection, both 32 and 64, on my local machine (tried different machines), using Windows authentication. Only works with SQL login.
Hire Technology Freelancers with Gigs
LVL 12
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

I have an Access (2016) database that used to work when I clicked on a button it would export the data to an Excel spreadsheet. I created the commands in Access's VBA (I am not a VBA programmer) however now when I try to run (click on the button), I get the following error "Compile error: Can't find project or library. Here is the VBA code that I am using:

strSQL = "SELECT * FROM " & "Table_ExpenseReport" & " WHERE " & "[ID] = " & ID & ";"

It is showing that the error is on the ID part. I want this to pull the data in the ID field (cell) in the Access database and keep it as the rest of the command sends that ID's data to the Excel spreadsheet and only that ID's data. Can someone help me? I am more than happy to attach screenshots, etc. to make this work again.
DB2 10.5 on Windows

I am getting ready to copy the production database to our test server and then scrub all the sensitive data.  What I would like to do is to script out all the permissions on the test database before I restore the production database.

Using TOAD, I can click on a user and view details and it will script all the grants for me, but there are about 3 dozen users in test and I don't want to do each one by hand.  I would love to capture the SQL that TOAD is generating to get that script and then I could run if for all the users.

Does anyone have a script like this?  That will give me the grant statements for all the users on a given database?  I could do the one at a time method but that will be a real pain.

Thank you!

I'm trying to connect to a Pervasive database remotely and I have done everything needed to connect but it does not work on the remote server. Port is open on the firewall and I can telnet to the 1583 port from the remote server and also see the packets from the remote server.

On the remote server, I'm using PCC to connect to the remote computer.

Here is the configuration of the database server

I'm mainly working with MS Access for my client, and I noticed a reccuring issue: Data import.

This is a major source of troubles, especially when data (usually excel or CSV files) comes from unknown (and unreliable) source, usually they hold bunch of incorrect data, preventing databases from working properly (crash, unhandled data, vanishing data, data replaced by incorrect ones ....... the list of potential bugs is infinite).

So, I wrote a generic library database, who's purpose is to handle data import, validation, convertion, computation, from virtually any data source, to virtually any data source.

Now, I would like to distribute (and why not, sell) this "Framework" (can I call it like this ?), for privacy purpose, I'm thinking about converting it into a COM componnent that VBA projects will be able to set a reference on.

Wich steps should I follow to achieve this goal ?
What about software licence ? And price ?
I have an Exchange 2013 organization and I have a database that is completely uncooperative. It won't mount unless I -Force it to mount. I created a fresh database to migrate the data into. It's a very small number of mailboxes and other resources. How do I know if there is actually anything left in it, and how do I identify what's left to move?
I have a database that runs an import of one CSV file and two xls files every day. I had set up fail-safes within the code to make sure that no blank files were imported, but recently discovered that this had caused some problems.

If DCount("*", "Table", "[Field]=Format('" & Activity_Date & "', 'Short Date')") = 0 Then
    MsgBox "Import brought over Zero files for Date imported. Please confirm this is accurate", vbYesNo, "Zero Import"
    If LResponse = vbNo Then
        Exit Sub
    ElseIf LResponse = vbYes Then

Above is the code that I created. Even if there is data in the table that is being searched, the database instead jumps to the Message Box line and then takes me to the bottom of the code that ends the import prematurely. So far, the only way that I've found to allow the import to go through completely is to turn off this section of the code completely. However, that means that there is no fail-safe in place if the import tries to bring in an empty CSV file. If there is any way to set this up, or maybe an easier way to check for blank CSV files, that would be greatly appreciated.
I got this Error while adding  DR Site Server for DAG,
"A server-side database availability group administrative operation failed. Error The operation failed. CreateCluster errors may result from incorrectly configured static addresses. Error: An error occurred while attempting a cluster operation. Error: Cluster API failed: "AddClusterNode() (MaxPercentage=100) failed with 0x5b4. Error: This operation returned because the timeout period expired". [Server: WS2K16EXG1601.domain.local]"
Hello everyone

I work for a small charity and we provide a courier service in our city. In the past seven years, the data has been saved in an Excel workbook with lots (!) of VBA code.
I am about to leave the company and I have finally succeeded to have everything stored in an Access DB, as I could not guarantee for the data integrity in Excel once I have left. It took me a lot of effort to convince my boss to use Access in the first place. I have now transferred over 40.000 records and I need some advice on the table structure/relationships between them. Here is the model:

Let me explain in detail what we do and then my question:

A customer goes to a supermarket, buys his/her groceries and drops them off at the customer service desk. One of our couriers then goes to a shop and delivers the groceries. Shops are supermarkets, department stores and some smaller specialty shops.  So I record the name of the shop and the customer and save it to Access.  However, we also provide deliveries for flower shops and beverage/wine shops.  As these shops tend to have one-time customers (like flowers sent as a present, or the occasional wine order), we decided not to record these customers. Instead, we set the shop and the customer to be the same and added the delivery address to a memo field in Excel.  Apart from that, shops cannot have deliveries to themselves and rarely can end customers/consumers have deliveries from them them to another place. For …
Hi All,

Please see attached. I'm trying to edit the file location of a database path that was set to unc, we need to change it to the local drive of the server.  There is no option to edit the path, tried to take off line. Using SQL Server 2012

The new generation of project management tools
The new generation of project management tools

With’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

I am using MS Access as the front end (Microsoft Office 365 ProPlus) and currently have a SQL2008 server. I am migrating to a newer SQL 2014 server and are experiencing issues with code written using SQLDMO while testing in the new environment. I have an SSIS job that is called using the now deprecated SQLDMO that is obviously failing in the new environment. I am having limited success finding how to use SQLSMO in a similar fashion. Can someone please give some general direction (or specific!) so that the application can call these jobs in the new SQL server 2014?

Here is the code snippet we use:

Private Sub Command45_Click()

   Set objSQL = CreateObject("SQLDMO.SQLServer")
   ' Leave as trusted connection
   objSQL.LoginSecure = True
   ' Change to match the name of your SQL server
   objSQL.Connect "Server2K14"
   Set objJob = objSQL.JobServer
   For Each job In objJob.Jobs
      If InStr(1, job.Name, "SSIS Bills") > 0 Then
         MsgBox job.Name
         MsgBox "Job Started"
      End If

End Sub

Thank you, and please let me know if I have failed to provide necessary information.
the two servers involved are sql 2014 and sql 2016
Our billing system is an OLTP database and it is very hard to report off of.   I have been reading on OLAP and ssas.  Is there a good manual or starting place for a rookie to try to overcome the reporting issues.
any ideas on should i start with trying to use ssas or creating an olap database from the online transactional database.

In a modern Oracle 12.x RAC database and all things being equal, would it be advisable to explicitly create an ACFS file system for storing shared files or would ASM be more appropriate (like Wallet files etc.)?

  • You do not want to store the files locally on each node if possible.
  • You do not already have an ACFS file system but do have ASM (because you have a RAC).

I am basically looking for the current best practice in storing shared files as seen in the industry.  What has the best ROI etc.


I need some consultation about development own ERP system.
We use PHP7 Symfony framework.
I want to design solution as microservices architecture. use some service as core and several services for connecting to core and obtain data.
core service connect to database via ORM. Which database can we use fro this solution.
can we use shared table database for multitenant architecture.

I need your advice for this solution.
I have experienced some management issue with our current 6.0 U3b VCSA as well as services on the VCSA reporting errors. I want to move forward with deploying a fresh appliance but wish to migrate the existing appliances vPostgres database over to retain my configuration and historical data. I found VMware KB which explains the process of backing up and restoring the database but have some additional questions.

1. Does the replacement VCSA need to have the same hostname and IP Address?
2. Once the vPostgres database is restored, do i simply power off the old VCSA? or should i log into each host individually and disassociate them from the old VCSA and register them on the replacement?
Option Compare Database

Dim RS As ADODB.Recordset

Private Sub Form_Load()
Dim RS As ADODB.Recordset

Set RS = New ADODB.Recordset
RS.Open Me.RecordSource, CurrentProject.Connection, adOpenStatic, adLockOptimistic
If RS.RecordCount = 0 Then
    MsgBox "There are no existing records to edit! Please go to the add form to create some!"
End If

End Sub

I get error messgae user defined type not defined?
What are the advantages of installing my application and backend database in Program Files and Program Data rather than my own Folder in the C-Drive?

Thanks in advance

I need to convert the backend database of my application from an mdb to an accdb.  I have about 200 installations so I need to do this as a data conversion in VBA.

I am considering:
  1. Installing an empty accdb containing the tables but no data.  
  2. Then, for each table in the mdb, adding the records to the corresponding table in the accdb.  
  3. Finally, unlink the table in the mdb and relink to the tables in the accdb.

Does this sound reasonable or is there a better way?

Thanks in advance

Can I use a JDbC Type 4 driver to allow the  'Application' to fail over to the standby DB if the connection has been lost to the Primary

Can I use the this JDBC Type 4 driver with a Oracle Data Guard with a Primary / Standby (not a RAC) for versions 11.2 and higher ?

7 new features that'll make your work life better
7 new features that'll make your work life better

It’s our mission to create a product that solves the huge challenges you face at work every day. In case you missed it, here are 7 delightful things we've added recently to monday to make it even more awesome.

I have used the following tutorial and code to implement a  youtube lazyload function in my website so that it doesn't take an age for all my YouTube videos to load on my page - Link to tutorial .

I also pasted the full code from the tutorial which I got from here....code used for the tutorial

To tailor it to suit my project, I linked it to my database which has four entries. I replaced the lines:
<div class="youtube" data-embed="AqcjdkPMPJA">
		<div class="play-button"></div>

Open in new window

with the following -
<?php while($song = mysqli_fetch_array($result)) 
													{ 															//WE ARE USING A WHILE LOOP TO POPULATE THE TABLE
													<div class="youtube" data-embed="<?php echo $song['youtube'];?>">
													<div class="play-button"></div>
											  <?php } ?>

Open in new window

So it worked (sort of). The connection with the database was fine. The problem is that only the thumbnail for the example  - AqcjdkPMPJA seems to appears. For the other three entries in my table, the thumbnail does not appear - although the video plays when I click on it.

I wonder, is it an issue with the tutorial in that only a select few thumbnails work, or could I be appending incorrectly? For example, if I wanted to embed, i was putting KmO5J05z3PY in my database table....

Thoughts / advice would be greatly appreaciated. Failing that if anybody can point me in the direction of a simple YouTube Lazloader that works for all thumbnails...

Many thanks

Hello Exchange experts/guru/saviors of my stress!!!!!!

I have been racking my brain on how to fix this issue where one database "SA-DB01" will not replicate to the DR server. The copy queue length keeps growing.

Event ID errors are:

Event ID 4138 MSExchange Repl

Event ID 4374 MSExchange Repl

Event ID 4113 MSExchange Repl

Event ID 1009 MSExchangeFastSearch

Here is my Attempts step by step:

SA-DB01 will not replicate to the DR server. The copy queue keeps growing and the database is on passive failed and suspended.

Attempt Fix 1: Ran an Update-MailboxDatabaseCopy "SA-DB01\SA-EXDR-P01" -DeleteExistingFiles -BeginSeed -SourceServer SA-EX-P01

The copy queue length seems to increase as the seeding is taking place. Then it runs fine for 2-4 hours then craps out me with the error below.

“The seeding operation failed. Error: An error occurred while performing the seed operation. Error: An error occurred while communicating with server 'SA-EX-P01'. Error: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.”

The Database then goes to back to passive failed and suspended. I try to do resume and get the following error:

“The Microsoft Exchange Replication service encountered an error while inspecting the logs and database for SA-DB01\SA-EXDR-P01 on startup. Error: File check failed : Database file 'F:\SA-DB01\SA-DB01.edb' was not found.”

Sure enough, the edb wasn’t there.

Attempt …
    I am trying to extract a serialised field in a MySQL database, put it into PHP, unserialise and make a change to a value called status - I need to update the status field from Pending to Active, then re-serialise and re-upload back up.

How can I do this?


Looking to confirm terminology here.

Scrubbed example: Suppose I have two tables for a running stats database.

Runners, containing fields such as name, address, DOB, team affiliation.
Races, containing fields such as runnerID, date, distance.

In what I think is flawed design, the UI for entering race info contains an entry field for the runner's hometown. If you change it from (e.g.) "New York" to "Chicago" in one race, it will display "Chicago" for all races.

IMO, this field should be display-only on the Race info UI and should be modifiable only on the Runner UI.

Now, to my question: Is "normalize" the correct term I should use to convey this concept?

Trying to use this method to move database from SQL 2008 to SQL 2016.

The job fails and tells me to check the log file for details ... however no log file was created in the specified location.
I am using access to build a database. And I’ve created a form I’ve added a button to print current form. but when I click print it will only print the header of the form






Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Vendor Experts

monday.comMonday Learn more about Monday